I’m not much of a coder, and still a bit of an Airtable n00b. However, when I try to use comma as a separator, I only get the string of records back as the output, not the individual records. Then, after processing the record, you set the mirror field to the actual field’s value once more to mark it as processed and remove it from the view. In the past, I’ve used Zapier’s Text module to separate text into separate fields using :space: or :return. When a field is updated, if it does not equal its mirror field, the record enters the event trigger view. You can also use what I call “mirror” fields, which mirror the value of another field. To remove the records from the view after processing them, sometimes we mark the records with timestamps and have our event trigger view filter on whether those timestamps are filled in or not. We then have a perpetually running python process on AWS poll the Event Triggers table every so often to get this list of views, and check each view for records to take action on. Each record in this table has the url for an event trigger view, and a Zapier webhook to call to take action when a record is found in that view. To do this, we keep a central table called “Event Triggers”. Each one of these views has some filters set, so that when a record matches some criteria, it enters the view, we pick it up using the Airtable API, take some action like posting a notification to Slack, then update the record so that it is removed from the view. We can’t see into your Zaps so screenshots are always welcome, just remember to remove/hide any private info like names, email address from them before sharing.Our current method of reacting to changes in records is to use what we call “event trigger” views. ![]() We recommend that all users migrate to Personal Access. Webhooks created with User API keys will not expire, but can no longer be created. After that date, API Keys will no longer be able to access the Airtable API. In the toolbar of the Power Query Editor, select Manage Parameters. As this is a major change to the Airtable API, the API Key deprecation period will last for 12 months and end on. In the dropdown menu, select Blank Query to open the Power Query Editor. Action: Update (insert your record type here) IMPORTANT: In order to do this most efficiently, you’re going to need an action in your app that allows you to find an item and create one if it’s not. ![]() Any screenshots showing the current set up of the Zap’s actions that could help to give us folks in Community a bit more context would be much appreciated. Create a new Power BI document and select Get Data from the Home toolbar. Action: Find/Create (insert your record type here) Filter: Only continue if the record is found. My goal was to transfer the entries from the last day (there was already a view for this) to Documint in order to output them on a report. and also thanks to GetUWired - Your suggested solution worked for me. If that’s not what’s happening here, would you mind sharing some further details on the issue. thank you, robschmidt - I didnt know that you can only retrieve one record at a time. Do you think that could be the case here? I’m wondering if a difference in what’s present in the record and what’s being searched on might be what’s preventing the Zap from finding the record. If yes, what information are you searching on - is it the event name or date for example? And does the information you’re searching on differ from what’s in the record for the event? I just want to double check that I’m understanding the issue correctly here. Is it that the Zap that has Find Record and Update Record (Airtable) actions isn’t finding the correct record? Hey thanks for joining the Community here! □
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |