The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Hi all, after some research I have found the solution to my needs via @Kamille_Parks’ no conflict airtable script. However, I would like to show the executing script as a client-facing page (the same way we would use a basic form) without having to s...
Hi all, trying to build a table for instrument rentals at my workspace. I posted about this elsewhere thinking my answer lied with automations and formulas but maybe calendar view is my answer?
We basically rent instruments to students like a library...
Hi all, I’m building a table to track items availability (musical instruments) for students to sign out and borrow for a limited time.
My base has two tables, one with the instrument catalogue (containing general information on the instrument, brand,...
Hi, I’ve built a base for a music conservatory. We are tracking student groupings for an ensemble. The students field are linked from a database tab.
We are trying to avoid having one student in two groups, or at least flagging the groups that share ...
Hi all, new-ish to Airtable and I’m having to build an inventory table to check for equipment conditions. The purpose of this table would be to show the type of item, brand, make, some descriptions, cost of item, condition, and date condition checkup...
Hey @Vivid-Squid, thanks for the response, but I’m not referring to sharing a form, but sharing the script I referenced above as a page that would look like a form, the right part of the screen in the attached screenshot
Thanks @Adam_TheTimeSavingCo, I actually discovered a script from @Kamille_Parks that I posted about in another thread as I’m investigating the possibility of using calendar view for this, but her no-conflict script works perfectly. I’m just looking ...
Oh my god! @Kamille_Parks saving me again and this time without a response, I did some searching and found the No-Conflict script and this literally does the job I need it to do.
For reference: Asset Reservations: No Double-Booking - #8 by Kamille_Pa...
Hey Adam, thanks for the suggestion, though I’m not entirely clear on it unfortunately. I’m also realizing I need a bit more functionality than I specified above, as I would also like instruments to not be double booked in the future, ie, someone boo...
I should add, thanks to Kamille_Parks’ help, I do have a feeling that this could also be done via a formula, but I’m not sure how to get it to happen. In words, I guess it would be:
If [signout date] is tomorrow, mark instrument status as unavailable...