Hey, Gareth! Thank you for the material. You've been a main source of knowledge for airtable. I'm working on large projects that repeat every year. Each year, we basically need to replicate those tasks. Each project may have up to 300 tasks. Tasks have various due dates (possibly over 100). I was able to create a formula that calculates intervals between due date and start date, but I'm not sure how to use it. Is there a way I can use the interval information to replicate them automatically, instead of adding the intervals manually for each task? Thank you so much!
You can build an automation that waits for any task to be completed. Once complete, it can look at the date you calculated and recreate this task, assigning the calculated date for the new due date. Hope this helps!
Hi Gareth! Any possible video on how to do this via repeating groups in automations? I'm having trouble figuring out the logic to do this with formulas instead. The reason I need the work around is because I go over the amount of record templates you can make - which right now, if you're not on the enterprise plan you can only go up to 100.
Hey GAP! I just started looking into Airtable but I'm stuck on something very simple I want to match records in 2 tables and then create a 3rd one with all the fields from both, basically this is how it would look in SQL CREATE TABLE new_table AS SELECT table1.*, table2.* FROM table1 INNER JOIN table2 ON table1.url = table2.url; What are some ways to do this in Airtable
I think you'll want to explore a junction table to get this functionality. We've done several videos on the topic over the years. Also check out our free Airtable crash course - the final lesson focuses on this topic
There's no way to automatically change the task dates when the project date changes after the record has been created, huh? I've been trying to figure this out and wondering if it's a lost cause.
Out of the topic, because all these last features are quite useless for me personally and anyone at my work. Although I find AT a great tool for storing data such product catalogues, price and profit calculation I just wish AT would allow to transpose the data as this would save plenty of place and efforts to scroll over hundred + columns. I think most finance folks would rather see records in vertical view rather than current horizontal. And the name of records to be shown on the top and have wider row just for them
you can filter, Rollup, Look up, create automations that duplicate or modify records in the same table or a different one, and use different views or interfaces to see different facets of the data. There are so many ways to see data I don't think you need to scroll as much as you are describing...
When you're screensharing, it's so hard to see what's on your screen since you're making it smaller (doesn't take up the whole window) and that animation in the background is so obnoxious. I really love your videos and teaching, but I wish you'd reconsider all the editing 😢
Grab our free Airtable Crash Course to master the basics 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡
Can't wait to get into more of those Pro features myself. Thanks Gareth!
🙌
Very cool!
Thanks for watching!
Hey, Gareth! Thank you for the material. You've been a main source of knowledge for airtable. I'm working on large projects that repeat every year. Each year, we basically need to replicate those tasks. Each project may have up to 300 tasks. Tasks have various due dates (possibly over 100). I was able to create a formula that calculates intervals between due date and start date, but I'm not sure how to use it. Is there a way I can use the interval information to replicate them automatically, instead of adding the intervals manually for each task? Thank you so much!
You can build an automation that waits for any task to be completed. Once complete, it can look at the date you calculated and recreate this task, assigning the calculated date for the new due date. Hope this helps!
@@GarethPronovost Thank you! It did. I really appreciate you taking the time to share the knowledge!
Hi Gareth! Any possible video on how to do this via repeating groups in automations? I'm having trouble figuring out the logic to do this with formulas instead. The reason I need the work around is because I go over the amount of record templates you can make - which right now, if you're not on the enterprise plan you can only go up to 100.
Great question - yes, we are working on this video soon
Hey GAP!
I just started looking into Airtable but I'm stuck on something very simple I want to match records in 2 tables and then create a 3rd one with all the fields from both, basically this is how it would look in SQL
CREATE TABLE new_table AS
SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.url = table2.url;
What are some ways to do this in Airtable
I think you'll want to explore a junction table to get this functionality. We've done several videos on the topic over the years. Also check out our free Airtable crash course - the final lesson focuses on this topic
There's no way to automatically change the task dates when the project date changes after the record has been created, huh? I've been trying to figure this out and wondering if it's a lost cause.
Hi Ronnie, we published a video today on this topic. Hope it helps!
Out of the topic, because all these last features are quite useless for me personally and anyone at my work. Although I find AT a great tool for storing data such product catalogues, price and profit calculation I just wish AT would allow to transpose the data as this would save plenty of place and efforts to scroll over hundred + columns. I think most finance folks would rather see records in vertical view rather than current horizontal. And the name of records to be shown on the top and have wider row just for them
you can filter, Rollup, Look up, create automations that duplicate or modify records in the same table or a different one, and use different views or interfaces to see different facets of the data. There are so many ways to see data I don't think you need to scroll as much as you are describing...
When you're screensharing, it's so hard to see what's on your screen since you're making it smaller (doesn't take up the whole window) and that animation in the background is so obnoxious. I really love your videos and teaching, but I wish you'd reconsider all the editing 😢
Appreciate the feedback! We'll pass that along to our editors