Good day, everyone.
Unfortunately, I couldn’t find the information on the forum. Please help me with the following question.
There are 2 applications.
Application 1 - Clients
Application 2 - Procedures. The structure of the application includes the procedure name (text) and the cost of the procedure (number).
The applications are in different workspaces.
Application 1 - it contains client records and has a connection with application 2 where we select corresponding procedures.
I understand that it is possible to perform calculations using automation, but I do not understand how to do it.
Task:
When updating the Procedures field in Application 1, i.e., selecting procedures from the list, calculate the cost of the selected procedures and add the total cost to the Cost field in Application 1.
I have not used any automation in this however if you wanted to do the calculations in an automation rather than live in a calculation field then the easiest way is, I believe get the related roll up the values and sum: