Ask the Community

I would like to set up an automation so that every Monday at 7am, any checks under my "completed this week" checkbox field will reset and be unchecked again. How can I do this? I have tried a few things and continue to get input errors. Step-by-step instructions (As I am a beginner!) would be very helpful. Thank you SO much!   

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 sc

Hey team! We use forms a lot on our team. I would love to have QR code for each form along with the generated link.

https://solidbackup.app/ Just happened to come across this when looking for some updates on how to download images in bulk in Airtable. This looks quite interesting but I can’t buy it from my Apple App store. It looks only available in the US Apple app store? Any experience?

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 r

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 defin

Hi all, Im trying to display all relevant information needed in calendar view for a job by altering the primary field accordingly: However I do not want this information showed in form view when my customers are selecting their job from the list of created records: Ideally I would like to have just the job number and the year (12 / 2018) on show to the customer. Can anyone suggest a solution to this? Thanks in advance :slightly_smiling_face:

Hello, I've been experiencing some issues with Airtable the past few days and thought the community might further insight into what's happening.Essentially, my base has been loading very slowly and when trying to select a linked record it often times out. When editing other fields (text, date etc.) it sometimes shows the error below. This has also been happening to my colleague, who is on a different network and uses a separate account. The issue happens intermittently but it's causing big disruptions to our workflow, especially when we need to re-enter data because it didn't save before forced to refresh.We've recently integrated our Airtable base with Glide and have also been adding quite a few extra fields (some auto populated and formula-based) as we develop a new website and also sync data across that.I'm wondering if the amount of new fields (particul

Hi Airtable Community, I have an Airtable base for Health & Safety for an event. I have an Airtable form which is populating data in a table called "Declarations" (these come from a subset of our stakeholders). I have a second table called "Inductions", which is being populated via an integration with a Jotform form. This second base includes a broader set of data, but critically everyone who completes the Declaration form also needs to complete the Induction form.I want to create a third table which summarises who has completed which of these forms, using email and/or company name as the common field. I'd also like to check this data and link it against other lists in other bases (eg Volunteers, Suppliers), using their contacts to sync data. I am still something of an Airtable rookie, without coding skills, so looking for an explanation that is accessible please - i want to learn a solution, so i can use it across my Airtable

Hi everyone,We're building a decision-making tool. This tool has tables for Topics, Participants, and Positions – each participant takes a position ('Go', 'No-go', or 'I don't know') on a topic. Each position type is matched with a numerical value: 1 for 'Go', -1 for 'No-go', 0 for 'I don't know'.In the pivot table below, we'd like to display the participant's position in each cell instead of his/her position's numerical value. Do you guys have an idea of how to get this done?Thanks! 

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

Just yesterday my automation set up to send a text out through Twilio stopped finding the phone number and putting it in the TO field (see image).Here is what I have already tried:I verified that the user had a number in the field of the failed automation. I made a new field that added the Country code to the phone number and selected that field value (at least I think since I didn't see the "Value" image appear where the last one was.I don't know what else to try. Suggestion please!Thank you

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   

Hi everyone,I have a scenario in Airtable where I want to dynamically control the visibility of form fields based on boolean values from another table. I’m proficient in Python, SQL, and JavaScript/Vue3.js, but I'm struggling to implement this logic directly within Airtable's environment.I want to use these boolean values from the Analysis table to control the visibility of form fields in the Application table. The challenge is that Airtable forms seem to be bound to a single record and don't directly allow dynamic visibility control across tables.Can I use JavaScript or Airtable scripting to dynamically control field visibility in a form based on boolean values from a linked table (Analysis)?Alternatively, would it be easier to restructure the process by splitting the form into multiple steps (e.g., first upload the PDF, then show the relevant fields based on boolean values in the next form)?Any help, pointers, or examples would be greatly appreciat

Hi all,Firstly, apologies if this has been asked / answered before, I had a search through and couldn't find it.I'd like to import a number from an external website and automatically update it when it changes.  Also would I need their permission for this?The website is transfermarkt.com it gives an estimated market value for individual football / soccer players.  I have a database of players, and I'd like the estimated value for each one in a column.Is this possible?Many thanks in advance Barry

Hi everyone,Please help me, i deleted by mistake an interface, where can i retrieve it?? why can't i see it in the trash ?A million thanks  

I am trying to create a way for people to subscribe to a newsletter. The first form allows them to put in their name and email address. It works fine. I set a field called "Status" to Unconfirmed (as Single select type).I will then have an automation that will email them a link to a form update (with the record_id() etc).  I want the form to just have the Submit button (in which I change the label to "Confirm Email".  I can have the Status field on their for them to select "Confirmed", but I'd rather it be passed in, hidden and changed to "Confirmed", so when they submit the form the status gets set to "Confirmed".So I have the edit form (in fillout), I created the URL id of Status, and I set the formula to "https://forms.fillout.com/t/rBuRDxxxxus?Status=Confirmed&id=" & R

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    

I have the following case history:a base with multiple tables interconnected with each other;I've created an interface form to populate one of these tables;In this interface I have a field that allows me to select a record linked to another table;In this field, again from the interface, I have the possibility to choose only existing records;Is there a way to add, from the interface form, a new record directly from the field with the drop-down list? Directly from table this is possible, but not from the interface form or any form view. Many thanks

Hey all! I'm running into an issue when building a form. I am trying to build a publicly accessible form through Interfaces that also includes population through record linking. For context, this is a form that clients can use to order supplies from an organization. My ideal workflow for this would be; the client selects their Record ID in a linking field, and once they do, an automation pre-fills the form with their usual order. They can then edit it if there's something they would like to add or remove.  I've built the automation, and I've built the form - but now how do I get them to work together? Is this feature not possible? Looking for straightforward solutions before I go down a rabbithole! Thank you in advance for your time and help!

Every week I add about a dozen fields to my base that are the same field type (and only updated to the current date). (The group each week includes the same field types in the group, however, they are not all the same field type, make sense?) For example, Revenue x/x/xx (dollar, integer), Date created x/x/xx (date field), new accounts x/x/xx (number, integer), …etc Is there a way I can do this in a batch as opposed to creating each new field?