Other Questions

I have a form wit a look up files, so I open the form to add a new donation from a client, I find the client but what I want to do is when I look for the client I want to see their information (address, phone number etc) can you guys direct me to the correct pad pls

I have a table of species, 1 per row. I have another table (.csv to import) where species are linked to habitats. Each row is a unique habitat, and several rows may be linked to the same species. I want to pull the habitat types into the original species table, where one field captures the many habitat types linked to the species. using linked fields and rollup or lookup I can not get it to show me all the values of habitat that may be associated with a species. It just shows me the first one it comes across. I chose linked to many when I linked it. I searched the archives but couldn’t find the answer to this question (though I’m sure it’s here somewhere) - apologies - I link to the answer would be very welcome rather than rewriting it. Elizabeth

I have seen several posts about this, but they are older. I need to be able to limit the views at various levels for my employees. Per Airtable, you are supposed to have most data grouped together, and use views to filter it. But then there is no way to hide sensitive information from employees which makes all data available to all people. Crazy! All I am trying to do is track projects, but I don’t want my entire company to have access to the financial info associated with each project. Basic basic stuff. I am hoping this has been resolved as it is a pretty basic function. Competitors seem to have it figured out. Airtable, if this is not available, when can we expect this basic function?

Hi! I have a membership community and I am using the Gallery view of AT to share my ‘roster’ of members. I am able to share the whole “gallery view”. What I want to do now is to only share a single record in Gallery view to my members. This concern was discussed in the AT Community last 2019. Then, this feature was not present in AT and a third party offered their product to offer this specific service ie miniExtensions Is there an update to this from Airtable developers? Is there a new solution for this concern?

When I’m using concatenate formula for a unique ID, I’m using it like this CONCATENATE(Task1," - ",{date}). And it ends up being weird-looking, and when I say weird looking I mean only date part is weird. This is what I get “Task 1-2022-02-10T[00:00:00:000Z”. How can I remove those zeroes?

So i was able to successfully test this Airscript – 18 May 20 Unique values Getting the unique values for a field in Airtable It basically gets the unique list from one field, but what if you need 3 fields and you have to get the unique set of records from that list. From 1 A 0 1 A 0 1 B 1 1 B 1 2 C 0 2 C 0 Into 1 A 0 1 B 1 2 C 0

How do i remove users that no longer want access? Not easy to figure out. :frowning: Where do I have to go to manage access of those no longer needed on the table?

Hi, I’m trying to update a record from an original base, rather than the synced one, from the synced spreadsheet. How would you do this? My best try has been to update the original record via Zapier, with the trigger being an unsynced column on the synced table, and looking up the identifier on the original table with the proper identifier. The problem of my solution is that Zapier doesn’t recognize unsynced columns on synced tables for the automation, so I’m stuck with either: Doing something so Zapier recognizes the unsyced columns Finding a different solution altogether What do you think? Thanks in advance **With unsynced columns, I mean the new columns you add on a synced table.

I am not a database person but have built several simple access databases where I used subforms to create a one-to-many relationship. For example, a project tracking, but unlike all of the airtable examples I see, I want to have say a project name and short description in one table and then in the other table a date and a long text field with the particular update for the project. So I could then view each project and all of the updates to it by date. With access this was easily accomplished with a subform linking back to the main table in a many to one relationship. Is there a way to do this in Airtable? I looked briefly at a junction table but did not quite follow, is this how to accomplish what I am after? Thank you.

At work, I’m clicking a button on a gauge and it inputs the measurements into fields from left-to-right, F01, F02, F03, … F50. The gauge connectivity can be bad and measurements are missed, making me have to start over. I usually load Window’s magnifier to see measurements from afar. I was thinking of making an Apps page with F01–F50 stacked (and figure out transparency and stuff) so as I measure, the newest measurement appears over the previous one. Seems like a bad method.

HI, I’m working with Airtables gantt charts but find them a little limiting compared to things I have used in the past. At my company we have events, things that happen over the weekend, and more holidays than most. I would like to be able to block out the entire time an Event is happening because most people can’t work on anything else. I would also like to keep weekends visible because we have tasks that happen over the weekends. Additionally, I would like to see company holidays on the calendar because most people don’t work during those. I know I can hide weekends and holidays, but I would prefer to still see them on the calendar but have airtable work around them. In addition to that I would like to be able to collapse the view more so that I can see more of the airtable in one screen rather than having to scroll a lot to see how projects may overlap. I have worked with other time management programs at other companies that allowed all of this to happen and I am finding airtable’s

I have a table of invoices for hotels where sometimes not all the data comes through, so I get the Total, but not the rate of the items, or the tax. I’m going to set up an automation that reserve calculates, but it’s breaking my brain. So I need a formula that does these: {Total} - {tax}= subtotal {subtotal} - {fee} = Hotel Fare [Hotel fare} / {nights} = nightly rate It seems easy, but it’s not working for me. I’m not sure what I’m doing wrong. Airtable Grid view - Airtable Explore the "Grid" view on Airtable.

I’m evaluating Airtable to implement it in the company I work on. When I try to print a Grid that’s grouped by a field, the title text gets cut, unless I make the first column really large, which is not feasible. Is there a way to make the text wrap to a second line in the title? Printing (both to PDF and on paper) is a requirement, so I can’t work around it.

I’m helping someone with an existing Airtable setup, where we need to sync some additional fields. But I’m not seeing where exactly it is that I’d be able to do select additional fields?

For example, if you add a new field to a table/view that is currently sync’d to another base, how do you get that field to become part of the sync? Is that even possible? In this specific case, it’s a lookup field if that matters. I tried to search for the answer to this question, but haven’t had any luck so far. Thanks!

Hey guys, do you know a way to use a monospaced font on Tables (Grid Views)? It makes things clear since the whole text will align.

Hi, I have 3 Fields “Name” “Results” “Position” I will like to compare the values in “Results” Field and position it from ‘1st - last row’ (Field “Position”) If “Field Results” Row 1 or Record 1 is > Row 2, then Row 1 = “1st” else If “Results” Record 2 > Record 3, then Row 2 = “2nd” else if “Results” Record 2 = Record 1, then Row 2 = “1st” What I want the “Position” Field to do is, compare if Results Field Row 1 is Greater than Row 2 then Position Field Row 1 is equal to “1st” And if Results Field Row 2 is equal to Row 1 then Position Row 2 will be “1st” Or if Row 2 > row 3 then Position row 3 = “3rd” Finally if “Results” Row 1 = Row 2 then both "Position Row 1 and Row 2 will be “1st” But “Position” Row 3 will be “3rd” What formula do I use to achieve this? Help me people This is what I want to Achieve

Hey everybody, I run a large online community and use Airtable to host the member directory. I ask for ~10 or so fields so that it is easier for members to find and connect with each other once inside. I want to build a calculator or questionnaire that continually calculates how many members meet different conditions in the fields. The idea is to use this as a growth tool where new website visitors can better understand how many of their peers are in the group before they submit their information to join. Does anybody have any recommendations here?

So I’m trying sync some records from one base (base 1) into another (base 2). Base 1 contains my inventory, base 2 contains my service records FOR that inventory. I can’t have them in the same base due to record limits. My idea is to have two tables in base 2. Table one will be a sync back to my inventory, so as I add or remove units the sync takes care of adding them/removing them for me. Table two in Base 2 will contain my service records themselves, and through a combination of formulas and lookups in Table one, I’ll see the information I’m after within Table one. Primary field in Table two is just an autonumber, so that way the second column can be a linked field back to the inventory in Table one. This is where I’m running into issues. In base 1, I use a concatenated formula for my primary field to pull in location #, year, make, model, etc. as an easily findable and searchable value for a few other processes we have. So when I sync that into base 2, that concatenated value

I’m trying to work this one out but I don’t have sufficient coding experience to really crack it. I’m looking to generate an image into a dedicated field, based on a record’s {firstname} {lastname} fields. Examples of code to do this are here: javascript - How do I set profile image as first letters of first and last name? - Stack Overflow Can these easily be turned into a script? If it isn’t possible to create an image file, generating unique embed codes per record might be just as useful.

i made a mistake and generated a new link to a form. i want to go back to the old link. i tried restoring a snapshot, but the links to the form are new each time, instead of going back to the snapshot of the previous form. is there a way to restore back to the previous version of the form, including the link? or is it gone forever? thanks!

Hi everybody! I could use some advice. I’d like to use Airtable to manage my company’s SKU database, but I’ve run into an issue that I can’t seem to figure out. Hopefully it’s an easy one. I’ve created a SKU base and, within it, the following tables… SKU_Images (with columns for SKU and a checkbox indicating whether an image exists) SKU_Allocations (with columns for SKU and then the number available for each) SKU_Merchandising (with columns for SKU and the stuff like product name, product price, category, subcategory, etc.) Let’s assume those would all be updated regularly by either importing CSVs or just copying and pasting data. All good so far. I’ve also created a table for SKU_Marketing. Whether or not we market an item depends on whether it’s available (referencing SKU_Allocations), whether it has an image (refencing SKU_Images), and whether it matches the categories we’re promoting this week (referencing SKU_Merchandising). So my SKU_Marketing table includes columns for SKU and t

Hi all! I have a table of records that has a few hundred entries. These entries essentially connect two tables, the “Websites” and the “Elements”. In my main table, I connect those two reference fields to each other and have for example: Netflix (website) | video player (element). What I’m looking for is a way to be able to count how many times those two combinations have been used with each other. If you can imagine, I’d have 10 different records of different versions of Netflix + Video player, so I need to be able to have a formula with something similar to {websites} & " - " & {elements}, count up. End result should be something like: Netflix-Video Player-1 Netflix-Video Player-2 Netflix-Video Player-3 etc. Keep in mind, there are many different website names, and many different element types. So each website + element should be able to be counted for individually. Let me know if that makes more or less sense! Thank you :slightly_smiling_face:

Hi, we are an event organizer start up firm based in India, our core work profile is creating event program and updating same on website. With airtable we came across the possibility to embed data(program) to website directly in a reactive way. However, from past few weeks we are constantly struggling to create a mobile optimized website with iframe code generated for airtable view. The problem is that when we try to embed card layout for grid view(which is strict preference) with 5-6 field values, the program on mobile shows only 4 field values and to view other we need to expand record which isn’t user optimized, so requesting the community to kindly help us with some valuale inputs. thanks in advance

Hello, we have a “Pro” plan for our bases. I have a base that has a table with 3 sync sources (all coming from other bases on the same Pro account). I’m planning to have at least 5 more syncs to take place for the same table and when I’m trying to add a fourth one, I get the error below. However, In one of the threads I read that the maximum is 20 per base/table (which I have not nearly reached When I “request”, the notification comes to the owner of the account and there are no next actions, as we already have the “Pro” plan. Upgrade to add more sync sources This table already has 3 sync sources. To add a new source to the table, contact your workspace owner to upgrade your plan