Skip to main content
Solved

Strange automation failure


Forum|alt.badge.img+2

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?

Best answer by TheTimeSavingCo

sregorn wrote:

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.


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?

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

4 replies

Alexey_Gusev
Forum|alt.badge.img+23
  • Brainy
  • 1152 replies
  • November 6, 2024

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.

 


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 1 reply
  • November 6, 2024
Alexey_Gusev wrote:

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.

 


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
Forum|alt.badge.img+28
sregorn wrote:

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.


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
Forum|alt.badge.img+20
  • Brainy
  • 217 replies
  • November 7, 2024

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.

👍


Reply