I am trying to calculate the number of months between today's date and the "Test Date" field. When I use the DATETIME_DIFF formula it does not calculate it correctly for all values. In the Test copy column I have this formula:DATETIME_DIFF({Test Dat...
Most 2FA systems allow you to enter a code manually so you don't have to scan the QR code but there is no option for that in AirTable. My camera on my phone is currently broken and so I have no way I can set up 2FA with AirTable with my authenticatio...
I have created a timeline that summarizes the data. Different ranges are colour coded based on conditions like less then 50 is light blue, between 100 and 200 is orange and anything above 200 is red. This means that values between 50 and 100 are not ...
Yes that is what I was able to determine is that DATETIME_DIFF just appears to count 30 day intervals and not actually months. In the end I did this which worked exactly as I needed it. DATETIME_DIFF( DATETIME_PARSE(DATETIME_FORMAT(SET_TIMEZONE({Tes...
This is not possible with the Attachment field. https://support.airtable.com/docs/two-way-syncing-in-airtable this guide lists it as a limitation to two-way sync.
It is not the preferred option as then I have to set a colour for the 50 to 100 range which we wanted to leave un-coloured. We didn't want to end up with a rainbow as we find that a bit over whelming. There is no white colour just light grey. That is...
