Other Questions

Hi! I have a business where we rent home alarm systems. We use Airtable to manage the stock and availability of the kits. I would like to introduce it in our booking form, so what I want to do is make a request to check if in the dates my client wants to rent the alarm system, we have some system available. Di you know if this is possible and can help me a little please? Thanks community!

Hello all! I would like to create some drill down fields in a table for goals and objectives. For example, if you choose Goal 3 from a single select field, I would like to then only see the objectives that correspond with Goal 3 (i.e., Obj 3a, 3b, and 3c) in the Objectives single select field rather than see the objectives for every goal. Is this possible? Thank you.

Hi All, So I have a Date and Time field, in separate fields, I wanted to combine the 2 fields together in 1. Is there any formula for this case? I’m looking for a result in this way “1/7/2022 19:00” Thank you in advance! My Best, Mae

Hi everyone ! I am so sorry if my question has already been answered on this forum but I just spent my entire day trying to find a solution… I need to add some wordpress featured images on my Airtable database. To do so, I choose the Attachment field type and tried to add the url. Airtable is doing a great job downloading files, but it takes a kind of screenshot of the website whereas I only need the featured image (just a .png or .jpg file !). For example, if I take this url (https://lexpedia.fr/droit-administratif/arret-blanco-8-fevrier-1873/) and insert it in the Attachment type field, I will need to get the little girl image on a .png format. Don’t hesitate to tell me if I’m not clear ! Thanks by advance !

Hi! I have a slight problem that I don’t know how to solve: I’m working on some lists that need to be divided into different records. In this particular case, the lists that I was given contain the field “name” or “full name” but I need to divide that information into “name”, “middle name”, and “last name”. So, for example, if I have in one record the name “Amanda N. Pollard”, I need to divide that into Given name: Amanda Middle name: N. Last name: Pollard The extra complexity comes when not all people within the Company have middle names or when some employees have more than 1 last name. For example: “Jay Martínez Romero” which in this case would look like: Given name: Jay Last names: Martínez Romero Has anybody done this before? Thanks in advance!

Hello world I’m working on a budget base which requires a linked field to pull in cost data. It currently means manually searching for a linked record 20 times for each choir rehearsal (there are 10 venue costs, and 10 staff costs per choir)… And we have 19 different choirs to do this for (almost 400 manual ‘clicks’). I’m either being stupid and missing something obvious, OR it requires some form of scripting (in which I am clueless) or automation to make this happen automatically. Could anyone shed some light? Here’s a short video showing what I currently have to do. And here’s a link to an abbreviated version of the base. Any help would be hugely appreciated! Many thanks Curtis

Hi, I’m creating a running list of records (in this case, social media posts) and I’ve organized them by year, then by month, and then by week. To do this, I assigned format specifiers to each date with formulas. For example, 2019 is “2019”, January is “1 January,” February is “2 February,” etc. Weeks are assigned the same way – the first week of January is “1,” the last week of December is “52.” However, I ran into trouble with a new grouped view (“Posts by Month”). I grouped these records by year, month, and week. Everything displays as it should except the last few days of December. 12/29/2019 through 12/31/2019 disappear. They are technically part of week 1 in 2020, but aren’t displaying because they are still part of the year 2019. Is there way to force Airtable to recognize these last few days in December are part of 2019 and to show up in this grouped view? Perhaps as Week 53 in 2019?

My pictures do not show in records; it was showing for a while until I made an interface and disappeared.

Hi Everyone! I’m trying to create a webhook from a local app, but I always get a Error 400 response: Access to XMLHttpRequest at 'https://hooks.airtable.com/workflows/v1/genericWebhook/mywebhookxxx' from origin 'https://localhost:5173' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. Does anybody know how I can prevent the cors error? Many thanks in advance for any help! :bouquet:

Hello! My wife and I use a food delivery service that each week brings an assortment of bulk food. Our plan is to portion it out at time of delivery, and easily eat it throughout the week. Instead, we just toss the bulk containers in the fridge, then confusingly shuffle them around for every. single. meal. So! Airtable to the rescue! My question: how would you best map out the days vs the meal (breakfast, lunch, dinner)? The plan is to make a table for the dishes (chicken stew, roast veggies, etc) and then link them to a specific meal (Thursday Lunch) in another table. I’ve tried records with a title of the day, then a field with the meal. I’ve also tried a record with the meal as the title, then a field for a date. I’m primarily using the mobile app, and both of these methods leave me with a big stack of cards that appear to be repeating (Tuesday, Tuesday, Tuesday, and so on). Is there a better way to map this out? Like some kinda way where my days/meals read a bit simpler visually? I

Hi there, I don’t know exactly whether this question goes here or under table design but see below my challenge. On my base I have different tables but the main ones are contacts and projects. Under contacts I have all person details, emails, etc and use these to send automated emails etc. My table projects I have different views and the Kanban I currently have is ‘stage’ view. We are growing quite fast and, now I would like to have a Kanban view which stacks the projects that certain people in ‘contacts’ table are running but to do this I would need to create a ‘single select’ field. This would duplicate my work as I already assign the project to a contact, linking the tables and running automations in the background. Just checking in to see if anyone can think of a smart way to stack / group by contact if that makes sense. Thanks in advance, Arnau

I have been trying to create an automation with a Google Calendar trigger where, upon the creation of a new calendar event, a record is created in my Airtable base. I can look at the appointment in my Google Calendar (9/3/22 from noon to 1pm). When I look in my base, the start and stop time values are displayed as 5:00pm and 6:00pm. The Title, Date, Start/Stop Times of the Calendar Event read as follows (in Google Calendar): “Test Event 3 Sep 3, 2022 12:00pm to 1:00pm Sep 3, 2022 (GMT-5:00) Central Time - Chicago time zone” I went back to check my automation routine in Airtable and, upon generating a preview, it shows start and stop times of 5:00pm and 6:00pm. The formula I used to translate the GMT (Start and End) fields into the correct time format is below. The format is fine. The values are wrong by 5 hours. DATETIME_FORMAT(SET_TIMEZONE({Begin GMT},‘Chicago/Ilinois’), ‘hh:mm a’) Any suggestions? Thanks in advance.

Hi, All i have created a multiselect option field in airtable and in that field new options is created via Parabola,but now i am facing the issue, Cannot create more select options for new select option xyz , due to this i cant able to add records in air table, i tried to direct add options in that field but cant able to do that, please let me know how to fix it . Thanks

Im attempting to make an app that will allow the user to select a value from a dropdown, and then the table will filter the records for that value. I’ve gotten the dropdown working, however for whatever reason the last return has an error and will not work. The problem function is the one that will update the records. How can I resolve this return error?

Hi all! I’m looking for some brainstorming help to come up with a creative solution. I am hoping to use the new limited view feature on forms to create a booking system for my team’s educational programs. Right now, we have two tables - one for the program information and one for our contacts. We have it set up that way so we can keep track of whether or not contacts return and do additional programs. I would love if there was a simple way to have a contact created and linked (or just linked if that contact already exists) when someone fills out and submits the form that populates the program information. Any thoughts or suggestions appreciated!

I’m getting an invalid hook call error, but I’m unsure as to why. My extension is intending to list all the values in a specific field in a dropdown to then select one to filter buy Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: You might have mismatching versions of React and the renderer (such as React DOM) You might be breaking the Rules of Hooks You might have more than one copy of React in the same app See https://fb.me/react-invalid-hook-call for tips about how to debug and fix this problem. at resolveDispatcher (https://localhost:9000/__runFrame/bundle.js:79388:13) at Object.useContext (https://localhost:9000/__runFrame/bundle.js:79396:20) at useSdk (https://localhost:9000/__runFrame/bundle.js:25061:19) at useBase (https://localhost:9000/__runFrame/bundle.js:32768:41) at ./frontend/filter.tsx (https://localhost:9000/__runFrame/bundle.js:34:74) at webpack_require (https://localho

Currently experience a bug? I think… I’m trying to sort by A-Z on column 1, then sort by selected radio check marks? Just me…?

Trying to filter results shown on a google map. User Type A is associated with Multiple User Type B but NOT all in the data base. (Eg. User A1 is associated with User B1, B2 and B3 but NOT B4… want map to only show B1,B2 and B3’s pins to A1) Would like map to reflect that. Using Softr and it has conditional filter on lists that is perfect for this but NOT on maps. Thoughts? Work arounds? Side note: Can not be manual… needs to be automated/scalable Thanks in advance!

Hello! I’m hoping someone can help me with a nested if statement. I am trying to list a specific price for a product or combination of products. Airtable keeps telling me that I have an invalid formula, please check formula text. Can anyone see anything specific here that needs to change? IF (Foursome=TRUE(), 59.95, IF(Twosome=TRUE(), 39.95, IF(AND(IB=“IB”, HH=“HH”), 45.90, IF(OR(IB=“IB”, HH=“HH”), 22.95, IF(OR(EP=“EP”, EP2=“EP2”), 11.95, IF(AND((IB=“”, HH=“”), (AND(EP=“EP”, EP2=“EP2”))), 23.90, IF(AND((OR(IB=“IB”, HH=“HH”), (OR(EP=“EP”, EP2=“EP2”)))), 34.90 IF(AND((OR(IB=“IB”, HH=“HH”), (AND(EP=“EP”, EP2=“EP2”)))), 46.85, 0)))))))) Thank you in advance for your help!!

Greetings All, Loving AirTable. Is there a way to set up a view such that I could post a link in an email or website that people could click on, then search for their name, and see their relevant data, but not other people’s? I know this is probably a stretch, but thought I should ask anyway. Trying to figure out the best way to let them confirm their own details (hotel, dates, meals, t-shirt sizing) in an automated way that doesn’t require me emailing each one of them. I know there is an email block, which I haven’t figured out how to implement yet, but I see it requires a SendGrid Account which I haven’t had a chance to look into yet. Thanks for any assistance! Rachel Alvarez Cure CMD

Hi! Long story short, I’m demoing Airtable to see if it is right for what i’m trying to do. The situation is: My company currently uses a custom Filemaker Pro database / app for scheduling and project management that is TERRIBLE. We’ve worked with the company to try to make it better for YEARS and i’m just fed up with it. It’s slow, bloated and is costing us time and money. I’m in the process of carefully exporting the data from the database and have got almost all of it in what i think are usable excel sheets. Basically what i’m trying to work on now is how to link the data in 2 (or more)tables. I’ve got a table that is a list of projects, with client info, date, time, job number etc… I’ve got another table that is a list of our deliverables for the client, Video title, length, format, etc. Several rows that also contain the same job number in the first list. The question is how do i best go about easily accessing the appropriate data in either table from the other? I’ve been messing

good evening, I wanted to know how I can perform the data dump of several tables in a new one (read-only) that contains the information of the others and is synchronized. Thank you

45-second video: Loom | Free Screen & Video Recording Software | Loom TLDR I have a master table of URLs. Inside the base, I want the child table to match any URLs back to the master. Thank you!

Hi all, Im new to Airtable and was hoping someone could help me with a work around to a feature I don’t think is available yet. I’m looking to create a booking system for my small business where I take some of the customers details over the phone (name, phone etc.) but they then finish filling their other details (address etc.) out via either a sent form or a private version of the form via our website. Is something like this possible using airtable?

Hi, I’m trying to add a column that will display the date which each individual primary record was added in to Airtable basically displaying some sort of a log I guess of when the record was first added Any ideas???