Other Questions

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

Hi there, I am a complete novice. I have a billing table with several procedure code fields, all of which are linked to a procedure code table from which they can be selected. I would like to build a macro where a type of surgical procedure (a surgical procedure may have one or more procedure codes) can be selected from a field in the billing table. the selection field contains the name of a surgical procedure and is linked with a templates table which contains the procedure name as the primary key with it’s corresponding procedure codes (the procedure code fields also are linked to the procedure code table. The aim is to improve billing ease and coding consistency. I really hope that there is a solution to this (knowing me, it is probably embarrassingly straightforward) - if there is code involved, I would be grateful if someone could write me an example. Thanks much, Nick

How do I send emails to a group of records within my Airtable base?

Hi everyone, I would like to know if there is a way to search in all the fields of a linked tab when you are in the other tab. Right now, all I can do is search inside the primary field, which is not very convenient. For example : I want to add a client in my tab. He is of course in the other linked tab. I don’t remember the name of his company but I remember his family name. In the same time, I also want to add a client, whose name I don’t remember, with his company name. To add them both, I should have write the company name and the family name in the primary field in the first place (although it is already written is the next fields), for each client. That seems odd regarding all the things you can do with Airtable. I must add that I’m using the free version right now (not for long though), so maybe it’s because of that? Thanks in advance for any help provided.

I’m trying to copy/paste data from a Google Sheet into airtable (import as a csv may work but for my use case I’d rather just quickly copy/paste, rather than going through the download/upload process). My problem: When I set the field as percentage or number type, the pasted values change from negative to positive. What I’ve tried: I’ve ensured that the “allow negative numbers” is toggled on (and have even tried it toggled off) but no luck. When I set the field as single line text, the number formats correctly but then I can’t use it as a “number” in subsequent formulas since it’s formatted as text. Anyone have a similar problem or able to help?

Good morning I am creating a base of control of parking lots, I have created the tables that allow me to make reservations. I want to create a table with a calendar where, in each day, can be reflected the lots that are reserved, for example: I have a reservation of lot 01, which is reserved from 01/03/2022 to 4/03/2022, I want that in the calendar I could see reflected in the days 01, 02, 03 and 04 than the lot 01 is occupied. Is this possible? thanks for the help