Other Questions

I have a dropdown menu in a form that is linking to another table. The other table has dates and a label for each date. I need the dropdown menu to show both the date and the label for the user. It currently only shows the date in the preview.

I’m trying to troubleshoot an error that’s coming up on a Zap of mine with little luck. Everything works except the last step, which involves updating a field in Airtable with a ticket ID retrieved from Freshdesk. I receive the following error: Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct. I’m not having much luck with this one because I have the exact same zap set up for another table in the same base, exactly the same way, and that one returns no such error and runs successfully. Just to go through each part on this step:The airtable account and action (Update record) are correct, same as the zap that is working properly The configure step connects to the correct base, the right table, and references the record from previous steps and the retrieved freshdesk ticket ID, same as the properly working zapBut for some reason, this one gives the error when a

I found a similar thread from four years ago but was unable to reply. I use Airtable personally, for freelance work, and for my 9-5 all with different emails/log in credentials. I would love a way to easily toggle between these things without having to log in and out every time and to avoid getting access error messages when following a link. Canva and Google both do this very easily. It would be great to be able to do so in the desktop and mobile app. 

Why can I no longer add choices to my “Language” dropdown? I used to be able to select the “Language” column header and select edit, but now clicking on the header does nothing. 

Where in Airtable do I look to find how many emails have been sent per day? And is it every 24 hours or per actual day?

Hello, I want to front load that I am annoyed and have been frustratingly trying to brute force this for two weeks with no luck. This is meant to be read with a neutral tone of voice.My issue: I operate a small nonprofit and have hit a brick wall trying to get airtable to work for what we need it to do. We have a beautiful form that we created, information populates great, but printing the completed form is impossible. I’ve tried creating it with the design tool, but that doesn’t work at all (it’s broken, we can’t even create something to test it), and we can’t afford to pay yet another company hundreds of dollars to do this for a platform that should have it built in.I’m surprised and rather irritated that this simple thing isn’t included in the pricetag for airtable… I have a staff of 5 and a minuscule budget. I can’t afford to pay multiple organizations to do something that we were told was built in. This is literally the only reason we went with airtable over other platforms, and n

Hello - I've searched the discussions, but found no resolution to this issue - to display my database addresses on a map, I have to convert the addresses to GPS coordinates, which I've done - now to re-integrate the new columns with the coordinates into the Airtable base, I found the CSV import extension, which would work great... however, the option to merge by Record ID is not available, and I have no other way to merge them. We have branches of organizations with the same name multiple times - how can I get the same functionality but matching by Record ID?

Hey. I'm new to Airtable because the person previously in charge left suddenly. I think my question is regarding Historical Viewing in Airtable. In an Interface, is it possible to look back further than 30 days ago? I am able to look ahead 10 months but can only look back 30 days. Is there a simple way to do this, or do we need to upgrade our plan to unlock this feature? Thanks.

I am using Airtable with a new nonprofit. One of my bases is all about the Volunteers. I have successfully set up the tables to track contact info, training completed, hour tracking and more. I was even able to figure out how to set up a form for the Volunteers to fill out using a wall mounted iPad to do the data entry themselves for their hours worked. On that form, they are able to choose their name from the existing list because I have linked it to the main table. It works perfectly and allows me to create reports to track hours by person, role, date, etc. But then my boss asked that we have a photo for each Volunteer attached to their information in AirTable. OK. I can do that with an attachment field. But then I decided that I wanted the Volunteers to do that data entry as well. So I created another form that works satisfactorily and allows them to use the same iPad to take a photo. They have the ability to choose their name because it is linked to the main table, and then do an

Is it possible to make a form that requires authentification in order to make sure that “Created by” is populated when the form is submitted?

I have a table with a list of articles that need to be written. The fields on the table are; article id, article progress status, author, drive link, Article title, Guidelines and deadline. I have created a sharable view with which my writers can see which articles they are assigned to and the necessary details without signing in. I collect the articles via a form where they submit the drive URL and the article id with a status (writing done) Problem is, when they submit the article it always creates a new record and I have to manually transfer the URL and change the status to the original record and delete the row that has been created by the form. Is there a way, to make it possible that the writers can submit the URL to the original record and change the status? without signing in.

I am using Airtable for volunteer sign up for an event and wondering if somehow I can add the liability release form electronically. Has anyone done this before within forms? We need a signature and what not so I don’t know if there’s a way to add an attachment they can type in and then that would save on my end. Any suggestions appreciated.

The form that I have will only be used by internal folks and all the information populated will be on their record. We are running into an issue where it says that the “form was submitted by anonymous.” We’d like to track who submitted the form to see how many forms a person submitted in a given month. Is there a way we can have the name of the person who submitted the form? And is there a way for me to link form entries to that person’s record?

How do I collect email address of people who fill the form? Do they need to fill in the email field each time? Or can that be just noted from a logged in user?

I’m trying to create a form as follows; Based on the entry on one of the fields, I send out an API request with the field value. I get a result from the API and I show that in the form itself. Is this possible?

Is there a way I can share just a single record with an individual, via a customized link?  My nonprofit runs a program where people apply and then their application goes through various stages.  We have an Airtable form (as the application), which links to a base where each person’s application is displayed as a separate record.  We would like a way for people to automatically view the status of their application, so we are trying to see if there is a way to share their own record with them, but only their record-- not anyone else’s records in the base. Obviously, we could copy and paste their record and send it to them, but we often are contacted multiple times by people who are wanting to know about the status of their application as it moves through the phases, so we are curious whether we could create a custom link that we can send to people after they initially submit their application.  The idea would be that they can then return to the same link periodically to see updates in t

Hello everyone, I am trying to use Airtable to create a schedule interface for multiple people This is the thing that I would like to achieve. This is sort of a mix between a Genn Chart and the Calendar view, but Genn Chart doesn’t display hours… Any thought? Thank you in advance (!)

hello my friends Can i set a role for validation at entering data in a table ? i have a table that contains promo- codes for a marketing department. Every promo code assigned for a section in sales department. it shouldn’t assign in the table for two sections in sales sales department. is there a role to validate if a colleague is entering a code in the table for department A, a role that says ‘this code is already used for department B’ ? is it available rather than the team filter on duplicates to resolve after that ? thanks

In my interface I can provide a Pie chart that will show the % of yes and no responses to a survey question.Each response, yes or no, is tied to a month value.  I want to see the % over time of the people that reported yes to display a trend chart month over month.  Example in Jan 42% reported Yes, in Feb 100% reported yes. This would be similar to my average satisfaction score month over month. How do I take the Yes/No answers and convert them into a % of the population in order to track month over month?

When I am downloading a .csv file from my base when opening the file in Microsoft Excel some of the data is missing/changed. The field that is having the issue is a linked field that lists numbers from an autonumber field. It seems that after 5 sets of 3 digit numbers the numbers just change to zeros. I have attached photos of the data from Airtable and what I am seeing in Excel.

Hi, I’m new to Airtable scripting and am just learning my way around through hit & trial. I don’t have any javascript experience either, but I’ve used python in the past. I’m trying to write an Airtable script that sends data to my Integromat webhook trigger. So far I’ve been gotten the following: // Webhook URL let webhook = 'https://hook.integromat.com/integromaturl'; // replace with actual integromat URL // Table to send data from let tableName = 'Master Client'; // Fields to bind and send let fieldsToSend = [ 'Client ID', 'Client Name', 'Email', 'Created Time', 'Last Modified' ] I guess I’m stuck with what to do after this. My intent is to use the Airtable automation such that when a new record is created in this table (Master Client), I want this script to run. But what do I need to add to my script so that Airtable sends the information in my ‘fieldsToSend’ variable to my ‘webhook’ variable. All I seem to have done in my script is to create and assign v

How can you embed the full gallery view on a Wix Site. I don’t want users to have to click at the bottom of the table for the full view. I just want the full gallery view posted. Can this be done? This seems like it should be a no brainer but my brain can’t figure it out. Thanks for any help.

Hey Airtable Community. I need help with automating the repetitive task of manually changing the name of a file after it’s been uploaded into my base. As of right now, we have a user filling out a form, and after it’s submitted, I want that to trigger the name changing. I have a field that is automatically created with a formula based on information captured in the form that I want the name changed too. I’ve been looking at using the Airtable automation feature, but after trying a bunch of things, I can’t get it to work (perhaps I’m just too new at this) I also feel like maybe using a script might be the answer, but I don’t know how to do that, and if that’s the path to get this to work, I’ll need your help too :slightly_smiling_face: . Ultimately, I’m not sure and was hoping you (the community) might know. Thanks in advance everyone!

I created a hyperlink in a long text type field, with rich text formatting enabled in gallery view. Works good. But when folks click on the link, the whole card opens. Is there a way, in a long text field with hyperlink, to go directly to the linked URL and not open the card.

Hi all!I publish lots of blog posts about a variety of topics and I have huge comma-separated lists of keywords for each blog post that get fed into a search mechanism for readers to be able to find content that resonates with them.I’m wondering if there’s a way to track all those keywords so that I can see, for example, how many blog posts share the keyword of “tree”? I definitely don’t want to have to select from a multi-list each time I’m entering 50 keywords per blog post, so if I have to just paste the list into a field each time, that’s fine, but it would be nice to be able to have them pointing to a complete list where I can then see how many blog posts we have per each keyword.Thanks in advance!