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

[Gerard_Blokdyk]

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

[Arthur_Tutt]

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

 

[Gerard_Blokdyk]

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

[Gerard_Blokdyk]

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 · Accepted solution]

solution