Other Questions

Hi there, I was wondering if and how I can make a (prefilled) field in a form read-only. I am basically creating a form to answer a question. The form should be generic, but the question should change. But it should not be changed by the user themselves. I know the field wouldn’t “really” be read only since the user could modify the query string parameter, but that would be good in my usecase to prevent unwanted changes to one of the fields. Thanks!

I have three columns: Email Sent (Yes/No) Date (Sent) I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?

I’m trying to expand a base we use as a booking system for photography sessions but feeling stuck. In our current system, users fill out an Airtable form with their contact info and select a time slot (field linked to a table of time slots, filtered by what’s still available). That info generates records in the main Appointments table. This system has worked well so far, as we’ve only been offering slots with one photographer at one location. We’ve been offering 30 slots per day and about 3 different dates at a time, so at most the user sees 90 options, which is more than ideal but has worked ok. Now we’d like to offer 5 dates, but more critically, we want to add a second photo station in a different location on the same dates. That means the user will now be selecting a time slot from a field with 300 options, and there will be two slots for each date and time (eg 10A Monday @ Location A vs. 10A Monday @ Location B). The biggest limitation I’m hitting is I can’t add the same field (ti

I set prefill data for certain columns and created form for other fields. On entering form data, new row is created but these prefill records returned empty. I thought new row will contain prefill data regardless of how it is created. I referred this for temp solution: Can I prefill a portion of a form?

I want to give one link to my users that will help them fill out two forms with pre-filled fields in them. The first form would have pre-filled in field called ProgramID. I'd like it to redirect (or have a button to) a second form with the same ProgramID pre-filled.  I can't for the life of me figure this out even thought this was a pretty straightforward feature on Typeform.  Any one have a solution? I just would really prefer having one flow vs. having to share two different links. Thank you so much!

Is it possible to prefill a form with an attachment field so an image renders on the form? I see this question has been asked twice but no one answered. If possible, it would save us soooo much time.

I've used this very helpful page to be able to export my tables out of air table and into Power Query, and from there into Excel: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportHowever, I'm having an issue that some seemingly random columns aren't being picked up by PowerQuery. I've done this with 5 tables, some have worked perfectly, some haven't. The columns that are missing are different types, sometimes check boxes, sometimes free text fields. I can't work out what the pattern might be, and therefore how I might fix it.I'm hoping someone might have come across the same issue in the past, and know exactly what I'm talking about and how to fix it. 

Hi all, We are on the Pro plan, which seems to default duplicated views to personal even if they were originally collaborative. We mainly use Airtable for grid views, though I’m not sure that has anything to do with the issue. I have searched high and low for a setting or option to NOT do this, as we would prefer duplicated collaborative views to stay collaborative, and not have to manually change it each time. Any ideas?

Basically, I'm wondering how to change the fields shown in a linked record field dropdown/select menu.These fields below (Record ID, First, Middle) do little to help me distinguish among similar records.Note that this particular screenshot is of a linked field to a table that is synced in from another base. But my question stands generally, whether for a table«»table link or for a table«»synced table link—what's the best way to choose my own fields to display, if it's possible at all? 

Hello! I have a calendar with both all day events and timed events and I am trying to display them both in an intuitive way. The problem is…because some of my records have start times, my date fields need to have times enabled…so I have to arbitrarily assign a start time to the record aka event. But then that stat time shows up on my calendar. I don’t want a start time on the calendar because it’s an all day event. Through a series of formulas, I can create calcualted fields which the calendar references so the events without a end date/time show up as date only and the ones with an end time show up with a time. However, because the calendar view is referenced formula fields, I cannot edit the event directly by dragging or clicking; I have to go into the record to edit the orignal date/time fields. Is there a way for airtable to correctly display all day events without a few complicated formula columns? So they can be editable? Thanks, Nathan

Hi -I'm trying to figure out the best way to display, in an interface, how many events are occurring on any given date, so I can calculate staff needs based on this count.Tables I am working with:Events (Events are made up a series of Sessions)Sessions (Sessions might be 2-3 in one day, and each one has date info, and is linked to an Event)Events overlap a lot, and a given day may have more than one Event occurring, so I want to have a way to look at any given date and see how many Events are occurring. Sessions need to be staffed by one or more people depending on what kind of Event, etc.I know how to group records in various ways in various grids and see the sum count by group, but I can't do anything with this number because it doesn't live in any field. Ideally, I would like to display this "Number of Events per Date" number in a pivot table style dashboard.Am I missing some really obvious way to do this?  Would appreciate shortcuts!Rollup? Formula? Joint Table?  Pivot ta

Привет! Ищем специалиста по разработке CRM систем (Airtable или аналогичные инструменты). Нужна консультация. Как вариант - отдадим проект опытному ноукодеру. Пишите в телеграм@zarinaayupova стоимость консультации, портфолио

I'm looking for a way to make accessing and working from an Airtable Task list more efficient.I've got an Airtable base with a table of Tasks that are grouped into Projects.  It's been great for prioritizing tasks and getting things done.  It works great inside Airtable.  But having to open Airtable, go to my workspace, select the appropriate base then view is pretty cumbersome for viewing a To-do list.Is it possible to create shortcuts on my iphone to specific views?Are there ios apps that play well with airtable where I could sync a specific view to a to-do list? (Bonus points if I don't have to subscribe to yet another service)Am I missing some obvious functionality of airtable and making this harder than it has to be?

I recently completed my Certification for Airtable Builder. Are there any builder specific certs that are more advanced than this offered by Airtable Academy?I couldn't find any, but presumed some of the aficionados on here might have helpful guidance.Thanks!

Dear Airtable,I would like to figure out how to keep the public from downloading my members personal information when I publish in Universe. I need to disable "Copy Base", and I want to disable 'download csv' in each table/grid sheet.I must be missing something simple, assuming Airtable isn't intentionally making public customer data. I have the Business level subscription.Thank you.

I have a base of students that I've just shared with my 5 co-teachers as Editors. (We have done this in previous semesters, so this is a clone of a previously used base.) They've received the invitation and can open the base, but two of them have reported that they cannot see any of the records. On my end, everything appears fine.Suggestions? Solutions?Thank you.Vlad Morosan

Hi, New to Airtable, I work in Local Government in the UK and whilst I think the product would work well for some projects I need to understand where data is hosted. Under our Government rules any data I store in the cloud has to be on UK based servers. Most cloud providers we work with offer some kind of location specific hosting of data. I cannot find any information about whether Airtable is able to offer this? Thanks in advance

In the last 2 weeks my enter function has stopped.If I open a record and type txt into a cell I used to be able to hit enter and create a new line. This has stopped yet I have no issues with any other software and the enter function when typing txt

Hi there! I’m writing to ask how we can create a multiple choice grid on Airtable forms. I really love airtable, but need to collect information similar to this: Any tips/suggestions you have is greatly appreciated. Thank you!

Hello, I am trying to sync a view in Jira Server which has over 1000 fields. There are only 7 that I care about. When I configure the sync with selected fields, all 1000 fields are turned on. I do not see way to turn them all off and only turn on the ones I want. Does anyone have any suggestions. 

I’m looking at using forms to collect new records for our bases. In my case, that data is then taken via Zapier to our helpdesk. Everything works fine but there is one piece I am trying to make function properly. When you submit the form, the “Created By” field displays as “Anonymous” How can I set that up so it corresponds to a person within the Airtable system, as the “Created By” field is used to generate who creates the ticket within our help desk.

I have a field that is a string of comma separated text values (two actually...one I created using a concatenate formula, and the other was created with a rollup field...I was trying to see if one of those would work better than the other).I need to convert either one of them into either a "link to another record" field, or a "multiple select" field in order to send those items into a Webflow Multi-Reference field in a collection. Right now, Webflow will not separate the comma separated list into individual values (that I'm aware of). Help!

I have a table with fixed license plates, the cars should be checked regularly and a form is filled out. When the form is submitted, all data from the form should be entered in the correct place in the table.Example:Registration number: ABC-123 in tableVehicle inspection was carried out on a vehicle with a license plate (ABC-123) and now the data should be entered in the table where the license plate "ABC-123" is located. how do I do that?

Hi! I have a table that is defined by an auto-incrementing numerical id, and then the secondary field is "Name". I want people to be able to select records in a form based on that name, or at least validate the ID they've selected is the correct name. Is there any way to display a look-up field within a form, or even better allow a user to select a linked record based on searching or browsing a look-up field?Thanks in advance!

Hello. Right now i’m using air table to manage student information for my study abroad bussiness. It’s very good . But there’s one small problem, i want to automatic export data every day, but i cannot using the API through zapier because it’s not support automatic export. So is there any way i can do this and beside airtable, is there any other tool with similar function but support automatic export. Thanks in advance.