Mark Johnson

Commented on Conditional Column Setup: Handle Error in Lookup F...·Posted in02 Support

I can't find "iserror" or "isblank" referenced in the documentation anywhere. Are those even valid functions or did your chatbot hallucinate them?

Posted in 02 Support·

Mark Johnson

Conditional Column Setup: Handle Error in Lookup Function

I'm trying to set up a column so that it only runs if another column dooes not have data AND that column did not return an error. I'm using this formula for the conditional: !{{Lookup Contact by LinkedIn}} That correctly returns true if the {{Lookup Contact by LinkedIn}} column did not return results, but it also returns true if the reference column returned an error.

3Comments

Commented on Airtable Sync Issues: Connection Stuck and Records...·Posted in02 Bugs

Mark Johnson

I can understand that there might be a functional limit on the number of records that clay could retrieve based on Airtable's rate limits. But how can I be sure this is a result of a rate limit and not something else entirely? The status message on the source doesn't give any information about what's going on, how many records have been pulled, the percentage of total records that have been, when it the update was started, or when the last update finished. How can I be sure that something hasn't broken completely? If there is a maximum number of records for an airtable source, can I know what that limit is so that I can stay below it? Airtable says "there is a limit of 50 requests per second for all traffic using personal access tokens from a given user," so realistically I can't see why my airtable base of around 3500 records would cause the source to run indefinitely

Commented on Airtable Sync Issues: Connection Stuck and Records...·Posted in02 Bugs

Mark Johnson

Hi Bruno - I'm not sure that makes sense. I can understand that there might be a functional limit on the number of records that clay could retrieve based on Airtable

Commented on Airtable Sync Issues: Connection Stuck and Records...·Posted in02 Bugs

Mark Johnson

https://app.clay.com/workspaces/492338/workbooks/wb_RC6W9Viha4qA/tables/t_sqUM3BHJRhaR/views/gv_S3TuTdJqF93z

Posted in 02 Bugs·

Mark Johnson

Airtable Sync Issues: Connection Stuck and Records Missing

My scheduled airtable source is stuck - The blue info box has shown a spinning circle for multiple weeks now and many of the airtable records are missing. It seems as though the sync will not complete. I have attempted to reauthorize the airtable connection, but no luck there.

1 attachment

9Comments

Commented on Airtable Create Record Integration Fails Due to Ra...·Posted in02 Bugs

Mark Johnson

Thanks for the update! Will do.

Commented on Airtable Update Integration Issue with Multiple Se...·Posted in02 Support

Mark Johnson

Sure thing!

1.
Create a formula in clay that returns true if you want to add a multi-select option to the record in the row (must be checkbox column type)
2.
Create a checkbox field in airtable that you'll use to identify a record that needs a multi-select option applied
3.
Use the "update record" airtable enrichment to update the record with the Clay column you created in step 1 mapped to the AIrtable field you created in Step 2.
4.
Set up an automation in Airtable to trigger when the checkbox field is updated and filter it so the automation is only run when it is checked.
5.
Edit the record that triggered the automation to apply the multi-select option you want. Editing the multi-select field in an automation will overwrite any previously selected options. If you need to persist those existing options, you can use a script step to append your new option instead of overwriting (ChatGPT o1 was able to write a script that did what I needed it to on the first shot).

It's messy, but it works 🙂

Commented on Issues with Airtable Data Updates in Clay Integrat...·Posted in02 Support

Mark Johnson

Thanks!

Commented on Issues with Airtable Data Updates in Clay Integrat...·Posted in02 Support

Mark Johnson

Bo (Clay) thank you for the clarification. I think I've got enough direction to do what I needed to do. Could you please remove the video from the slack thread and https://community.clay.com/x/support/uuwcz4r7zczc/issues-with-airtable-data-updates-in-clay-integrat since it shows some sensitive data from our CRM?

About

Country
My Company Website
Title