This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,I'm using a form so users can enter their data into a table. In that table one field always has to have the value "SUM" I want that every new record to be receiving default “SUM” Thank you
Hello Airtable community,I've been working on a project where users input data through a form, and the results are recorded in the base. I have set up a rollup field for each question to calculate the average of the results per field. Now, I want to ...
Thanks Arthur, that helped, I found the solution. When a form is submitted, find record where the field is empty, get their record id and fill the field with "SUM" Much easier than I thought it would be!
Thanks Arthur, sorry, should have mentioned that the field a link field (to calculate the averages of all participants scores), the value of the field should always say SUM be able to calculate the averages
SOLVED: I use Automations to find the rollup records at a scheduled time (since # of automations is limited per plan per month) and update the record in the separate table used for the graph
