Hi all! I’m still pretty new to scripting, but came across a problem that feels like it should have an obvious answer.
I would like a user to be able to update a number field in my base via some inputs in the script, however the input.textAsync funct...
I’m hoping to use JotForm to add some functionality for recruitment applications, and having some trouble with Airtable’s attachment field when mapping the fields using Integromat.
Jotform is sending the attachment data as a URL, which I’m mapping to...
Hi, forumla gurus!
I’m working on a scheduling database linked to our list of work. I’m a little caught up in the process of flagging when a staff member is on two shifts at the same time.
Using @W_Vann_Hall’s formula to count occurrences in a string...
Hi!
I’m trying to create a formula that extracts a keynumber from a string of text to add to a field in Airtable.
The input is in some form like this:
NB - 1720ENTHXXXXXAR - TTQ 1720 NEWSBREAK THURSDAY - 0:15
And the output should be:
1720ENTHXXXXX...
I’ve recently started using Airtable to cut down on the number of spreadsheets that don’t talk to each other, and loving the improvements we have made so far.
One of the struggles was not being able to use a lot of features due to dates and times bei...
I have actually solved this one! There was a setting in JotForm that required login to download files. Turning that off enabled it to upload correctly.
This is less secure, but a huge time-saver.
For those experiencing this on other platforms, I woul...
The order we assign the shifts seems to be primarily important here.
If we schedule chronologically, Tom’s 10:30 shift causes a clash with his 9:00, as it should, since the both the start and end time are within the earlier shift.
If we schedule him...
Thanks, Justin, this is awesome!
I’ve put this in my base and had a play around with it - it appears to work well when allocating shifts in chronological order.
However, if we’re putting someone on a shift before the time they’re already working and ...
Fantastic! Thanks, Justin.
I didn’t realise you could use those kind of codes in formulas in Airtable, this has opened up a whole new world.
Cheers :slightly_smiling_face:
