Other Questions

Hi all. I was wondering, is there a script or formula that would allow me to configure the Airtable calendar so that when a user selects an option, it highlights dates that are acceptable for that selection? For instance: Single Select options: Bronx Manhattan Staten Island Brooklyn Queens Outside NY When Bronx is selected, only Mondays are available on the calendar When Staten Island is selected, only Tuesdays and Thursdays are available on the calendar When Brooklyn is selected, only Friday, Saturday, and Sunday are available Etc… If this isn’t possible, are there any free options that can help me? Thanks.

Hello! I’m very new to Airtable, so apologies if this question is not the most intelligent. I have set up the map app and would like to embed it into a website. Is this possible? I would like it to be interactive, for example if a location is clicked it will pull up the Airtable data for that location. Thank you!

How can I expand form search details? When I am creating a form I can see all the details that I want the user to see but on production they dont show, why is this happening and how to fix to allow details to appear?

Hi there, Merry Christmas all! I’m very new to Airtable and all databases in fact! I’ve linked Airtable up to Jotform to collect information about customers when they complete an online survey. This information is likely to include a couple (perhaps more) of different segments. Let’s say; personal details and basic financial information. I’m trying to figure out a way to segment this within Airtable but still keep in the same record for transfer to Google sheets. I’m trying to avoid having a huge number of columns across one “tab” (excuse my use of spreadsheeet terminology) Is there a way I can create a second tab and store this information there but ensure that “row” 1 of each tab is linked to the same person. So when I look to link the data collected up with CRM & Sheets it knows this. A follow up to this would be that after this initial data is collected I would the like to go on and send a second (more detailed) financial questionnaire to customers. This might require a 3rd “t

I’m struggling to find a way to do this and not even sure if it’s possible with Airtable app and can’t seem to replicate the “right-click” on Desktop Version on Safari (iPhone) either. Any ideas?

What Airtable functions can I use to create fields that allow you to select from a list of records, but only allow you to select records that haven’t been selected by other fields on the same Table? Use: I am a meeting planner. I would like to input the names of meeting rooms that are available. I would like to be able to assign a meeting room to a record. In order to not double-book a meeting room, I would only like rooms that have not already been selected (booked) to be selectable options within a record. My initial thinking is that I would create a Table, wherein each meeting room has its own record and that those records are referenced from another table as selectable. Perhaps a second table and links are not appropriate and it is better to create some sort of single select or multi select fields. I should mention that ideally, a single record would be able to select multiple rooms, since some of our rooms can be physically joined to create larger rooms. For example: If Reco

I have problem that image attachments are not uploading from iPhone or iPad. It used to work but not anymore. Not from iPhone or iPad. But when I go Mac OS X, with the same Airtable account and to the same base, it works just fine. When trying to upload on iOS GUI just shows “Uploading 1 attachment …” after submit button but nothing happens. And attachment is never stored to the base. What’s wrong with iOS uploading? Anyone having same problem? How I can fix this?

Hello Airtable Community, I hope that you are having a pleasant holiday season and staying safe. I mistakenly linked my google drive from the wrong google drive account, and I want to link a different google drive account instead. However, Airtable won’t let me enter new google drive account information. When I go to account settings and toggle the switch that says “Link your Airtable account to Google Drive. You’ll be able to create and open Airtable bases from Google Drive”, it keeps logging back into the wrong account instead of letting me enter new google drive account information. How do I clear the google drive account information from Airtable, so that I can enter different google drive account information? Thank you for your help.

I want to use Airtable API to upload images into attachment field. I have created public file storage (Minio), images have public access. I send URL of image to Airtable API in PATCH request. Example PATCH body: { "fields": { "Name": "randomName", "Images": [ --- Attachment field in Airtable { "url": "https://someUrl:9000/attachments/J/IMAGE/upload_tmpfile_1608952265638459111199810539557_01a.jpg" } ] } } Response looks good but image is never downloaded from Minio to Airtable API. Minio use self signed cert and IP (no domain name). What is wrong?

I’m locking make a public database. Is there a way to lock a row’s data once it is entered? But not have the entire field be locked. The idea is that it would be a database of contacts where each contact will enter their own information and be able to see everyone else’s (but we want to lock all previous fields except the one you are entering)

Sorry for the newbie question, if I have the same four tasks repeated daily and I need the totals for those noting respectively, do I need four separate tables to monitor date and total or is there a way to have all four tasks on one table? The end goal is be able to monitor task totals over week/month.

I’m trying to use Dropbox as intermediary file system to get PDF attachments from Gmail into Airtable, using Integromat. Have had a long struggle trying to use GDrive as the intermediary system, which unfortunately does not work reliably. With Dropbox as stepping-stone, it seems I can reliably get a file into Airtable (hurray!) but the file lands as application/binary rather than application/pdf which causes other problems for me - Airtable does not generate thumbnail image, and some of my downstream automations do not work because they think the filetype is wrong. All these files have .pdf in file name, and Dropbox does correctly recognise these files as PDF in its native interface. How can I make Airtable know that these file attachments are PDFs?

Hi Airtable Community, Could someone please help me out, I have two columns, one that is Start time and one is Stop Time, they both have dates and times. I use a formula to get me the total hours between the dates and times. The only issue is, some projects that have start end time of 1/12/2020 10:10 till 2/12/2020 15:30 will give me total hours but I only need it to calculate during working hours which is 7 Hours and not give me a total of hours which include when the employee is not working. Is there any formula that can take in account to only calculate total hours during work hours? I am using this formula for total hours between the two dates. IF({Stop Time},DATETIME_DIFF({Stop Time},{Start Time},"")/3600) Thank you all for any help that can be provided.

I am trying to perform a vlookup type functionality from excel in airtable. Here is what I am trying to do: My setup I have a table called buildings and table called tasks. My tasks are associated to buildings My tasks have a step type, either “Step” or “Milestone” My tasks have a process step like “Data”, each process step has one “Milestone” My tasks have a completion date What I am trying to do On my buildings table, I would like to: Find the “Completion Date” for a given “Milestone” for a given “Process Step” for a given building While not exactly a one-to-one implementation, in excel I would use a vlookup or a match + offset function to accomplish this. Is something like this possible in Air Table?

Is there a quick way to go from a record in the a sync’d view back to the originating view?

I want to store my personal financial info in an airtable base. Including links to accounts, usernames and passwords. Will that info be secure?

I’ve installed the AT app in Slack. It works, but it doesn’t show as an app in Slack and I don’t know how to add a user. ty

Hello! I am wondering if the following is possible: Looking to have a form uses can fill out with different variables. (IE - income, number of children, zip code, etc) I am then wanting to give them (could be via email using Zapier) a coupon code that is predetermined for a certain percentage off. What I am thinking is, there will be different views for each coupon amount, and another table with all the coupons for that amount listed. Ideally, someone would fill out the form, Airtable would then (using Zapier, I assume) assign them a code from the correct table, send the user an email with code, then mark the code as used in the table. Any help is appreciated, thank you!

I am wanting to submit a form and redirect the user to some digested results. Is this possible? There is an example here: https://support.airtable.com/hc/en-us/articles/206058268-Guide-to-forms#redirect but I cannot figure out how to configure this for redirect for the script-digested information post submit. Best, Rose

Hello all, I am wondering if there are tools in AT to compare text inserted in two different cells? Thanks for your time. Caroline

Hi, new to airtable. So I have three tables, A. Subjects, B. Teachers, C. Activities. In table A there’s ‘taught by’ column linked to the teachers’ name from table B (there might be more than one teachers per subject) and ‘length’ column of the lesson taught (in minutes per week simple number e.g. 15, 60, 75 etc.). In table C is form submitted by teachers. Linked to the Subject records and contains things like “playing blocks”, “drawing family”, “playing games with family” I’m trying to Show all subjects taught by a teacher in the B table Count the total subjects taught by a teacher in the B table Count the total hours per week a teacher is teaching in the B table Show the count of unique terms/words from table C from the example to get ‘playing: 2’, ‘family: 2’, ‘drawing: 1’ etc. or a word cloud I tried roll up but it always shows 0 and I can’t find the search term of what I’m trying to do.

Org chart: drag and drop - Show and tell / Product Suggestions - Airtable Community Forum: Org chart: drag and drop like above post and add this function copy whole tree in org chart view

I added a timer app to a table. Is there a way to attach it to a button in a grid view record to directly start the timer, instead of opening the app area, running the app and selecting the record? Thanks.

Hello, with our team we use a custom app. Everything is ok with the app itself the only problem is that the app window vertical size keeps growing waaaay under the screen so we have to manually make it smaller almost every time we want to use it. At first I thought someone from our team with a large monitor keeps making it bigger but it is so enormous that I think it must be some bug although I haven’t found anyone else (apart from our team) to have this problem. Do you have any idea what could be the cause? Either way I consider it a design fault that the app size is shared across the whole team where everyone has different monitor size so that no one can set the app size the way he likes (and keep it that way). Is there any way to change this behavior (or a chance it will be changed by Airtable designers)? Thank you

Hi - I’m trying to help a non-profit organization that accepts membership applications via an AirTable form. As the organization is for military spouses, members routinely need to update information submitted with their membership application. Is there a way a person can update their record with such changes? As it is now, the member updates the form and a new ‘contact’ is populated rather than having the existing information updated. Thanks!