Help

Recording a new entry with an automatically assigned default value in a single field.

Topic Labels: Automations Base design Data
Solved
Jump to Solution
1847 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Gerard_Blokdyk
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Gerard_Blokdyk
6 - Interface Innovator
6 - Interface Innovator
4 Replies 4
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @Gerard_Blokdyk will the field always just be the value of "SUM"? If so instead you could use a formula field like this:

Screenshot 2023-11-15 140301.png

Gerard_Blokdyk
6 - Interface Innovator
6 - Interface Innovator

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
Screenshot 2023-11-16 at 5.38.18 am.png

Gerard_Blokdyk
6 - Interface Innovator
6 - Interface Innovator

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!

 

Gerard_Blokdyk
6 - Interface Innovator
6 - Interface Innovator

solutionsolution