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 Arkady, to relate all the Q&A records automatically to the "yes" record, you can set the reference field with a default value. For example, let's say you're using Record ID# as the key field on the table where the "yes". Let's also assume for a minute that the Record ID# for the "yes" record is 1. Then, you can edit the field properties for the reference field and set it to 1.
------------------------------
Brian Cafferelli
------------------------------
------------------------------
Brian Cafferelli
------------------------------
- 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
------------------------------- 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
------------------------------
