Other Questions

I've been searching airtable forums off and on and yet I can't find a solution that clearly explains what I need to do to achieve my desired results.With the search extension, I have configured the extention to search all tables and sometimes it works fine and other times I get a spinning ball where the search never seems to conclude and fails to reverting anything, even when I search on a known preexisting record. I have tried closing and reopening my browser, closing and reopening airtable, opening airtable in a different browser. Sometimes it starts working again and sometimes nothing I do works until seemingly randomly it starts working again. Any solutions, Work arounds?PS: I have roughly 11,000 records, working via Mac OS and I truly need the global search feature to work (and suspect I might not be the only one experiencing this issue). 

Hi! I’m new with integromat coming from Zapier. I have one scenario (zap in Zapier) with the following workflow: Webhook > Find Airtable record >Find/create a Gdrive folder > Create a google doc from template > Update record in airtable > Upload file in gdrive using export link from google docs I’m trying to replicate the same workflow in integromat and I was able to accomplish until updating record in airtable but when it comes to uploading a file using an export link from google docs it churns out a file.html document and not a pdf file. Below are screenshots of my workflow in integromat. Looking for any guidance on how I can make this work?

I am currently using the page designer app and I am trying to export to PDF using print > save as PDF because I cannot find an actual export button. Unfortunately, when I open the PDF, it’s an absolute mess of formatting and cryptic symbols. Any advice on how to export to PDF correctly?

Trying to work through how I might accomplish this. We are using airtable to store some QC records which eventually have to be passed to an owner and would not be able to live in airtable forever. Table 1 would have the relevant "items" and then tables 2-5 for example would have different types of qc records related to the item(s) in table 1. Table 2 might be paint QC that is for a particular area (1-1 relationship to table 1) whereas table 3 might be a daily report that could cover activity for multiple locations (1-many relationship to table 1). Each record in tables 2-5 would have a PDF attachment of 1 or more pages.What I'm trying to think about doing is running a script/automation/something that would grab all of the PDF attachments, compile then together by report type, then create a table of contents and add hyperlinks in the PDF that match the linking structure in the base. So section 1 would have all the locations from table

Hi,I'm pretty new at managing users in Airtable. I have downgraded a number of user accounts from "Editor" to "Viewer." However, many of them have regained "Editor" status, within a day of the downgrade.Are users getting some kind of notification when I downgrade them?Are there likely mechanisms for the users to regain Editor status?Are there reasonable ways to control for the Editor status, so that our number of Editor (aka billable) users is manageable?Thanks, and have a good day,Joe Montibello

I have a gallery view of event participants embedded on our web site. On the card view, one particular field is followed by a big extra space - see right after the 'City, State' field in the screenshot here:This extra space does not appear when you click on the card to see the record detail:The only difference in the data is that the 'City, State' field is a formula, combining two fields with a comma. But, I don't know why that would display an extra line in the gallery card. Any ideas?

Hi All!Been looking around for a solution to be able to select multiple dates on a form.Knowing that a date field can't support selecting multiple dates I've created a table that has all the dates within the calendar year as records and then am using a linked record field to allow them to be added to the form.The challenge is it's a dropdown that I can only select 1 at a time. I was testing to see if holding CMD or SHFT or OPT might unlock a multiple select ability on the dropdown but no go.For another workflow I created an interface page that allowed checking a box next to desired records and an automation to update a targeted record with the selected POST the form being submitted and creating the target record but that would be clunky for this workflow.Any other suggestions?

I have created a List view with Nested Levels enabled.  The data displayed is good for the nested Field, but I need it to display the data in another area as well.Data.  I have a  Level build like this: Am creating a martial arts curriculum and need certain skills to show in the belts they are learned.  So there are base skills and then "series" that those skills are used in.  The base skill is learned in one belt, but put together in the "series" in the next belt.  By using this nesting I can nicely get the "Series" to show the nested skills under it:But as you see in the last column, those nested values need also to be shown under the Yellow belt, but do not currently.  Is there a simple way to get them to sh

It appears that I am not the sole individual encountering this perplexing issue, as evidenced by numerous prior discussions on the matter. Our organization has been utilizing Airtable for a duration exceeding four years, and we are eager to transition to the Enterprise tier to accommodate our growing capacity needs. Regrettably, my efforts in submitting the contact form on multiple occasions—at least four thus far—have yielded no response.I find myself perplexed, as I would readily invest resources into resolving this predicament, should the opportunity arise.Has anyone among you managed to successfully navigate this transition, or does it seem that Airtable is consistently unresponsive to inquiries of this nature? Your shared experiences would be invaluable.

I am looking for an analytics solution for tracking link clicks and counting attachment downloads from embedded airtable views. Is there a good solution out there for this already? I’m having trouble finding a good resource for this. I have several solutions but they’re rather labor intensive and I’m hoping this can just happen automatically after initial setup. User clicks external link from embedded airtable record on website> +1 count in analytics for that link click. I am about to go test this, but does anyone know if you can use a google events to track link clicks in airtable?

Is there any way to set an automatic log out from Bases? If users are using a base and forget to log out even if they close airtable that persons bases are open to anyone who opens Airtable again on that machine. If there was a way to set an automatic full log out after a period of inactivity this would ensure base privacy. Alternatively could the administrator of the base have the ability to log all users out if necessary.

I have been tasked with automating attendance tracking provided Webex meeting attendance data (which can be downloaded as a CSV). I understand I'd need a common key in order for the data to mesh, but I am struggling to understand how to get Webex and Airtable to talk with each other and update the airtable automatically. Any advice on making Webex and Airtable talk to each other would be welcome. 

We have a couple of public forms where we are collecting information from customers. (Registration for Ten Digit Long Code (10DLC) SMS/Text-Enabled Landline Telephone Numbers) Once they hit ‘Submit’ they no longer have access to the information. Often times they make mistakes or need to add updates. We would like to be able to generate a URL that we can email or text to the customer that would open the form with whatever is in that particular record (obviously protected by a GUID or something similar a-la shared google docs) Is it possible?

I’m using the from view for people to register for an upcoming round robin event! I’d like to lock submissions after we hit 12 responses. Is there a way or workaround to make this possible? If not, no worries. How can I “lock” it manually to prevent additional entries?

Hi everyone, I’m new to arrays and I think I’m missing something very obvious here but I thought I’d ask and see if someone could point it out to me. I have a base which has two relevant tables, Customer and Other Party. Each Customer could be related to one or more other parties and vice versa each Other Party could be related to one or more Customers. Each table uses the email address as the primary key. I’m trying to connect the two using data fed in from a Cognito form via Integromat. After the form submit trigger, I’ve got it iterating the customers, searching for the relevant Customer Record IDs and aggregating the Record IDs into a new array so the output is Array=Collection1(ID=rec…)/Collection2(ID=rec…). It’s correctly identifying the related customers and their Airtable record IDs, but the problem comes when I try to use that information when I’m creating the records on the Other Party table. There’s a field called “Linked Customer” and I’m

Currently, the record level revision history shows with the oldest on top. That view also puts newer comments at the end/bottom. If I want to see something recent I have to scroll all the way to the bottom. Is there any way to reverse that so that comments and revision history shows with the most recent at the top?

Hi, I’m starting with Airtable and I think it’s excellent. I try to move all my work with Googlesheet to Airtable, but there is a functionality that I can not find and that I miss. It is the Autocrat complement. With this add-on I automatically generate, with each new record, a pdf file that is also automatically sent instantly by mail to an account extracted from the registry itself. It is necessary for me in my work, and I wonder if it is possible to do this with Airtable and some additional complement, or if on the contrary I should forget about it. Thanks, and excellent work!

We are a Civil Contracting company and just started using airtable for some simple data tracking.  What we are trying to do is build a simple "app" that can house some forms for our drivers to fill out thru out the day, ie material load info and refueling info.I have built some forms that use a sharable link, it works but is cumbersome when there are several different forms for the drivers to use.  I was hoping to figure out a way to either set permissions in airtable so the driver can only view and utilize the forms or have an "app" that hosts the forms in one spot.  These are truck drivers and not all of them are tech friendly so I need to keep it as simple as possible.Thank you in advance for any ideas on how to tackle this issue.

Is there a way to put edit-checks or validations on a field? I’d like to restrict the range of numeric values that can be input to a numeric field.

I’m doing a deep software selection and i’ll evaulated a lot of other software like airtable, and i have to say that Airtable is what i can say the best in class if we consider the 90% of the use cases our company needs. What it seems to lack, but i cannot realize it clearly (it seems to me so fool) that its not possible to do data validation. Let’s say a simply use case: I want my collegues to fill in the hours spent on various task (not in real time with the time track app, but simply at end of the day or of the week). In airtable is simple: new grid, i add a column TIME SPENT of type INTERVAL and i’m lost? i can i force to insert only an x number 0 < x < 8 ? i dont want to let them fill in a WRONG record and with automations try to send email, rewrite numbers or other thing: simply to forbid a wrong insert if it does not respect the restriction rule. I’m not sure it is not possible, but i’ve invested a lot of days of study and i only found workarounds. It looks

If I have fields in a table with specific types why doesn’t the form validate those types before submitting the data? There seems little point in specifying a field type of email if someone can enter whatever they like into the form. I realize that client-side form validation is non-trivial but there at least some native browser validations that could be implemented fairly easily.

Hey Community! Here’s my problem: I have users adding phone numbers to records. Problem is, the way the are inputting records doesn’t allow me to have Data validation. I need the number they input in a specific format, and I was hoping there might be a formula that could do this. Format we need: 1 (XXX) XXX-XXXX Inputs we might get (because users make mistakes) = 1 xxx xxx xxxx xxx xxx xxxx xxxxxxxxxx 1 (xxx) xxx xxxx (xxx) xxx xxxx What is important for us is there is the area code, aka, a “1” at the front of every number. I was thinking about creating a formula that adds a “1” at the start, but in the circumstances where a user does what we want, and adds a “1”, I don’t want to add it as it’d break it. Does anyone know how to put a formula together that’ll do this? PS, Bonus points if you can ensure it looks “pretty” by formatting it in this wa

Is there a way to enforce data validation on a field? For example, if I want to enforce users to enter a name under 20 characters or less, can I do that?

Hi guys,I'm creating a escape room form, so the group can select the room and time they want to play.There are 3 rooms (each one with 5 different times to play).When a group select the room/time (example: Room 1 - 20h) this room can't appear on the form anymore.How can I do that?I read in other message here to create a new table with all the possibilities (I already did that), and created a link to another record in the main table (which is used to create the form).I tested it but it didn't work.If anyone could help me, I appreciate it! Thanks

I have some equipment inspection checklists that I am trying to move from paper to Airtable, and I was wondering if there was a way that I could convert it into a fillable PDF and put it in an Airtable form. The employees fill out these checklists when they’re at worksites, and the office is out of their way, so the forms don’t get dropped off as soon as we’d like. What I am hoping to do is have the employees fill out the PDF in the form, then have the PDF saved to the base as an attachment so that we get the forms as soon as they’re finished, and it’s easier for everyone at the worksites. I already tried converting the checklists to Airtable forms, but there are just too many checkboxes that would each need their own field, and it would just end up being too inconvenient to fill out and sort through. I also tried using the attachment field in a form, but this would require the PDF to be filled out in a different app (or scanned), then saved, and then submitted through the fo