In case it helps someone in the future, you need a third table with NAME of the people filling out the form. You can then do a link+rollup for form submissions on the NAME table. Then do a link+lookup field in the table with NAME and FORM_COMPLETED, brining in the rollup field. From there, just do an IF rollup > 0, FORM_COMPLETED = Yes, FORM_COMPLETED = No
If anyone has a need, just reach out to me :thumbs_up:
From what I understand you’re trying to link table (A) to a submission database (B) that will essentially confirm whether or not an individual has submitted their form.
I would first link the Names field from the submission database (B) to table (A). Then generate a rollup field in table (A) that references a field that has to be filled in your form for it to be submitted(Perhaps FEEDBACK_SCORE?) with a formula looking like the following: