![]() ![]() ![]() For example, you could create a new view in your “Artwork Bids” table that filters your records to only show you the records which have the value “Newest Bid” for that formula field. Then, once you have that formula created, you have a lot of flexibility to do whatever you’d like to do. You can give each page properties like due dates, assign them to specific people, and view, filter, and sort through them as a database tablebut you dont get anything close to the same raw power you get with Airtable. So, for example, your formula could look something like this: Then, while you are still in the “Artwork Bids” table, you will want to create a formula that compares your new lookup field to the created date, and returns a result to let you know if that is the latest bid for that particular item. So now, for every single record, you will see the newest bid date for that item. Next, go back into your “Artwork Bids” table, where you will want to create a lookup field that looks up that brand new rollup field that you just created in the “Seller Details” table. ![]() How it works Learn the basics Security Trusted by 2M+ businesses Features Build flexible workflows App integrations Explore 6,000+ app connections Whats new. Zapier Automation Platform No-code automation across 6,000+ apps. Use the rollup formula MAX(values), which will give you the latest bid date for that particular item. Zapiers automation tools make it easy to connect Airtable and Copilot. This is a little bit tricky to setup in Airtable.įirst, you’ll need to go to the “Seller Details” table in your Airtable base, and you will need to create a Rollup field which points to your “Created Date” field in your “Artwork Bids” table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |