Ask the Community

Use Case: You have a table of assets (library books, conference rooms, etc.) that you want people to reserve, but don’t want people to be able to reserve an individual asset at the same time it has already been reserved. Solution: No-Conflict Asset Reservations script by Kamille. This script allows you to schedule a new asset reservation in a form-like interface by setting a date range, then selecting from a list of assets which are un-reserved for that time period. Potential Users: Event Planners, Inventory Managers, Librarians, etc. Demo:

Hi all, I’ve been reading through a ton of different conversations about Airtable and recipe managers. and have found some amazing info on here. I’m currently a little blocked so maybe someone has more info on the following topic. Overall, I’m trying to create a database that has recipes where I can understand both the cost per recipe and the macronutrient breakdown for each recipe. Where I’m getting stuck is breaking down the nutritional values because some ingredients are in cups and others in tbsp. I’m trying to convert measures to grams but am having trouble connecting the conversion info to the recipe info. Generally my table is structured as follows: I have the following tabs within my doc Meals - it’s the meal planning tab Recipes - this is an overview of the recipes that feed in

How do I write a formula to populate anything that is created in that week, it will add the Monday date of that week. For Example:I have records for 10/7, 10/8, 10/10. I need the Starting Week of to be: 10/7 for all Dates. Then I need records for 10/14, 10/15, 10/16, etc. To be starting week of 10/14.I also have the: WEEKNUM({Created Date}) formula, so if there is an easier way to turn that week number into the starting date of the week, I can use that as well.

Hi allI've been working on SAP Integration Suite for connecting to airtable and perform CRUD operations. I've created a integration flow for PATCH request in my suite and wanted to test it through POSTMAN by hitting the endpoint of PATCH iflow. The issue here is that even though i'm sending my json payload in the format of airtable PATCH request postman is throwing 500 error.My table in airtableNote that EmpID is also Single Line Text hereBelow are my configurations of the integration flow i've created to perform a PATCH operation through POSTMAN.Json payload i'm sending through postman to suite{            "id": "rec6jjMo9lBFpfI62",           

I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If today is 11/19, something due 11/18 should be Past Due by -1, but it shows -3. Given that it works for current/future dates, what am I missing here for the past dates?   

Hi,In our CRM we have several different situations, where reminder mails should start going out to contacts. Many of these are chained so that if the contact doesn't respond (e.g. sign up again after an event they cancelled), there will be reminders 1, 2 and 3 with some days time in between.Originally I created these as separate automations, it was simple and easy to overview. The triggers were "When records match conditions", like this (simplified):Reminder 1 - When record match conditions: "status = cancelled"Reminder 2 - When record match conditions: "status = cancelled" + "when cancelled = is numbers of days ago 2"Reminder 3 - When record match conditions: "status = cancelled" + "when cancelled = is numbers of days ago 5"But having several of these situations split up into separate automations eat up a lot of the automations quota, so I tried to integrate reminders 1-3 into one automation. So I used just o

Hi, I am trying to make a custom Slack script for my team where I can send the invitations to the users once the form is filled. For that I am trying to make a script that has an input field like Slack action where you can connect your account, select workspace and send the invitation. But I am not able to find how can I make those custom drop down? Do I have to code that out or can I use some pre-built things?

The goal is to have two options using an NFC tag:Assign EquipmentScan the NFC tag to assign "Tablet 1" to Employee X.Check Assigned ProfileScan the NFC tag to see who "Tablet 1" is assigned to and open their profile.Additionally, the NFC tag should always display the information "Tablet 1" visibly.

Hi all,I want to prioritise datasets in Airtable. For that I've created checkbox fields and a drop down field.I now want to create a formular field and add there a weighted text drop down menu by giving each text option a number. For the checkbox fields it's clear: If it's checked, then value1, if not, then value2:IF(logical, value1, value2) + IF(logical, value1, value2) +  But how can I add the weighted values from the drop down menu in the formular?For example IF option1, then 3, IF option2, then 2, IF option3, then 1, otherwise 0)IF(logical=1, 1, 0) + IF(logical=1, 3, IF({logical=2, 2)) In detail, this is the formular which is not working:IF({easy to implement?}=1, 3, IF

I’ve searched high and low and can’t seem to find a really easy to use template that allows shift scheduling in an easy to use, drag and drop way like Sling or When I Work. I really don’t want to throw another app at my staff (I’m getting them used to AT as it is), and it would be nice to work within the AT ecosystem so I can use my existing staff info tables. Anyone have something useful? The ones in the existing universe are…not friendly.

Hello I started exploring using Airtable native AI fields; I would like LLM to read and process an attachment documentin PDF but the relevant field {Attachment} seems not to be available in the prompt design. Is it possible in some ways or do I need to resort to using OpenAI APIs and scripting? Regards and Thanks !

Is there a sequential order when a new record is created through a Form view? Can you define/control the order?

Hello!Let me first paint the picture of what I am working with:1 base, 4 tabs: "🧍‍♀️People", "🏝️️ Absence Management", "🏝️️ Leave types" and "📅 Public holidays"Relevant columns:In "🧍‍♀️People" one column has the staff "Name" and the other column has a "Leave Location" (which refers to the location they are based in and to which public leave should be based on)In "🏝️️ Leave types", we have a choice of "Leave" called: "🌞 Holiday", "🗓️️ Public Holiday", "🌞🗓️️ Holiday + Public Holiday", "🤒 Sick".In "🏝️️ Absence Management", we have date fields with leave "Start Date" and "End Date", linked fields to "🧍‍♀️People" taking "Name" and look up "Leave Location", linked field to "🏝️️ Leave types"In "📅 Public holidays" we have a

I'm trying to make a small CRM. Two of the main datatypes are Contact and Company. Clients work for Companies. When I get a new lead, I enter the Contact's information. When I do that, I'd also like to be able to create a record for their company if it isn't already in the Company table. So, bottom line, I should be able to either select a company, or type in the company's name and have it create a new record in the Company Table.I've created a simple interface to create a new contact, but as I understand it, interfaces only insert into one table. Is there any way around this? I thought about trying to add an automation, but it seems like the interface templates for adding new rows to a table don't support what I'm trying to do.

Hi everyone! I have a follow up survey that we send to customers via Airtable form. No prefilled info, pretty simple rating, feedback, and customer email to be filled out. Here's the kicker - we got a response back, and the customer entered @gmail.con instead of @gmail.com. The problem is, I have several follow on automations that are dependent on that email field to match it to the original survey request and then update both records accordingly, notify the user, etc. I already have modifiers on my other automations that corrects any caps to all lowercase, trim, etc to ensure the data is clean and matches. I considered using the "length" modifier, but considering I have no way of knowing how long any given customer's email address will be, that's not really an option. Now, I know I

Can you help me with a formula to remove all characters including and after the "(" in Los Angeles (hollywood)?So my goal is to make Los Angeles (hollywood) --> Los Angeles

I know airtable doesn't have the ability to do this, but I wonder if anyone here has a clever solution.For context, we're a non-profit vege farm. A few of the things we keep records on need many records created at the same time. For example, when I seed trays of 15 different crops in the nursery, or I sow a cover crop into a bed (sometimes 10+ species). Each crop in either of those instances has unique data stored against it - Date, quantity, etc.We need to be able to do this on mobile, as we're in the field, and unfortunately the table view of airtable isn't very easy to do this on mobile. And unfortunately having to submit a form 15 different times is confusing and time consuming. The ideal solution would be a form that could collect all data against each instance, but airtable doesn't allow that.Does anyone have any ideas to help with this workflow? I have seen on2air, but unfortunately as a

Hi,I am new to using Airtable, and I want to utilize multiple forms. The idea is to have a first form where, upon clicking a picture, it will transition to a second form, allowing the customer to input all the necessary information. Upon pressing a button on the second form, it should move to the third form, displaying quotations for the woods, including the pricing and quantity. These forms are intended for quotations of the product that the user can request.My question is: Is this functionality possible with Airtable? I am uncertain if a clickable image is feasible, so I need clarification on whether Airtable can support multiple forms, as described above.

Hey there, We are building a complicated form and we are wondering if it would be possible to break up the questionnaire into multiple pages so that we can offer the questions in smaller chunks? Do you have any insights into this?

Hi,As the subject line states, I am looking for a function within airtable forms that can allow me to change the available inputs based on the condition of a previous answer.The purpose of this, is to submit an attendance form of such.I am using a table consolidate all of the different departments as an individual record, and within that record, each employee is linked to their respective department.My intent is to use the form to submit a list of attendees, based on which department is involved.For example, I had a meeting today with Marketing, Finance, and Operations.On the form, there will be a linking field, where I input these three departments.Then I have an Attendee field, where I can link the individual attendees, based on the above selected departments.Is this possible? Is there a way around this?

Hello, I’m trying to put automatically as primary field the name of the forms where the data came from but I can’t find a way to allow that, even if with formula. Someone have an idea how to that? Here data from my table: Table name: Table1 Compose by these views: Grid view Order form Incident form Purchase form Ask money back form I want to display the name of each form on the “Grid view” as primary field. Is that possible to allow it without to ask the user to field this name on the form?

Why do forms have to be only one column? I need to develop forms that are more complex than all the fields in one column. Any suggestions?

Is it possible to put the fields side by side? Like this… First Name _________ Last Name ________ instead of… First Name Last Name Also, is there a way to make the boxes next to each field smaller? They are really long (like above) Thank you for your help!! Robin

Hello Airtable world,I need help with a formula. I have a look up field with many options. All of these options share the same data for some field e.g. Pick Up Location.In this case, I have 1 record with 2 options (lookup field) and the look up field extracts: Montreal, Montreal.Is there a formula I can use to only keep what is before the first comma when working stringsThis is an example of what I am trying to achieveThank you in advanceMatt 

I've been scouring this forum for an answer to a variant of "Convert String to Duration" but alas, no simple answers uncovered!In my case, I have a text field that contains duration as as string such as, "1:30:00."I need this to now be a field that is either a number (1.5), or an actual Duration type field.DATEADD(), DATETIME_PARSE(), DATETIME_FORMAT(), etc. formulas return errors and cannot format this particular representation of time as a string.What incantation of formula language is required for Airtable to do this so I can use this data? Thanks!