Save a value in a record automatically

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I would like to categorise records by adding one of two descriptions to a field depending on a field value in the parent record.  The background is that I am using same child table to deal with two subjects. Will appreciate some insight.   

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
I think you might have already got an answer for this, but if not,  You will want to pass this unique value through in the formula -URL field that you press on the parent record.

Something like:

&_fid_55="&URLEncode([Parent Option Field])&"

*of course make sure you match up the correct field id and parent field*
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 3,246 Points 3k badge 2x thumb
Alternatively, you can pass down the categories as Lookup fields from the Parent; and then use formula-fields inside the child to determine which record uses which category based on other logic.
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Then you have to make a form rule to translate to the field already in production.

Make a new field, make the formula, make a dynamic form rule, that needs to to translate information right away (which can't happen, you need some other action to trigger it)

vs.

Modify an already existing button.

Your needs might dictate one or the other, or you might have already solved it.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks a lot for your support on this.