Unanswered questions

I'm trying to upload a survey in Excel to create a Form view, but unable to do so without losing all the formating. Anyone know how to do this? Thanks!

Good day everyone, I need some help on how to create a script coding that Fill in the state name in a table cell when a customer fills in the full address in an Airtable form. This is not linked to an Automation, just an independent script that can be run anytime to any table, that also goes with the free geo api nominatim. Thank you.

I need to create an email automation (preferred) or design a page that displays information similar to an invoice. Example data: Person Janice Joe Jill Jerry Jess Pay $100 $120 $60 Joe and Jess have blank values for Pay because they weren’t involved in this project. I’m able to use an automation to blast out an email to all people involved (Jance, Jill, and Jerry) because a separate field lists them, but I don’t need to actually display the empty records for Joe and Jess within the email content itself. And in real life, I’ve got over a dozen people and only 2-5 that I need to list in an email at any time. Essentially, I need to find a way to setup the email within the automation to only display specific fields if they have values. Alternatively, if there is a way to do this within Page Designer, I could just generate a PDF and manually send it to Janice, Jill, and Jerry. Ideas?

Hey all I am hoping you all can help point me in the right direction. I am looking at just using HTTP calls for updating parts of airtable for us. However, I am confused by how to update fields like single select and multi select. Example: I have a table that has a field of singleselect, and all I want to do is update the single select to have an additional choice. what url would I need to use to update the field? An example would help

Is there any way to set up an inventory tracking system where someone can scan a QR code, and fill out a form of what they are checking out as well as checking back in? The issue I’m running into is that its fairly easy to create a form with a drop down of what you’re checking out, but when it comes to quantity of what's being checked out, that's where it gets tricky, unless you create a sperate quantity field for each individual piece of equipment, which if you can imagine, you have hundreds of different pieces of equipment, that is extremely inefficient not to mention the form it self would have hundreds of conditional fields. What I had imagined is for example, I scan a QR code, a form comes up, I check out 5 harnesses, 3 lanyards, and 10 beam clamps and click submit. On the user interface, I can look at who checked it out, what equipment they have what department they are etc. When checking back in, they similarly scan a QR code and fill in what they returned. It then compares what

My Ask: What methods can be done to direct or redirect automation error notifications to other base users. For many of the builds, I create the automations thus all error notifications come to me when an automation fails. From what I read, if I want another user to receive them, they have to be the one that creates the automation and turns it on. I would need them to ‘duplicate’ the automation and delete the original. Most of these errors come with the interactive actions involving ‘humans’. A prime example is when a form submitter does not enter their email in correctly thus a confirmation email does not execute. These are operational details that the person I built it for can handle and address. I hate to be the go between for these errors or do something fancy with my inbox to forward them to other users. Thoughts in other methods or do the duplicate way? We are looking to get Zapier that might be a method toward a solution.

Hello, I have a table with only 2 columns (Name and Creation Date) now I need to send a form from that table but that contains 5 Name fields so that the client can register 5 people at a time and each of them will be a different record.

I have a column of numbers. I would like to be able to press a button on an interface and set all values in that column for all rows to zero using a button automation trigger. Could someone please give a step by step guide? I can create an interface button linked to a record picker that updates the values one at a time… but that is quite tedious. Please advise, thank you!

I am trying to simply select a record and duplicate it from a filtered view, but for some reason, AT seems to be stuck or frozen. It is a bit frustrating. Anyone else experience the same issue?

Hello, I am currently trying to send an Airtable automation where it bulk emails people from a table. However, I am in the ‘To’ section to send an email, but I can’t find an option under ‘Current item from List of records’ that has just a general statement of ‘Applicant Email’. Currently, it’s showing a specific Applicant Email, but I want to send more than this person. This is also happening for the message when I am trying to include their names. I’ve attached one of the screenshots as a reference. Can someone help me resolve this issue please?

Hi all - wondering if anyone can help because I’m struggling! I used Airtable to track customers and business opportunities through two linked tables. Within business opportunities, each potential deal is categorised to a stage (via single select) - either Early Lead, Qualified Lead, Proposal Submitted, Pitching, Closed - Won or Closed - Lost). I can link the tables so that ALL opportunities are attached together, but what I would ideally like is to have a section / field in the Customer record for Current Opportunties (Stage = Lead / Qualified / Proposal Submitted) and Past Opportunties (Stage = Closed - Won or Closed - Lost). I understand that I could link automatically and filter the possible selections based on the Stage but what I want is for that categorisation to happen automatically. Any ideas? I’ve tried (and failed) to come up with an automation to do it! Hanna

I looking for a script to send automaticly a webhooks at a date and a time variable...

Can someone help with the coding of a script that converts the contents of attached .TXT files to a long Text filed? We have an attachment field [TXT] that contains one text file per field. We wonder if it is possible to copy the contents of each text file to a long text filed? I have see some notes on it, but we need scripting help to achieve it. Thanks for any advice. Kevin

I have a parent table with a bunch of linked children. On the parent table, I need to be able to click a check box, which will give the user a 30-minute grace period before the record is “Frozen” (it will move out of an interface section and into another one). The children will then move into a view that will sync it to another base, where automation will create a CSV and upload it to a server somewhere. My thinking was to have a last modified filed field keep track on when the check box was clicked and then add 30 min to that and then let that determine the rest. However I’ve now been looking into the NOW() and it seems quite unreliable for things to do with precision and filtering records into a view to be synced to another base, is also an issue as the date time will only allow me to filter days, but not use time. I can see how this could potentially be solved with a fairly expensive automation setup, where automation constantly looks for updates when the user clicks the check box.

Hello :) I’m not sure if this is possible but I would really appreciate any input or advice… I am overseeing the gig booking process for a band. I have 2 tables: Bookings Events In the Events table I have a summary field which concatenates various pieces of data about the event. I want to use this so that, when I am looking at the overall Booking, I can see a summary of all the info for each Events that is part of that Booking. The formula for this summary field is: CONCATENATE("\nEvent Name: "&{🟣 Event Name}&"\nDate: "&{🟣 Event Date (pretty)}&"\nEvent Time: "&{🟣 Event Time (pretty)}&"\nInfo on sound reqs: "&{Long text field 1}&"\nInfo about parking and dressing rooms: "&{Long text field 2}&"\n") At the moment I am pulling it into the Bookings table as a Lookup, but I think it could also come through as a Rollup. Once it’s in the Bookings table, I have an automation that copies it into a long text field so that the \n formatting splits up the data and makes it easier to read. This i

Money

I want a field that tells me if a volunteer shift is full, using the Volunteers Needed number field and the Volunteers Assigned linked records field. If I could write the code in plain English, something like: IF [number of records in Volunteers Assigned] is equal to or greater than {Volunteers Needed}, then display “YES”, IF lesser than, then display “NO” Checkbox field checked/unchecked instead of “YES” or “NO” text would also be cool but not necessary. I can figure out the IF part, but can I get the [number of records in Volunteers Assigned] just in the code, or do I need a Count field to find that and then use that Count field in the formula?

I want to make it simple for my users to copy a URL or long text field in an interface. I can add a button and it can copy the link to the record, or open the url in the record, but not “copy to clipboard”. What am I missing? This seems like a simple function that could be done?

Is there a way to add the description from asana card to be sent via script to airtable. I have a full script which is pulling fields but it wont pull the description

Hi there, I have two tables: One that stores a sale One that stores interactions Each sale has a date. Each interaction also has a date. There is a client dimension, each client can have multiple interactions. I can link to the interactions in the table where I see the sales. I'd like to calculate how many days are between the last interaction, and the actual sale. In my test, there are three interactions (note: European date notation): 11/2/2025, 28/11/2024, 6/12/2024 These are shown via a lookup value in my sales table. The sale is formatted as follows: 11/4/2025 08:10 If I create a formula to calculate the number of days between last interaction and sales date, I get an incorrect answer: 20189 I think this is because the dates are not treated as an array, but as one text string. Anyone an idea how to solve this? Thanks!

I have a table called table2 which is filled in with a form, and I don’t want the users to have to fill in all their user information every time they use the form. So, I enabled ‘see who submitted response’ and created an automation which on form submission attempts to match the submitter’s email to an email in the user’s table, which is then copied into a linked email field in table2. This allowed me to filter the list of entries via the form so users only see their own entries. However, other linked fields in table 2 do not autopopulate. I was hoping when the automation filled in the email address in the linked field of table 2, all the other linked fields would populate. Any suggestions on how to accomplish this?

How do I choose a specific color for a specific field on a bar chart? For example, Medical should be Blue and Industrial should be Green:

I am in the process of building an order entry and work center scheduling system using Airtable, and I have the base functionality working well. The basis of the data structure is that Orders are created with one or more Line Items to be produced. Next, one or more Jobs are created and linked to each line item. Each Job is assigned to a single Work Center and has a start and end date. I am experimenting with the various views and interface options in Airtable to find a good way to visualize the number of jobs scheduled for each work center by day (or week) for a given time frame, with the goal of identifying if any work centers are overloaded for any given day (or week). I created a formula column in the Job table that calculates the Year and Week # for each job (ie. 2025-13 for the 13th week of 2025). This allows me to group/sort/total chronologically by week. The best I came up with so far is a bar chart that has the week number on the Y axis and the Work Center on the X access, with

If you're looking to build a gaming app, it's not just about having a great idea but also incorporating essential features and tools. A successful gaming app needs smooth gameplay, an attractive design, leaderboards, in-app purchases, multiplayer support, and push notifications. These features not only enhance the user experience but also increase user engagement. For game development, tools like Unity or Unreal Engine are commonly used, while Photoshop and Blender can be great for designing visuals. For the backend, Firebase is a reliable option, offering authentication, notifications, and real-time databases. Monetization can be handled through platforms like AdMob or Unity Ads. With the right planning, your gaming app can easily become popular!

I have an automation that sends students an email thanking them for being a part of a short-term trip with the school and I was wondering if Airtable or an extension that I do not know of, could track the engagement of the student on if they opened the email, or if they clicked on a link, etc. I want to make sure that the email is the most optimized to get the most survey responses possible!