Best answer

Pull Last Email column from Affinity

  • 12 January 2021
  • 4 replies
  • 117 views

working on an integration between Airtable and Affinity, but I can’t seem to pull the Last Email column from Affinity for a trigger (when last email field updates, triggers action). Is this possible?

icon

Best answer by AaronH 26 January 2021, 03:03

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

What Affinity trigger are you using in your Zap?

Try this one and perhaps followed by a Filter step.

 

@Troy Tessalone Trying to do something similar but getting stuck on the Affinity side before even getting to the integration. Can Zapier only connect to a finite set of Affinity fields? I tried specifying a custom field in “Set up Trigger” and Zapier is throwing the below error, despite the field clearly existing as a column in our Affinity. 

 

 

Userlevel 7
Badge +14

Hi @JitterySloth 

Check out this Affinity article: https://support.affinity.co/hc/en-us/articles/360032958852-Affinity-Triggers-in-Zapier

Field Value Changes

Triggers when a field (default or custom) value changes (addition, deletion, or update).

Triggers on list-specific fields ONLY.

Global fields are not supported as triggers.

@Troy Tessalone , 

Hi @JitterySloth 

Check out this Affinity article: https://support.affinity.co/hc/en-us/articles/360032958852-Affinity-Triggers-in-Zapier

Field Value Changes

Triggers when a field (default or custom) value changes (addition, deletion, or update).

Triggers on list-specific fields ONLY.

Global fields are not supported as triggers.

That is correct. Using “Field Value Changes” will only trigger on specific columns/fields.

There is a workaround, to trigger on global fields and text columns/fields that is normally not triggered by “Field Value Changes.” You can start with “Webhooks by Zapier”, and select “Catch Hook.” It will display a webhook URL (example: https://hooks.zapier.com/hooks/catch/4922923/ovsve/). With the URL you can make your own custom trigger. You can enable the webhook by sending the link to our Support team to have them enable it for you. Or you can enable it by https://api-docs.affinity.co/#get-a-specific-webhook-subscription

Once you have the webhook enabled, you can create a custom filter. IE, only trigger on an Org that has “Open” status, or anything you want.

 

There are a few columns that you can do this with. One is the “Last contact column.” This is because, you might have a back and forth conversation, your Zap will keep triggering everytime someone respond back.

 

 

Back to the original thread about pulling last contact. @dank Happy to connect with you via email, feel free to reach out to support@affinity.co.