
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 15, 2023 10:19 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 15, 2023 12:50 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 15, 2023 11:03 AM
Hey @Gerard_Blokdyk will the field always just be the value of "SUM"? If so instead you could use a formula field like this:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 15, 2023 11:41 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 15, 2023 12:49 PM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 15, 2023 12:50 PM
solution
