Forum Discussion
BrianDunk
Qrew Cadet
Also, what do you mean by "scalar field"?
------------------------------
Brian Dunk
------------------------------
------------------------------
Brian Dunk
------------------------------
MarkShnier__You
3 years agoQrew Legend
The [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
------------------------------
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
------------------------------
- BrianDunk3 years agoQrew CadetYes the [Budget Item ID#] is Numeric. It is also a key field if that matters.
------------------------------
Brian Dunk
------------------------------- MarkShnier__You3 years agoQrew LegendForm 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
------------------------------- BrianDunk3 years agoQrew CadetI created the mirror formula field and my current form rule looks like the below.
I don't see the option to "Copy" as an action. Isn't the [Budget Item ID#] field going to change everytime I save a new record? How do I get it to point back to the original record that was used for the copy?
------------------------------
Brian Dunk
------------------------------