I desperately tried for 3 days to solve this problem, could you help me ? I have 2 forms I ask my clients to fill. each form fills a separated table in the same base. Form 1 and Form 2. to do the folllow up I would like to create a “follow up table” to see which companies filled form 1 and form 2, and to be able to send reminders to the companies that just filled form 1. I tried with automations ( find records based on the company name) but it did not work. I would like to have a " follow up table" with the name of all the companies that filled either form 1 and form 2, and being able to see in the fields Form 1 and Form 2, if they filled both. ( the ones that just filled 1 form would receive an automated email if I manage to create the automation :slightly_smiling_face: )Could you help me ? thanks a lot !
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.
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 :slightly_smiling_face: