Other Questions

Hi, Hoping someone can help me with a best practice for the following scenario. I use Integromat for a lot of my business’ automation and I am happy to use it if it’s the best way. Personally I can’t write script/code but I am happy to attempt to google and learn what I need (then finally accept that I need a professional lol) I want to utilise Airtable to assist our HR processes & staff data base management with another staff data base for a particular type of employee. My goal is to bring applicant details into a basic recruitment base to manage the application process. Then I would like to automatically copy successful applicants to a staff database table. This table will have additional fields for all of the staff details as well as a link to their google drive folder which will have all of their sensitive information. I then would like to have a separate base which will be for certain staff (conditional on ‘Employee Type Field’) like C

I have a multiple select field that contains currency per time — Example: “$5/month”"$200/year" “$12/month”"$116/year" “$9/month”"$89/year""$300/year" Most records have two values, some have three values. I’m trying to split these multiple-choice entries into different fields and have them be currency fields so I can look at averages, etc. Any suggestions?

Is there a limit to the number of items in multi-selection field in airtable? For example, I am wondering if I can make 1,000 or 10,000 items?

How can I invite by link to base and disallow to download video file ?

I am trying to perform a sort of Audit on a database I am managing. Is there any tool that will export or summarize how may tables I have, views I have, fields used, etc… A sort of audit or data summary tool? Anything is helpful.

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 questionna

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

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