If the date is in the future, the return value will be negative.
This function can be used to determine the age if you have a date of birth field in your form. (that is, result = other_date - today) The return value can be negative if other_date is in the past. Returns the number of days from today to other_date. The return value can be negative if date1 is before date2. Returns the number of days between two dates ( result = date1 - date2 ) The following call can be used in this case: Imagine you have a 'subscription' radio option with three cases: none, basic and advanced with cost 0, 100 and 200. The format of the string value map is "string1 => value1, string2=>value2, string3 => value3 " and so on. This function is useful for including radio groups or list boxes in a formula. If the input is only spaces, it is taken as empty. Returns 1 if empty 0 if there is value in the field. If total is less than or equal to 1000, return 0.Ĭhecks whether the input field is empty or not. If the value entered in the field total is greater than 1000, return 10. General functions if_else(condn, true_part, false_part)Įvaluates the condition 'condn' and returns 'true_part' or 'false_part' depending on the evaluation result of the condition. Note that the arguments to these functions can be fields in the form or constants. The functions can be categorized as Mathematical functions, Conditions, and date functions. There are several functions that you can use in a calculation field.
Calculation field : function reference Calculation field : function reference
0 kommentar(er)
