Learning Center
Learning Center
Formulas in Ragic work similarly to those used in other spreadsheet applications (such as Excel). However, in Ragic, we reference fields by their Field Headers. Formulas can be used to calculate not only numbers but also text strings and dates. Ragic will attempt to automatically determine the type of formula needed, but specifying the Field Type (for example, Number or Date) helps ensure accuracy.
To assign a formula to a field header from your Form Page, navigate to the Design Mode and select the field header. Go to the Field Settings on the left and enter your formula into the Formula tab. For example, if we want to calculate "Subtotal(G19)", the formula should be "E19*F19" (Unit Price x Qty).
Result:
If "Inventory No." equals "Location Code-Product No.", you can assign the String Formula in "Inventory No." as A9+'-'+A2.
Result:
Ragic supports the use of Conditional Formulas.
If you would like to make "Payment Status" automatically update its value as "Yes", when "Invoice Total" equals "Amount Received", otherwise update its value as "No". You may apply the Conditional Formula as IF(A22.RAW=A21.RAW, 'Yes', 'No')
Result:
Thank you for your valuable feedback!
