Formula field in another formula field.

[AnchovyXL]

How can I use a formula field in another formula field within the same table?

[JolliBeng]

Hi AnchovyXL,

As far as I know, you cannot directly insert a formula field to another formula field. You need to copy the whole formula from your field 1 to field 2.

 

-JolliBeng

[Vitalikssssss]

Hi @AnchovyXL ,

You may consider using Triggered Action if you need cross-table calculation. 

https://howto.caspio.com/tables-and-views/triggered-actions/

Hope this helps.

Regards,

vitalikssssss

[HampasLOUpa]

19 hours ago, JolliBeng said:

Hi AnchovyXL,

As far as I know, you cannot directly insert a formula field to another formula field. You need to copy the whole formula from your field 1 to field 2.

 

-JolliBeng

This is correct. For example.

Your Formula Field 1 has this formula:

[@field:First_Name] +' '+ [@field:Last_Name]

and then your Formula Field 2 has this formula: 

[@field:Balance] +  [@field:Current_Amount] -  [@field:Amount_Paid]

and you want your output to be like this:

"Jolli Beng  balance is $50"

You can put all those formula in one field. It should look like this:

[@field:First_Name] +' '+ [@field:Last_Name] +' balance is '+ ([@field:Balance] +  [@field:Current_Amount] -  [@field:Amount_Paid])

Note:

To do this, make sure that the names have the same Data Type otherwise, you should use Cast or Convert to change the Data Types.

[kpcollier]

@Vitalikssssss How do you create formulas inside of a trigger?