Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
M
Michael1Known Participant
posted in Other Questions
Modifying date part using concatanate formula

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?

12
Ben_Young1
C
Chadd_DumagasParticipating Frequently
posted in Other Questions
How to get unique 2-dimentional array?

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

00
C
C
Caroline_KovachNew Participant
posted in Other Questions
How do i remove users that no longer want access? Not easy to figure out. :(

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?

4641
kuovonne
A
Agenda_CapitaliNew Participant
posted in Other Questions
Updating a column from the original base

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.

00
A
D
David_BroachNew Participant
posted in Other Questions
Many to one like access Subform

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.

534
D
D
Don_TranNew Participant
posted in Other Questions
Sequentially-named fields used for inputing measurements. How to display last measurements in the order as table is being populated?

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.

00
D
B
Brandon_HatcherNew Participant
posted in Other Questions
Is there something better than Airtable's Gantt charts that works with airtable api?

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

10
B
L
Lost-MerovingiaInspiring
posted in Other Questions
Embarrassingly silly question (tax Formula from total)

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.

11
A
R
RP1New Participant
posted in Other Questions
"Grouped By" Title text cut when printing a Grid View

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.

43
A
L
Luke_McFadden1New Participant
posted in Other Questions
How do we modify an existing sync to add in new fields to the destination table?

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?

241
V
A
augmentedInspiring
posted in Other Questions
Sync source table changes?

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!

52
A
_
_eo_HeckNew Participant
asked in Other Questions
Monospaced font on Tables (Grid view)

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.

310
_
C
Charles_DoranteNew Participant
posted in Other Questions
Comparing records in different fields in the same table - PLEASE HELP

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

22
C
C
Clay_NorrisNew Participant
posted in Other Questions
Ability to build public calculator on top of my base

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?

161
A
M
Mike_BuckParticipating Frequently
posted in Other Questions
Sync bases - changing the primary field

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

1981
A
H
Hairtable11Known Participant
asked in Other Questions
Create a profile image (as seen in MS Teams) using initials from {firstname} {lastname}

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.

4460
Justin_Barrett
E
Erin_AlterInspiring
posted in Other Questions
Restored snapshot isn't including old links to forms

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!

10
E
J
Jeff_ClaytonNew Participant
posted in Other Questions
Managing Product SKUs and Details

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

635
A
A
Arnau_RosNew Participant
posted in Other Questions
Count how many times two reference fields are used?

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:

10
A
O
Onference_TrainNew Participant
posted in Other Questions
Mobile optimized View for airtable view

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

274
O
E
EdgarNew Participant
posted in Other Questions
Error "Upgrade to add more sync sources"

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

56
E
N
Nick_MartinNew Participant
posted in Other Questions
How do I change values of several fields (all linked to one table) with values from another table

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

127
N
A
Airtable_AdminiNew Participant
posted in Other Questions
Email group of Records

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

112
kuovonne
P
Pierre_SuchaudNew Participant
posted in Other Questions
How to search in all fields through a linked tab

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.

34
P
Brandi_Bullock
Brandi_BullockInspiring
asked in Other Questions
Negative Numbers (Percentage) Not Pasting Correctly

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?

344
Brandi_Bullock

Badge winners

Show all badges
Terms & Conditions