Frazer_McLeod - profile

Frazer_McLeod · Jan 05, 2023

Hi everyone! We were stumped on this for a while and couldn't find any workarounds. So here's how to extract the next date in a series of dates inside of an array or a rollup from another table.1. Convert your dates to UNIX and wrap them up in a VAL...

Frazer_McLeod · Apr 12, 2020

Hi Airtable community, This is my first time using Airtable, so sorry if this is simple! I am trying to set a ‘finish time’ by taking the booking date & time and adding the ‘duration’ too it which is coming from a lookup from another table. Naturally...

Frazer_McLeod · Dec 07, 2022

Nice! I was looking for this for ages and couldn't find it anywhere. I wanted a slight variation where "If the cents = .00, truncate it, else, leave the cents in. e.g. $32.00 --> $32 | $32.10 --> $32.10For anyone wanting this solution in the future, ...

Frazer_McLeod · Apr 12, 2020

Hey @mohamed_swellam, thanks for your quick reply. The duration is set to h:mm in both the table and the lookup field. Any other ideas? Thanks

User Statistics

User Activity

Find the "Next Date" from a series of dates in a rollup / lookup / array

Setting the Finish Time by adding duration onto base date & time in a booking system

Re: Convert Currency (dollars & cents) to plain text so shows cents .00

Re: Setting the Finish Time by adding duration onto base date & time in a booking system