_Zo - profile

_Zo · Dec 01, 2019

Has anyone experienced Airtable doing strange things with dates… it appears there is an invisible conversion happening… I have a string ‘2019-12-13T15:00:00.000Z’ I pass it via airtable API check this out to a date field with time… = “12/13/2019 . 9...

_Zo · Jul 30, 2020

You cant as of yet. Coming soon though if you know javascript and can work with Airtable Custom Script blocks You can certainly create views and / or write code to click a button and have something happen if a change occurred But theres nothing that ...

_Zo · Jul 30, 2020

Sounds good! Also if you decide to go the automation route, I have a short video where I demo migrating records to a different table and an entirely different base.

_Zo · Jul 29, 2020

The simple way… Have a table with Client and Assessment… The Assessment table has a column for each assessment. Include a “complete” flag and a link to the client table. If you later added 5 more assessment columns it would be very easy to create a v...

_Zo · Jul 29, 2020

1.) You would use a Search function to search for the first space " " in the string which would be right after the number. SEARCH(stringToFind, whereToSearch,[startFromPosition]) 2.) Then you would use a LEFT function to extract the results from Sear...

_Zo · Jul 28, 2020

Hey there, The only way to ‘move’ records across tables and bases would be either via a custom script block or a tool like Integromat or Zapier… Keep in mind you will lose record comments but if you dont use those you are good to go!

User Statistics

User Activity

Airtable API Date ISO format

Re: Are there any triggers in AirTable?

Re: Out of stock items moving to a separate table so they are not included in the main one?

Re: Can Airtable meet this use case?

Re: How do I put a shortened version of an address into a formula?

Re: Out of stock items moving to a separate table so they are not included in the main one?