Hi @Elsa_Luciani and welcome to the community!
You could use automations to duplicate every record from 2 tables into a new 3th one (using “create record” and skipping the “find records” and/or using 2 automations, 1 for each form via the new “when a form is submitted” trigger) or you could combine the 2 forms into 1 table and work with 2 views (1 for every form that shows the relevant data) or you could sync to 2 tables into 1.
Hi @Elsa_Luciani and welcome to the community!
You could use automations to duplicate every record from 2 tables into a new 3th one (using “create record” and skipping the “find records” and/or using 2 automations, 1 for each form via the new “when a form is submitted” trigger) or you could combine the 2 forms into 1 table and work with 2 views (1 for every form that shows the relevant data) or you could sync to 2 tables into 1.
Hi ! thank you very much for your prompt answer ! If I understand what you suggest I would have 1 table with the following raws
Company / Form 1 / Form 2
1- Company 1 / yes / blank
2- Company 1 / blank / yes
But how to have on the same raw ?
Company / form 1 /Form 2
1- Company 1 / yes / yes
Thank you very much !
Hi ! thank you very much for your prompt answer ! If I understand what you suggest I would have 1 table with the following raws
Company / Form 1 / Form 2
1- Company 1 / yes / blank
2- Company 1 / blank / yes
But how to have on the same raw ?
Company / form 1 /Form 2
1- Company 1 / yes / yes
Thank you very much !
Well, you could make 1 table with all your clients names and 1 with the 2 forms. If you make a linked field between the tables, you could prefill the clients name when you send them the forms. That way, you get 2 entrees in the table with the forms (1 for each form), but you could use a lookup/rollup in the table with your clients names, to see which form they filled in. Then you can make an automation to send them an email in case x or y (eg trigger based on a formula field that says “send reminder” at date a or b).
That would be my first thought of doing this 
Well, you could make 1 table with all your clients names and 1 with the 2 forms. If you make a linked field between the tables, you could prefill the clients name when you send them the forms. That way, you get 2 entrees in the table with the forms (1 for each form), but you could use a lookup/rollup in the table with your clients names, to see which form they filled in. Then you can make an automation to send them an email in case x or y (eg trigger based on a formula field that says “send reminder” at date a or b).
That would be my first thought of doing this
Thank you sooooo much !
Thank you sooooo much !
Glad I could help! Would yo mind marking my comment as the solution to your question? This helps others who may be searching with a similar question. Thanks!
