Strange automation failure

[sregorn]

This automation is designed to automatically update two fields of a newly created record submitted via form. Neither of the fields being updated by the automation is "Formula Name", which is the field that appears to be causing the failure. Anyone have any idea what is going on here?

[Alexey_Gusev]

Hi
Formula field cannot be updated, because it is computed. For example, you have fields Quantity, Price (both Number) and the field Amount with formula Quantity * Price. When you have Quantity=5 and Price =20, The Amount will be 100 and you cannot put other value in it, unless you change formula or change field type.

[sregorn]

Hi Alexey,

Thank you for your reply. Yes, I understand how computed fields work. The strange thing about the automation failure is that I am not asking the automation to update that field; the computed field ("Formula Name") is not mentioned or used at any stage of the automation. It is other, non-computed, fields that the automation is supposed to be updating.

[TheTimeSavingCo · Accepted solution]

Is "Formula Name" the primary field of a linked table and are you trying to update the linked field to that table?  If so, that might be the issue

If not, could you provide screenshots of the automation set up, the fields you're updating, as well as the field "Formula name" in the table?

[dilipborad]

Hello @sregorn, 
First of all when you choose fields from the list of fields in the Automation Action of "Update Record". At the time of field selections, you see the message "This field can not be used because it's computed" that any of the fields that are used from formula or computed generated fields.

As @TheTimeSavingCo & @Alexey_Gusev suggest they are also absolutely right about what was explained.

The important thing here is that you can't select a computed field on that action.
Not sure but just for cross-verification I also recommend you to cross-check the datatype of the field that you're trying to update and also check what is data you're giving to them.

If still not fixed then come back and share all the processes you're trying to accomplish. Explain your table structure and also add a couple of screenshots with sample data you're used with it.

👍