I have an intake log that has a form for parents of child patients to complete in order to apply for services. I have added logic that allows the user to complete the patient's address. Then, I ask the question of "Is your address the same as the patient's" (Yes/No).
If yes, I want the parent's address fields to populate with the address provided for the patient.
If no, the person is then prompted to complete their own address.
I then populate each of the address attribute fields with logic like below:
=IF([GUARD1_ADR_SAME]@row = "Yes", [PATIENT_ADR1]@row)
Since I cannot put column calculated fields on a form, I make sure that the calculation is in at least two rows.
Here is the issue. If an applicant says No, it overwrites the cell formulas in that row with what the applicant wrote in the form. Then if the next applicant says YES, the formula is now not working (since it does not exist in at least two rows.
I can think of some hacks for this that would include me having a bunch of helper columns that are not overwritten by form fields and then use those helper columns to send into the document generated (for Docusign). But I am hoping someone has a better idea.
Thanks in advance.