I’ve tried adding the looping feature at various points in this zap and no matter where I put it it does not find and update more than one record. I’m not sure I am understanding how this works and there is little information online on how to use this feature. So what I’m trying to accomplish is if I have one invoice pdf in google sheets named 222.pdf I want it to update multiple records with the matching field name 222.pdf. Update record in Airtable- that invoice pdf links to the Invoice field 222.pdfįind record in Airtable- It searches for a field value matching the title of the pdf. New pdf file in folder in google drive- ex. It still is only attaching an invoice with the first record it finds with the matching pdf name. I have attempted to mess around with the looping zap and cannot find a way to find all those with the same invoice name to attach the same invoice pdf to all of them. Returns the square root of a nonnegative number. (You must give a value for the precision or the function will not work.) Rounds the value to the number of decimal places given by "precision," always rounding up, i.e., away from zero. Rounds the value to the number of decimal places given by "precision," always rounding down, i.e., toward zero.
Rounds the value to the number of decimal places given by "precision." (Specifically, ROUND will round to the nearest integer at the specified precision, with ties broken by rounding half up toward positive infinity.)
Rounds positive value up the the nearest odd number and negative value down to the nearest odd number.Ĭomputes the specified base to the specified power. Returns the remainder after dividing the first argument by the second. Returns the smallest of the given numbers. Returns the largest of the given numbers. The base defaults to 10 if not specified. Returns the greatest integer that is less than or equal to the specified value.Ĭomputes the logarithm of the value in provided base. If no significance is provided, a significance of 1 is assumed. Returns the nearest integer multiple of significance that is less than or equal to the value. Returns the smallest even integer that is greater than or equal to the specified value.Ĭomputes Euler's number ( e) to the specified power. This function counts both numeric and text values.Ĭount the number of all elements including text and blanks. If no significance is provided, a significance of 1 is assumed.Ĭount the number of non-empty values. Returns the nearest integer multiple of significance that is greater than or equal to the value. To see the below numeric functions in action, and test them out yourself, check out the "#️⃣ Numeric function examples" table in the Formula Playground.
Numeric operators and functions in Airtable Returns true if an odd number of arguments are true.
The value of true is represented numerically by a 1. You can create simple expressions, like in the below example (the formula below would return a single value-so it's an expression): field is the value "To Do" then this would return "Get this started!" An expression is created when you combine values, fields, or formulas together and that combination evaluates to a single value.