I have three tables: Contacts, Firms, Comments.
All Contact records are linked to a Firm record. Comment records must be linked to the corresponding Contact record AND the corresponding Firm record. This means using two records pickers when creating a new Comment. Instead, I would like the Firm record picker to autopopulate when the user chooses an option in the Contact record picker.
I tried setting a dynamic form rule to take the Contact record's "Related Firm" field and make the "Related Firm" field of the Comment record equal to that. This didn't seem to trigger any change.
Are you clicking the button "Add Comment" from the contact's form? If so, just modify the formula URL field to fill out that field for you from the start. It would be something likea=API_GenAddRecordForm&_fid_10=" & URLEncode ([Record ID#])& "&_fid_12=" & URLEncode ([Related Firm])& "&z=" & Rurl()Where 10 is the fid of the related contact and 12 is the fid for the related firm.
You can also make the "Contact" dropdown be conditional upon the firm, and make your options much more limited.
Hi Matthew, thank you very much for your suggestions, both have worked and have improved our workflow.