-
Sum a duration field in the correct format
I have a database where I am keeping track of incoming calls. I have a field where I keep track of the duration of the call in this format minutes:seconds. Currently I have this formatted in a text field. I need to sum up these duration values and return them in this format hours:minutes:seconds. Does anyone know how I can…
-
Complex Financial Functions
Airtable has been very useful to me because of their ability to perform Excel-like functions. For example this monthly payment formula can be done by reference other fields in a record: {Loan Amount}*({Monthly Rate}*POWER(1 + {Monthly Rate}, INT(Amortization)*12)) / (POWER(1+{Monthly Rate},(INT(Amortization)*12))-1) From…
-
Add an average and median math filters for arrays
Currently, we have sum, max, min and product math filters that we can perform on arrays, but no median or average filter. Would be great to have a median and average math filters that we can perform on arrays as well.
-
Date/Time - Checking age verification prior to 1/1/1970?
When converting a date/time to a unix time stamp, how can I check if a user is older than 18yo, 21yo, 59 1/2, and 72 years old? If the user is older than Jan 1, 1970, the negative number is _less than_ 72 years. Seventy-two years in seconds is 2,264,371,200. Seventy-two years in epoch/unix time is -631,152,000 (negative…