Placeholder

Customer Forum

Applying Formulas to Created Fields

External Posted: 2013-07-02 18:28

 Good Afternoon,

 

Is it possible to create a custom field to which you can apply formulas? For example, I have three currency fields: Domestic Air, International Air and Gross Air.

 

Would I be able to create the Gross Air field such that it would be the sum of the Domestic Air and International Air fields?

 

This would be useful as it would eliminate any user-error so that if they filled in the three fields, the gross air would always match the domestic air + international air fields.

 

Thanks,

 

Nathan

Workbooks Support Posted: Thu, 04.07.2013 - 13:12

Hi Nathan

Unfortunately you cannot apply formulas to fields in Workbooks at this moment in time. However it would be possible to create a button/on save process, through PHP scripting, which calculates this value for you. Further information on the Workbooks API can be found here.

Kind Regards

Support