AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Zapier airtable filter4/10/2024 Filter information with the right view type. 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. In this post, we will be sharing five of our favourite tips and tricks to help demonstrate whats possible to get the best out of Airtable. Connect the apps you use everyday to automate your work and be more productive. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management. Then, once you have that formula created, you have a lot of flexibility to do whatever you’d like to do. Organize anything with Airtable, a modern database created for everyone. So, for example, your formula could look something like this: Octoparse integrates with 6,000 other apps on Zapier - it's the easiest way to automate your work. Instantly connect Octoparse with the apps you use everyday. 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. Instantly connect Outseta with the apps you use everyday. Octoparse is a web-scraping tool to extract unstructured data from websites and organize in structured formats. 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. Use the rollup formula MAX(values), which will give you the latest bid date for that particular item. 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
Read More
Leave a Reply. |