Excellent. Love scripts.

@GarethPronovost

7 ай бұрын

Us too!

Great one😊 I knew the last one but not the first 2

@GarethPronovost

7 ай бұрын

Learning something small every day is the road to mastery!

Super useful 👌👋

@GarethPronovost

7 ай бұрын

Thank you 🙂

I did not know time functions are so resource heavy! Is there a workaround to still have them based on conditions? In some cases I might have to deal with free Airtable versions.

I realize you're not able to troubleshoot this, but the timestamp script throws an error when I try to run it: TypeError: output.set is not a function at main on line 1 It happens in the desktop and web versions of Airtable. I also tried it in Incognito mode on Chrome.

Is there a distinct advantage between using the timestamp script vs just using a last modified time and pasting that value to the static Date field?

@GarethPronovost

6 ай бұрын

I'm honestly not sure what amount of resource allocation is tied up with the Last Modified Time field. I haven't personally noticed any latency caused by it.

@anchoreddigital

6 ай бұрын

@@GarethPronovost Airtable is tracking that data in the background whether there's a LMT field or not so I'm guessing latency isn't much of an issue. The script is still handy though especially since you can modify the time stamp and not have to rely on a DATETIME_ADD function which may have a bigger impact on performance.

All of theses script and even more, can be done with Coda easily. it's database system and formula language allows to create very personalized workflows

@GarethPronovost

5 ай бұрын

I haven't used Coda for several years. We tried it when it first came out, but it couldn't support the data schema we built. It wound up costing us a client and about $15k 😳

@omarmhammedi9138

5 ай бұрын

@@GarethPronovost would love to hear more about that. I know that there is a limit of rows, past 50 000 per table it start slowing down. But if it’s not a database row number problem, curious to know what failed you.

@GarethPronovost

5 ай бұрын

@@omarmhammedi9138 it was performance. Table 1 linked to 2, linked to 3, linked to 4. Thousands of records later, the solution couldn't load in a reasonable amount of time and was unusable. 😥

@omarmhammedi9138

5 ай бұрын

I see, I started using coda since 2023, I don’t know how it was before. But in my current use « project management » « task and time tracking » « finance » « CRM » I have never felt problem of performance. Maybe you should give it another try in 2024.

*SCRIPT FORMULAS USED IN THIS VIDEO* 👇👇 Set Current Timestamp: output.set("date", new Date().toISOString()) 5 Second Delay: function sleep(milliseconds) { const start = new Date().getTime(); for (var i = 0; i if((new Date().getTime() - start) > milliseconds){ break; } } } sleep(5000)//delay 5 seconds Webhook Trigger: let url = "YOURWEBHOOK?recordID="; let {recordID} = input.config(); await fetch(url + recordID) Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓

I can imagine the Now() function would be resource heavy, but why should we care about it? The tech team in Airtable should take care of the issue. As a user, I just want the exact data.

@GarethPronovost

7 ай бұрын

True, but the intense use of resources with the NOW() function slows down databases with large record counts. Agreed it's a tech issue, but also a building tip for folks with large datasets. Also, the function is close to the accurate time, but rarely exact. This script pushes out the exact time the script runs.

where I can grab the script for timestamp? 😚😚

@GarethPronovost

4 ай бұрын

In the video description 👌

Chat GPT provided me with the Script below and it seems to work fine for me: function delay(seconds) { const startTime = Date.now(); while (Date.now() - startTime // do nothing } } // Call the delay function with the number of seconds to wait delay(10); // This will delay the script for 10 seconds

@GarethPronovost

6 ай бұрын

Perfect!