Skip to main content
Solved

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


Forum|alt.badge.img+6

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

Best answer by Gerard_Blokdyk

View original
Did this topic help you find an answer to your question?

4 replies

Arthur_Tutt
Forum|alt.badge.img+15
  • Inspiring
  • 118 replies
  • November 15, 2023

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


Forum|alt.badge.img+6

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


Forum|alt.badge.img+6

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!

 


Forum|alt.badge.img+6
  • Author
  • Inspiring
  • 9 replies
  • Answer
  • November 15, 2023


Reply