![]() The scripting interfaces below are convenience wrappers that allow easy interaction with Airtable’s REST API. To delete them, go to Credentials in the Drafts settings screen.Īirtable is a web-based spreadsheet and database tool which can be used to organise a large variety of different kinds of data including text, images, files, and more. These details are stored locally on your device, and only need to be entered once for each base you access. When prompted, enter these into the credential prompt. ![]() Get your base’s endpoint and your API key from the Airtable API documentation. Add your own script to a “Script” action step after the “Include Action” step. Create a new action and use the “Include Action” step to include “Airtable API”. Download this script using the install button at the bottom of the page. If you feel there is a better way of doing this feel free to tell me, but as long as I found a workaround by myself it’s fine so far.To use this as part of one of your script actions, follow these steps: This is working well as long as the “Booked Tuitions” table is up-to-date. ![]() The issue I’m facing is how to handle the Timeframe slots and availabilities.ġ - Client books tuition course with an Airtable Form (trigger)Ģ - Zapier calls a “Booked_Tuitions” Table to look for Teachers already booked on the same Timeframeģ - Then Zapier looks for a Teacher that pertains to both the requested tuition and timeframe availability filtered by the responses of the above API callĤ - We create a new record in the “Booked Tuitions” Table that confirms the booking slot to the Client. When a Client book a course, I need to find the right available teacher for the timeframe, book him to my client, and then make the other topics that the Teacher can propose unavailable for this specific timeframe until the former course has been done.Īnd you can imagine this with multiple teachers that propose multiple courses and topics.AND can teach multiple kind of courses (topics), whatever the timeframe is, as long as they are available,.Some teachers are available on specific timeframes.Clients can book Tuition courses and on selected timeframes from teachers (see below).However, here is what I’m trying to achieve : In between our messages I found a solution with the help of Zapier. Yes, I’m trying to achieve a reservation system with multiple slots management. I’m translating my thoughts in English while typing so maybe there is a reason why you’re also lost :slightly_smiling_face: Thank you for your response and sorry for the complexity of my message. Therefore I can filter the result based on those calculations results and the one you provided above are a good start…But I don’t know how to proceed, probably because I’m lost here :- :sleepy: So I understand that there might be a way to achieve this by doing calculations in the Tables themselves before making the API call. This record will then have the Date/Time from Table B, sent back to “Table A” through Linked Records + Lookup Value and won’t be available anymore if a new request come through, and so on…I don’t know if I’m clear enough though :slightly_smiling_face:īut you said this was not possible because of the structure of the lookup cell by itself if I understood correctly. Then, from those filtered records in the API call, pick an available record randomly (using something like Zapier Utilities), and create a new record in “Table C” to make a match. I was thinking that it was possible to do by making an API call in Table A filtered by the Date/Time parameter in Table B using a FilterbyFormula Eg : List all records for which record’s Date/time in Table B is not overlapping with a value in the lookup cell in Table A. If there is no overlap in a certain row, then a match is created in “Table C” which is the source of the aggregated lookup values in “Table A” I need to parse time frame availabilities (stored in lookup cell in let’s say “Table A”) from a date posted in another table (“Table B”). So in order to make things clear here is what i’m trying to do : However, when I’ve posted my request, I thought there might be a straightforward answer to my issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |