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
------------------------------
- Hi Mark, I am trying to create the form rule as you suggested. The key field for the original record would be the key field "Budget Item ID#", however when I am in the form rule builder that field is not available for some reason.
I also tried creating a connection but I don't see the "Create a Conntection" button when I am in Connection Central.
------------------------------
Brian Dunk
------------------------------ - Also, what do you mean by "scalar field"?
------------------------------
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
------------------------------
