Establishing relationship automatically
Hello, I am working on survey report. Depending on survey outcome, I'd like to request additional notes. Structure is as follows: Require Notes (yes/no) -<Survey Q&As -< Notes I am trying ...
Forum Discussion
Hi Brian,
Thank you. I believe I am allowed to set field containing "yes" or "no" answer as a key field. As the table has two records, key field will be unique. This way I should know the record I need.
What I have not figured out is whether I can use formula to set value to Related Require Note fields in Survey Q&As and Notes tables. I do not want to do this using Dynamic Form Rules in QB forms as records will be added and edited using Grid Edit.
I suspect Automation might be the answer.
What do you think?
Arkady
------------------------------
Arkady
------------------------------
Thank you. I believe I am allowed to set field containing "yes" or "no" answer as a key field. As the table has two records, key field will be unique. This way I should know the record I need.
What I have not figured out is whether I can use formula to set value to Related Require Note fields in Survey Q&As and Notes tables. I do not want to do this using Dynamic Form Rules in QB forms as records will be added and edited using Grid Edit.
I suspect Automation might be the answer.
What do you think?
Arkady
------------------------------
Arkady
------------------------------
Yes, you can set a text field to be the parent table's key field. If you do, then your reference field would also be text. I like how you're thinking about this, and I recommend building a pipeline to fill in that reference field.
The pipeline would trigger when the record is created, and move the text value into the reference field. That way it will be consistent, even when your users are in Grid Edit mode.
------------------------------
Brian "Actual" Cafferelli
------------------------------
The pipeline would trigger when the record is created, and move the text value into the reference field. That way it will be consistent, even when your users are in Grid Edit mode.
------------------------------
Brian "Actual" Cafferelli
------------------------------
