Skip to main content

I have a table (Table #1) in which we keep upcoming events, along with their dates, topic, marketing content etc. I created a mirror table (Table #2) with the same fields. Table #2 has a form our staff uses when they need to update any of the events that are in Table #1 (existing records). I created an automation that when a form is submitted in table #2, it finds the records in table #1 that match the name of the program and then updates the existing record.

Here's where I am stuck and wondering if there are solutions:

1) Finding the records: My conditions are the name of the program and the date, but the issue is with the date. I'd like Airtable to only find it if it's the exact date in both tables and not a range of dates. Is there a way to do this?

2) Updating the records: when staff submits a form, they may ask for the topic (field) to be updated, but will leave the content (another field) blank because that didnt change in their program. When the automation find the record and updates it, i dont want it to override existing content with the blank content. Is there a way to have additional automation logic that basically says, updates this record only with the form fields that weren't submitted empty?

Matching on names and dates isn't 100% reliable but might serve your purpose fine. Another approach is to put the linked record field between the two tables on the form so that updaters can choose an existing event. Your automation could then process the form such that if there is linked record, update it with the form values, otherwise, create a new event. You can specify which fields to update in the Update Records action and also make certain fields required on your form to prevent needless update submissions.

Hope that helps!

Matching on names and dates isn't 100% reliable but might serve your purpose fine. Another approach is to put the linked record field between the two tables on the form so that updaters can choose an existing event. Your automation could then process the form such that if there is linked record, update it with the form values, otherwise, create a new event. You can specify which fields to update in the Update Records action and also make certain fields required on your form to prevent needless update submissions.

Hope that helps!


Thanks!! Can you clarify what you mean when you say "put the linked record field between the two tables on the form"? Do you mean to create a 3rd table that all the records from table 1 will be linked in? Then the form on table 2 pulls from that? 

Thanks!! Can you clarify what you mean when you say "put the linked record field between the two tables on the form"? Do you mean to create a 3rd table that all the records from table 1 will be linked in? Then the form on table 2 pulls from that? 


Sure! You have two tables:
Events - every record is a unique event
Even Updates - every record is an update/create submission for an event

You have a linked record field between these two tables that you can physically place on your form so that submitters to Event Updates can choose an existing Event (from the Events table) to update. Your automation can include a conditional action that updates or creates record in Events based on this field.

If you have a truly unique identifier for Events (not name + date... as uniqueness can't be certain), you could use this identifier instead and not require form submitters select an Event in the linked record field as a question on the form. This might be better if your form submitters are bad at checking for existing Events when submitting a form. In that case, I might assign an Event ID and try to socialize the concept with the team.

Please let me know if you have any other questions 🙂

Your best bet for updating Airtable records from a form is to use Fillout's advanced forms for Airtable. No automations necessary, and no extraneous tables necessary.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Reply


Terms & Conditions