Solved

Really excited about the new permissions for the interfaces :raised_hands: Now maybe I am just not seeing the option, but is there any way to add a simple password protect for viewing the interface? Like we have for sharing specific views? Thanks!

Over the course of a project we will be conducting a series of feedback surveys, each with the same questions, but after different events. I plan on storing responses to each survey in its own table within a base. Is there a way to duplicate the form to different tables? I will need to do some minor updates (e.g., changing the introductory text), but the questions would be the same.

Hello,I have created a check Request form in my system.  For some of our transactions we will deal with multiple transactions but I only want to have one button.  I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to create a nested if Statement (or open to other options) to fill the check Request field with the newest fee.  For example If Fee 5 is empty but Fee 4 is not then I want Fee 4 populated in the field.  If Fee 5, 4, and 3 are empty then I want Fee 2 to populate in the field.  And so on.  Appreciate any direction. So far I created a nested if Statement but it only works for the first field then no longer works.

Hey Community!!Not a real actual current use case, but thought I'd spice-up the community a bit to kick-off the year! I can think of different workarounds for the following edge case, all of which could theoretically work (although not ideal) however I'd love to get to know your thoughts for it as the same logic and issue applies for other use cases.E.g. think of music concert tickets with initial stock of two (2) tickets.If Buyer A, Buyer B, and Buyer C all open the form at the same time (or before any submission occurs), they will all see availability of 2 tickets.Even if Buyer A purchases 1 ticket, available tickets shown on Buyer B and Buyer C's screen will still show 2 (unless they refresh the form and therefore retrieve new updated data from Airtable).This will not be an issue if Buyer B purchases 1 ticket immediately after -as there is still one ticket left.However, by the time Buyer C wants to make the purchase, the form still shows 2 tickets are available, however there is act

Greetings, Airtable community!I wanted to reach out to ask for your ideas and assistance with a road block I ran into:I have a Fillout "SignUp" Form that allows clients to schedule themselves for an appointment at the specific appointment time they choose. I've successfully customized Fillout form to show ONLY "unfilled" appointments (based on an Airtable view) when the client loads the form.The problem is that if 3 people load the form at the same time, then they can all 3 "Sign Up" for the exact same appointment. Since they all loaded the form at the same time they have the same options given from Airtable. And since the form doesn't update in "real time" unless they refresh the page, then there's no way to keep them from all 3 selecting the same Appointment time.On the back end, this means I received 3 SignUps for the same appointment and a "Something Went Wrong..." email from Airtable. I then need to manually go back and remove the extra signups and have 2 of th

Hello,I have a table that is synced with transactions from my bank account, but I need help with extracting data from a JSON string stored in the Notes (Long text) field.An example of the JSON looks like this: { "transactionId": "2022142460021", "endToEndId": "\/VS2501000545\/SS\/KS308", "bookingDate": "2025-01-10", "valueDate": "2025-01-10", "transactionAmount": { "amount": "-390.00", "currency": "EUR" }, "currencyExchange": [ { "exchangeRate": "1.00000000", "quotationDate": "2025-01-10" } ], "creditorAccount": { "iban": "SK9111110000002303283006" }, "debtorName": "COMPANY s.r.o.", "debtorAccount": { "iban": "SK8511000000002622224000", "currency": "EUR" }, "remittanceInformationUnstructured": "Platba faktury 2501000995", "remittanceInformationStructured": "[{\\"reference\\": \\"2501000995\\", \\"referenceType\\": \\"VariableSymbol\\"}, {\\"reference\\": \\"308\\", \\"referenceType\\": \\"ConstantSymbol\\"}]", "additionalInformation": "Platba 1111\/000000-2303283006", "bankTransac

I have a table with an Attachment field holding a PowerPoint  PPTX file.Is there any way (in an Interface or another) I can Drag and drop that file into another (Windows) application? Just adding the file to an Interface doesn't seem to allow drag and drop.Specifically, I need to drag the file into Canva - Create a Design (Upload). Thanks!

Does anybody know or has script you put in extensions and automatically shows post and comment karma on airtable. You need reddit api and airatble api. And a script that i dont know how to write. I would appreciate every help

I use Airtable for something related to website data. I have a table which is a list of pages/URLs from a website, which was extracted from Google Analytics. The key is the URL/page but it also contains data such as the volume of page views and other statistics about the page. In an ideal world I want this table to update automatically, so e.g. the data is always about the most recent month. I know there is a zapier integration but I can’t get my head around it, mainly because what happens if someone creates a new page in the source data i.e I am not just updating records based on changes to the data in Sheets, I need to also populate new records. Is this multiple Zapier integrations??

Okay I think this might be a tricky one but let me know if you have any answers. Here's the basic concept. I'm producing a summer concert series and I want to create a budget and expense tracker. I want have a couple things I'm trying to accomplish.First, I want to be able to create a budget and allocate an amount of the budget to a certain category (labor, rentals, food, etc.).Next, I want to be able to track how much we are spending on each of those categories for each show. (Show 1: $1,000 on labor, $5,000 on rentals, $150 on food, etc.)Then, I want to link those together. For example, I want the show totals for each major category to then update the overall season long budget (the first item). Ideally, there is an interface with three pages. One is the Overview dashboard which shows the total budget, total spend, and remaining total budget. It would also show each individual category with total budget, spend & remaining. The second page would be a page to edit the cat

Is there a way to give a user access to 1 base in a workspace, but not another? Thanks!

Hey there, I have a problem with the interface form an airtable app i created. When i want to open the 'socials' interface, it doesn't work and it gives an error. I have tried numerous things, but nothing works. I also tried to get help from the airtable support, but they couldn't help me as well. Is there somebody that has experienced the same problem? Thanks in advance 

I've build out an Airtable database that's working well but I'm getting stuck on what to use as a frontend. It's an internal lease management tool that needs to have a client login.We need the ability to have user permissions, an easy to read dashboard that looks nice, the ability to update records and export data.It also ideally should be a tool that does not have a steep learning curve.I started using Softr but then saw that the dashboard elements are only available on the professional plan ($139 a month) which is more than we want to pay right now. I tried Noloco which was great but the dashboard elements didn't present the information the way we needed it and the aesthetics weren't what we wanted.I would be so grateful for any ideas on what is the way to go.Thanks!

I have some items pulling into an interface.  I have 3 three fields.  Priority , User, and a description.  Is there a way to increase size of the user field to show full name versus truncating? I have hidden name but you can see that top one truncated and if there are two leads you only see the first one unless to expand to see all details?

I'm creating an office Desk Reservation system and I want to take the next step to make it even more user friendly by adding a unique QR Code to each Desk, so employees can walk up to the desk, scan the QR Code, and have the Desk Registration Form open with the Desk Number from the QR code they scanned Prefilled.I'm currently stuck on how to get the QR code's information to Prefill data in a single Form...and I dont want to make a Form for Each desk, that would be silly.Any help would be greatly appreciated

I've been searching for solutions for hours for this. My perfect worldEvent staff open an attendance tracking form. They select the event and class that's about to start. The walk around the room and scan the QR codes (could be barcode as well) on all attendee badges. Each scan adds that attendee (already an existing record in Airtable - that's where the QR code will come from) as a linked record to that event/class record. They add everyone in the room, and submit the form with everyone linked. Potential workaroundsMaybe directly linking multiple records into one field with QR codes isn't possible. If not, maybe there are ideas for how to do one of the following instead:Create an entire record when a QR code is scanned, and then collate that info later. But I would want to somehow link both the attendee and the class in that one scan, so if the QR codes are on attendee badges, I'm back to the same problem of how to include all those scans under one class umbrella.Airtable's

Hi everyone, I’m a pretty new Airtable user, so sorry if this question doesn’t use all the proper terminology. In short, I’m creating an automated appointment system for my organization. I am using a form to collect user information and create records that track scheduled appointments. Users select their preferred timeslot from a list of available appointment times (achieved by using a linked record field limited to an “Open Timeslots” view in a different table dedicated to tracking availability). The issue I’ve run across is that I only want users to be able to select ONE appoint time, but the linked record field allows for multiple appointment times to be selected. Is there a way to limit users to one selection with a linked record field? If not, any ideas on how something similar could be achieved? More details: I’m working with two main tables: Availability and Scheduling The availability table contains appointment slot records, the primary field is a date field with the date and s

For a linked field, is there a way to limit record selection to a view based on the user?I have a Task table, with specific tasks for specific users.I have a Time table, where a user selects the taskDepending on who the user is, I want the only the tasks meant to be available.The only way I've been able to figure it out is to create multiple linked Task fields in the Time table. Not ideal.Thanks, David

From my research, I think the answer to this question is, "it can't be done", but I'm hoping I'm missing something.My base has 3 tables:Waiting List - this is the "main" table, listing the people on the waiting list.Events - defines the events for which people may be waitlisted.Site Types - lists the possible site types that could be available to a person on the waiting list.Here's a highly simplified version of the base that illustrates the setup.Each record in the Waiting List table is linked to a single Event Name record in the Events table.Each record in the Events table is linked to one or more Site Types in the Site Types table. This link field defines the subset of Site Types that are available for that particular Event. This data is repeated as "Available Site Types" in the Waiting List table via a lookup field (if it's needed). As I have it set up, one Site Type record can be linked to multiple different Event records, but that's not mandatory--if it helped solve the problem,

I am trying to learn to use automations to update 2 summary tables so I do not have to keep copying and pasting every time I update a table.Table for new record:  Donations.  Summary Table: Donation Totals Yearly Summary Report.The two table are linked by the Donation Date primary field in the Donations table. The summary table linked field is called Donation Table.Let me summarize what I think I need to do to accomplish this. I need to create a trigger that says When a Record is Created in the Donations table. This tests fine.Then when I create that record in the donations table I need to have an action happen. I have chosen the Update Record in the action. That action is to update the Donation Totals Yearly Summary Report table/Donation Table field with the contents of the Donation Date field in the Donations table. To do that I need to choose the Update record choice in the Action type field of the automations screen. Then choose the Table in the configuration section

Hi,I am trying to figure out a way to copy data from one record to another in the same table. In the example Ordrenummer primær should be the key and I want Navn and Mail from the record with values to be copied to other records with the same value in Ordrenummer primær.Thanks for your help./Michael   

HiI'm really, really trying to love interface forms and the design is much improved but is it really the case that you cannot prefill linked record in the form? I've tried with Recordid and with the name and it doesn't work. Other fields are fine (that I have tried) but not linked records. I believe its also the case that users need access to the base to submit if its being used as an internal form. Can anyone confirm these, are there work arounds. I'm having to abandon them for now and build with old forms 😞  Cheers Jason    

Hey all,I recently needed to switch an email automation from "Send email" to "Outlook email," to fix a spam filter problem. Previously, when it was being sent as "Send email," a link at the bottom of the email led all recipients to the record detail view of the submitted record on a particular interface - even though interface links are not currently insertable, and I had to assemble the link myself, it still worked fine.They look like this in the Automation message body, where the parenthetical is the inserted dynamic record ID:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/(AirtableRecordID) But now, with the Outlook email automation, the links are broken. Something in the chain is adding two BOM bytes into the link, so it goes to this link instead:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/%uFEFF%uFEFFAirtableRecordID Is there a fix for this, or something I'm missing? The only other thing to note is my org uses urldefense, which wrapped the links when the automations were s

Hi everyone, I'm wanting to improve upon the Extract Base Metadata script to include more features. Has anyone experimented with this?Ideally it would:Gather the metadata currently acquired by the Base Metadata Extract extension (listed below)Be capable of running automatically at regular intervals.Indicate if the field has been deleted.If the field is a linked record field to another table limited to a view, name that viewIndicate if the field is in use in an interfaceSHOULD: name those interfacesIf the field is a lookup from a linked record, name the originating recordSHOULD: link directly to that recordShow which interfaces the field shows up on and make updates when fields are removed or added to interfaces

I found multiple posts stating we can’t create new columns/fields on a base but then I also see posts like the following two where the script looks like it’s calling a create() method. Are we able to create new columns/fields through a script? Does TypeCast only work on Create? What about Update? API Does typecast only work on .create? What if I want to update a mule-select field in update? base('Sites').update([ 79 { 1 "id": recId, 2 "fields": { 3 "siteStreetAddress": {!!placeDetailsObj.street_number ? place… Fix for INVALID_VALUE_FOR_COLUMN for single line text column API Here’s a repro case for a table with column “SingleLineText” which is o