Orin_Hutchings - profile

Orin_Hutchings · Apr 06, 2021

It used to be you could add a comma delimited line of text such as “Car, Tree, Fish, Dog” to a Multi-Select field type, and it would separate the values. When passing that data from one app to another, keeping that same format caused no issues. Now i...

Orin_Hutchings · Jan 06, 2022

Hi @Sam_Bradley, As a third-party solution, you can use zzBots to set up a bot that will automatically flag any duplicate records in your table based on customized conditions. For example, you can have your bot check the name or date of the equipment...

Orin_Hutchings · Apr 07, 2021

Thank you for your response, this is very helpful. I will double-check to see if we are using the REST API with typecast enabled.

Orin_Hutchings · Apr 07, 2021

Hi @ScottWorld, For further clarification, the problem is not that we can’t separate the comma-delimited line of text. Previously, if you passed a comma-delimited line of text into Airtable from another app, Airtable would accept that format. (Ex: [C...

Orin_Hutchings · Dec 02, 2020

I commented on this thread several months ago with one solution to this problem. You can create a bot using zzBots that will integrate with Airtable and automatically flag duplicate records. It will allow you to require a unique value for any field t...

Orin_Hutchings · Nov 05, 2020

Hi @Andrew_Bull, As a solution for this, you can use zzBots to sync both new and updated rows 1-Way from Google Sheets to the corresponding record in Airtable. Like you said, there are a lot of options for the 1-Way Sync for new records to sync as ne...

User Statistics

User Activity

Were the "Multi Select" and "Linked Record" field type formats changed to an Array?

Re: Formula to reveal duplicate rows

Re: Were the "Multi Select" and "Linked Record" field type formats changed to an Array?

Re: Were the "Multi Select" and "Linked Record" field type formats changed to an Array?

Re: An option to require Unique Values for any given field

Re: 2 Way Sync with Google Sheets & Guest Editing