Link to Original Record After Copy
I am wondering if it is possible to add a link to a copied record back to the original record? Here is what is happening...I currently have a copy record button that is working as expected. See code...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe copy master detail functionality does not allow you to control the population of any extra fields.
But no problem. Create a process maintained by a Form Rule or a Pipeline that says when the record is saved and the field called [Original Record ID#] is blank, then copy the Record ID# into that field.
And when you run the copy master detail that scalar field will get copied across.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
But no problem. Create a process maintained by a Form Rule or a Pipeline that says when the record is saved and the field called [Original Record ID#] is blank, then copy the Record ID# into that field.
And when you run the copy master detail that scalar field will get copied across.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Also, what do you mean by "scalar field"?
------------------------------
Brian Dunk
------------------------------
------------------------------
Brian Dunk
------------------------------
- MarkShnier__YouThe [Budget Item ID#] field should be a numeric field type, not a formula numeric field. What type is is?
Scalar is just a fancy word that I have heard Quickbase staff use, it just means a data entry field which is not a formula or a lookup field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Yes the [Budget Item ID#] is Numeric. It is also a key field if that matters.
------------------------------
Brian Dunk
------------------------------- MarkShnier__YouForm rules don't like to offer up the Record ID# field for reasons unknown. Just make a new field called [Budget ID# mirror] with a formula of [Budget ID#]
Then use that in the form rule to act as a source to the [Original Budget ID#] field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------