"field "ID" cannot accept the provided value: cannot modify a computed field"
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.
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.
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
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
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.
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.
Great! Yes, field "ID" (where we're getting the error) is a formula field. This is the code:
"
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.