Hey everyone, question related to automation…and maybe rollups? Let me explain…
In my airtable base, I have 2 tables…
one table has the submission data from a form I created. Let’s say it’s an internal company feedback form. The fields are NAME and FEEDBACK_SCORE.
In another table, I have columns with NAME and FORM_COMPLETED.
I’m wondering if there’s a way to automatically change FORM_COMPLETED from ‘no’ (default), to ‘yes’, when someone submits that form.
I’m thinking this requires some type of rollup and other formula, but I’m not experienced enough to know if this is possible. Any ideas?