302 Found

Found

The document has moved here.

Formula Function Reference

Our Formula Function Reference

Mod - Numbers

Arguments: 
(Number n, Number m)
Result Type: 
Number
Explanation: 
Returns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.) You might use this function to auto-assign tasks to staff members. For details, please read Article #308 in the QuickBase KnowledgeBase
Example: 
Mod(7,3) returns 1 Mod(-7,3) returns 2 Mod(7,-3) returns -1 Mod(-7,-3) returns -2 Sample auto-assign formula: If (Mod([Record ID#],ToNumber([number_of_reps])) = 0, ToUser("jsmith"), Mod([Record ID#],ToNumber([number_of_reps])) = 1, ToUser("bboop"), Mod([Record ID#],ToNumber([number_of_reps])) = 2, ToUser("ppeabody"))
Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.