![]() ![]() ![]() I want to architect logic such as “when a user submits a form, send me a Slack message, and send them an email”.If you want to use Webflow as a frontend and Airtable as a backend for your programmatic SEO pages, everything is handled for you! If you want to use Notion as an internal tool for your Postgres database that’s also ready out of the box. This deeper, bi-directional connection is what makes Whalesync so great at specific use cases. If it notices differences, it will immediately make updates to get your data back in sync. Whalesync understands what data you have in both apps and is constantly checking to see if anything is different. To get a little more technical, Whalesync maintains “state” where Zapier doesn’t. Any time you make a change in one app, it syncs to the other automatically. From that point forward, Whalesync keeps your data in sync bi-directionally. Instead, they have a more predefined utility… specifically data syncing! With Whalesync, you connect two of your tools and turn sync on. On the other hand, no-code data syncing is a relatively newer phenomenon.ĭata syncing tools like Whalesync don’t allow you to architect logic like automation tools. ![]() As you can see, automation tools as a category has been around a while. Zapier was founded in 2011 and its predecessor IFTTT was founded in 2010. See our Best Zapier Alternatives post for details on each. You can then use either a rollup with a MAX(values) or a lookup field to pull the last modified time for the linked record(s) into your table.Other popular automation tools include Make, Parabola, N8N, and Alloy. If you would like to know when the value of a linked record field type has changed, you will need to create a new field in the linked table first-either a last modified time field, or a formula field using LAST_MODIFIED_TIME(). This is because you have not changed which record you have linked to, even if its values in the other table have been modified. For example, changing the primary field of the linked record or any other fields that live in another table will not update the value of last modified time. The value of last modified time will change if you add or remove a record from a linked record field, but it will not change if the fields associated with the linked record(s) have been changed. However, if you do want the details of who last changed the records in a linked record field, you can still do this by adding a field to the other table (the Order Line Items table in this example) and then adding a lookup field to the original table to pull in the collaborator name. If the displayed name of an item in a linked record field is updated, the last modified field will not change because the record's update was made in a different table. Items added or removed from a linked record field will display the last modified record field user. You can adjust the field values' formatting by clicking the "Formatting" tab, which allows you to pick your preferred date and time formats and toggle ON/OFF "Use the same time zone for all collaborators" and "Display time zone." Adding last modified by fields in Airtable You can edit your selections by clicking the "Change selected fields" button. Toggle ON one or more fields from the popup.Īfter confirming any selected fields, the field customization menu will show your choices. Toggle ON the “Specific fields” icon to show only the last time specific fields were modified. Search for and select Last modified time.įrom here, a window opens, allowing you to apply the field to “All editable fields” or “Specific fields.” When customizing your last modified time field from the field customization menu, you can adjust which specific values are returned in the "Fields" tab and how the values are formatted in the "Formatting" tab.īy default, the last modified time field will show "All editable fields," showing the most recent time and date a user modified any non-computed field in the table. To determine the last modified time for a formula field using WORKDAY_DIFF(). In that case, you can often include the fields used in the original formula as parameters in the LAST_MODIFIED_TIME(). NOTEįor example, suppose you're trying to determine when the value in a formula field changed most recently. If the value of a computed field changes when a user makes a change, then you can use formula fields and formula function combinations to find out when changes that affected that computed field were last made. Some computed fields can change values due to users making updates elsewhere. ![]() They do not include changes that occur automatically in computed fields-fields where the user doesn't directly edit record values-like formula fields and rollup fields. The last modified time field type and the LAST_MODIFIED_TIME()function reflect changes to editable fields made by a user. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |