Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 09, 2023 05:19 AM
"field "ID" cannot accept the provided value: cannot modify a computed field"
Oct 09, 2023 11:13 AM
Hi @dcdonal - Is the proposal form in the same table as grants? From what I can tell, you shouldn't need an automation to create a record in the grants table. Just submit the proposal form and the record will be created in the grants table.
Oct 10, 2023 05:41 AM
Hi @salvadaor - no, the proposal form creates a record in the proposals table --no problem. But then an automation also runs which creates a record in the "grants" table. The error is happening when sometimes (not always) the automation fails to create a record in the grants table, due to the following error: "field "ID" cannot accept the provided value: cannot modify a computed field"
Let me know if this rings any bells for you
Oct 10, 2023 11:44 AM - edited Oct 10, 2023 11:44 AM
Yeah, it does ring a bell. Can you provide more information on the inputs the automation receiving to create the records in the "grants" table? That error is usually created when you try to use fields that are formula fields OR fields which values are reliant on another field being filled out.
Oct 10, 2023 12:13 PM
Great! Yes, field "ID" (where we're getting the error) is a formula field. This is the code:
"