*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 < 1e7; 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 🤓🤓
@jordancoleman1608
2 ай бұрын
That second script is.... bad. It basically causes the script to use 100% of the CPU cycles (and battery) available to it while it waits for time to pass. It also has an arbitrary number of "tries" after which it will give up and return anyway.
@augustincloutier508
10 ай бұрын
Great one😊 I knew the last one but not the first 2
@GarethPronovost
10 ай бұрын
Learning something small every day is the road to mastery!
@User_PC_Loadletter
10 ай бұрын
Excellent. Love scripts.
@GarethPronovost
10 ай бұрын
Us too!
@SnigdhaParida
10 ай бұрын
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.
@anchoreddigital
9 ай бұрын
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
9 ай бұрын
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
9 ай бұрын
@@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.
@alsaukh3
10 ай бұрын
Super useful 👌👋
@GarethPronovost
10 ай бұрын
Thank you 🙂
@darryloliver9868
10 ай бұрын
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.
@omarmhammedi9138
8 ай бұрын
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
8 ай бұрын
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
8 ай бұрын
@@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
8 ай бұрын
@@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
8 ай бұрын
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.
@JinGong-h9m
10 ай бұрын
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
10 ай бұрын
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.
@SerlynVilla-k5u
7 ай бұрын
where I can grab the script for timestamp? 😚😚
@GarethPronovost
7 ай бұрын
In the video description 👌
@blankpage1704
9 ай бұрын
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 < seconds * 1000) { // do nothing } } // Call the delay function with the number of seconds to wait delay(10); // This will delay the script for 10 seconds
Пікірлер: 24