Other Questions

Hi, I am new to Airtable, I have searched but can’t find the answer. I am importing a spreadsheet of about 2500 rows and am planning on adding more, new data. The existing 2500 have been proofed, but the new ones will not have. I want to add a check box and mark the 2500 existing ones to indicate they have been done, but don’t want o have to check 2500 boxes manually. Is there a way to set multiple items to checked? TIA

Hi Everyone, Thank you for reading my message ! I’m encountering an issue I don’t understand, as it should be pretty straightforward. Maybe one of you may help… The “Event” table is Linked to the “Invoices” Table, through the Invoice_ID’s linked record (see below) : An Event can have multiple invoices attached to it (as in multiple attendees). However in the above screenshot, the Invoice ID that you see IS NOT in the “Paid only Invoices” View, and appears anyway in the Linked record field which, as far as I understand, should not : My idea is to manage Event stock with Paid only invoices, so for me it would be very practical to have this information on this table. Thank you or your help with this ! Best, Da

Hi, If i wanted to import a database from Bubble.io that includes the users, is there a way to do this? Bubble doesn’t store passwords in the accessible part of the database (and that’s a good thing obviously), but I’m wondering if there is still some way to do this which doesn’t force all users to do a password reset? Thanks

I have an integromat scenario that does the following: When I get an e-mail I tag it in Evernote with a specific tag This triggers integromat to put the data from that email into a table called email updates One of the columns is the content of the email in HTML format. I then host a web portal via Softr which automatically adds the email added to the email table by using the HTML content in the airtable field. Although, none of the images work. Is there a way to make the images appear or perhaps remove the images completely from the email? Preferably make them appear! Thank you Best Wishes, Your Friend

“Unable to clear the selected cell. The selected cell is in computed fields.” error message What am I doing wrong???

great! so how do I see if I have wiped all the possible collaborators from a workspace: I already checked the top level settings, that’s done base: I kept clicking till I found the shared views and deleted them all table: I don’t know how to view all collaborators on the table the answer to sharing was to send a record from my kanban or form, that is really great thanks

Hi there, I am wondering if it is possible to use an AirTable formula field to take a list of city/state names: … and turn it into a new field representing the timezone that city/state is in. Or would perhaps my best solution be an IF(OR(FIND formula with a list of city/state names and timezones? Any help is appreciated!

Hey - two quick questions. When using the Map App, is it possible to remove markers for things that are not in my base? For example, when in light mode, I can only see my markers, but when in map mode, I can see other things like grocery stores and restaurants. I want some of the features of the map mode, but would like to hide the extra markers. Also, other than a screenshot, does anyone know how to export the map so it can be printed?

In the Help-Database, there is a description saying how to add records directly into the gantt-view by using click-and drag. This doesnt work for me; after having clicked and dragged, the square dissappears as soon as I let loose. Adding records by rightclick works well, but unfortunately doesnt add the group i click on, like it automatically happens in a grouped grid-view . Anyone having the same experience, or even better, a solution for me? (I have all rights to create records in the database and the view is my own. I work in the Windows-App.) Thanks, Peter

I use Airtable to help visualize and share data for our high school. Currently, I have a view that is set up with the following columns: Student (Text Strong) 1st Block Grade (Number) 2nd Block Grade (Number) 3rd Block Grade (Number) 4th Block Grade (Number) 5th Block Grade (Number) I added another column, a formula column, that was intended to display the number of classes each student was failing. The formula works at each level, but the formula itself is too long. Airtable truncates it. I am self-taught with regard to this sort of stuff, so there is probably a more elegant way to do this that fits within Airtable’s capabilities. I anticipate that someone will ask why I do not create a view and use the filter to achieve what I want, and my answer is that I would have to redo the filter every 9-weeks when new grades are being uploaded. With this formula, I can update the column names using Ctrl+F in Google Docs, then copy/paste it into the formula field. Any suggestions? Than

Hi all, I would know if it is possible to copy and past multiple cells from excel to a shared view in one time and if yes how can I enable it Thanks

Wondering if there’s a way to force the embedded views to keep a collapsed grouped view… When I directly access my base, it keeps all records grouped AND collapsed, but as soon as I embed to my website, the records are grouped but expanded. Any way around this?

Hi all! I need help in calculating the average value of a single select field. I tried the count(values) and it works. However, AVERAGE(values) gives me NaN. In the image 2, I’ve created a roll up field of the linked records An alternative to this is creating a field in the first table with the formula VALUE(Strategy - Top Ten Targets (Pitch 1)) and then using the roll up function on that field and works! But I want to know whether it can calculate the average just by changing the formula in the roll up field. Thanks in advance!

Is there a way to setup ‘is-a’ relationship among tables? ex: We have a Person table with atttributes like email, name etc. We want to setup Employee table that inherits all attributes of Person but has more attributes like salary etc. Is it possible to setup “Employee is a (Inherits from) Person” relationship?

I would like to know whether our team who are not full-time are able to view their respective project details outside of Airtable say via email. As our field leader would not want the team to see details of another team member’s information: Jack - Burundi , Daniel- Tanzania , and Ryan - Mozambique for example, each member should only have read capabilities of their respective projects? Is this possible outside of Airtable via the field manager sending them their project details via email from Airtable or would each team member need some sort of access to Airtable to view their respective projects only?

I have a table that is a list of people. Call it “People”. Say there are 5 people. Then I have a table that’s a list of deals. Call it “Deals”. Say there are 3 deals. Each Deal record has a “closing date”. Then I have a table that’s a list of investments made into Deals. Call it “Investments”. Each person can invest in each deal. So there are as many as 15 records in the Investments table – one for each intersection of Person and deal. I’m trying to come up with a way where, in the People table, I can see the date of the most recent investment each person made. And then I want to sort by that date. This way I can see who hasn’t invested in at least X months and I can reach out to them to try and reactivate them as an investor. I’ve noodled on this for some time but no solution has come to me. Any ideas? People can make Investments into Companies. People can make as many investments as they

Hi everyone! My name is John and I am the founder of NoCodeGuides.io which makes it easy to find NoCode developers and mentors. The site allows for purchasing calls with vetted mentors as well finding NoCode developers to build your project for you. My mission is to make it easier to ship your app using NoCode, whether that’s just by getting a little extra help or having someone do it for you. I’ve built up a solid network of vetted NoCode developers and am adding Airtable as a category. If anyone is interested in signing up as a developer and or mentor please click the Sign Up button and select to register as an expert. nocodeguides.io Find a Developer or Mentor for your NoCode project. We have experts in... NoCode can be hard sometimes. We fix this by connecting you to vetted world-class NoCode experts to help you with your application or to build it for you.

I have 4 plus events in my calendar and only 1 or 2 of them are visible in the week or day views. The afternoon appointments are not visible at all but the first appointment for the day is. Does anyone know why? If I switch to 2 week or month view I can see multiple appointments on each day.

Hi everybody! I’ve started using Airtable to create an inventory for work, I’ve started working with creating multiple tables: Employees | Devices | SecondDevices | Other Devices | Monitors | Group1 | Group2 | Budget I need to sync all devices (Devices, SecondDevices, OtherDevices, Monitors) that have a tag within budget. The case being that budget has 2 types, internal and external budget. Goal 1: All external budgets should be exported or synced to Google Spreadsheet automatically. Goal 2: Entries in one table should be duplicated when added a tag. Question 1: What is the best (free) way to sync Airtable to spreadsheets automatically. (register new entry’s and update old entry’s) I tried Zapier & Automate.io and it is not possible with the free licensing. Question 2: Can I create tags in Airtable? Question 3: Is it possible to add an entry and that it get’s autofilled in another table by adding a tag or through another way? A lot of questions, I know. If there is something that’s

We’re on a Pro plan and use one of our user accounts to log in to a handful of workshop floor devices. I appear to have hit a limit on the number of devices that can sign in using the same user account. Is there a maximum? What is it?

Hello dear Airtable community! :wave: Is it possible to add a fixed prefix with a randomly generated 4-digit number to a new entry? – So, a new entry is created with name and first name of a person in two columns. And in a previously created 3rd column called “CODE”, a 4-digit, randomly generated and unique number code is now automatically added (1234) to a previously defined prefix (#AB): for example #AB1234 or #AB9876. Who knows advice? Thank you very much in advance!!! :pray:

Hi, I am a total newbie to Airtable ! I just created a first basic form with email, phone, name, … And this data is directly outputted in my global database. Using Sendinblue (software to send mass email), I would like to share to my users (the one who filled my first form) a second more complete form on their needs, and also for them to upload files. How could I link the answer to my second form to my first database ? Without asking again for basic information such as email. Thanks a lot for your help ! I am a French student, so feel free to ask questions if you didn’t understand

Hi everyone - I’m new to Airtable and loving it but somehow can’t figure out the following: I want to make a simple staff schedule (max 10 employees in various roles) that ideally would show each shift in a colour with the name of the employee in it. We have several fixed shifts (daily day and night) and a few more irregular ones (ie cleaning staff with various start and end times). I then want staff members to be able to iCal their part of the calendar into whatever app they use themselves, and use data to calculate staff payouts and such later on. I know it’s a block in my own brain but can’t figure out how to structure this one, a little tip would be appreciated. Thanks in advance! D

Unless I’m mistaking, if you create a rollup/lookup field and thus get the name of the original field (if you don’t specify your own field name), that name isn’t updated when you change the field name of the original field your rollup/lookup field refers to. I would find it useful to see the rollup/lookup field update it’s field name in such cases.

I am sharing a view-only link to a base with others but the views they see are including views I have set as personal to me. I expected it would only share views set for “Collaboration” Is this expected behavior? Any way to hide those views from read-only people?