Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
S
Scott_HedgesNew Participant
posted in Other Questions
Permissions for Collaborators

I have an automation that sends an employee a View. I’d like to give that employee permission to edit a single column in the view. How do I go about making that happen? What if I want them to be able to edit multiple columns in the View? Thanks for your help!

11
ScottWorld
I
itoldusoandsoInspiring
posted in Other Questions
N8n automation for batch download images attachments

n8n is taking nicely off the ground. It has few integrations yet but it has potential. Nice I found recently it allows me to download images in batch. I know I can do that with Integromat but n8n running on local machine seems a bit more handy once it is setup. It’s a chrome app but still good as it can get because it is free and doesn’t cost a penny when running on the local workstation or my own server. Anybody managed a better way to download multiple images at once with n8n? I described the workflow and a few issues along the way but their community is much smaller so no response there yet. Interestingly they run same community board software as Airtable. n8n – 5 Jul 21 How to download multiple attachments with Airtable node? I am trying to use the Airtable node’s List operation to get a record and download the attachments. I’m able to download a single attachment, but when I specify a second one, it doesn’t get fetched. The tool tip recommends “N

800
I
D
David_GerrardNew Participant
posted in Other Questions
Creating a dynamic table for presentation

Hi all! Really liking airtable so far. What I’d like to create is an easy Presentation from one of my Views. Basically what I want would be, from a table like this: To create a view like this: That way I could just copy it straight into the presentation. I’ve created already in Google Sheets & it works dynamically, but I’d rather use Airtable. Is this possible? If so, would love to be pointed in the right direction as I’m a bit overwhelmed with all the apps. Thank you!

91
ScottWorld
D
David_YocomNew Participant
posted in Other Questions
Individual profile view for gym members

I use Airtable to manage workout programming and membership for my fitness class. I would love to be able to give users access to their individual profile so that they can view their attendance, workouts, people they have worked out with, and individual stats. I want them to be able to log in to air table to enter their data and stats for their performance in workouts. Does anyone have an idea for how to do this?

101
ScottWorld
I
Ian_james_DuncaNew Participant
posted in Other Questions
Activity colunm

Hello everyone. Does anyone know if there is a way to bring the most recent activity from the recent activity column inside a record and display it in a cell in a table?

62
I
L
Lisa_LimerickNew Participant
asked in Other Questions
I need help with a formula to change the status based on number of days before expiration

I am trying to create a formula that will change a column to say Active or Inactive based on the numbers of days before an item expires. For example: I have contracts that expire over the next four years. When one of the contracts gets within 6 months of expiring I need a column to change to Active or Inactive. All of the Actives will be within 6 months of expiring Inactives will be anything valid for more then 6 months. I tried to use this formula I found in the forums and changed my expiration date column to Purchase Date just so the columns would match and it keeps telling me that it is an invalid formula. IF(DATETIME_DIFF(TODAY(), {Purchase Date}, ‘days’) < 365, ‘Inactive’, ‘Active’). Thanks for any help you can provide.

140
L
G
Graham_ThomasNew Participant
posted in Other Questions
Autonumber not sequential if records deleted

Hello, I’m having issues with Autonumber. I have a simple sequential ID being created as an autonumber, starting with 1, through 2, 3, 4, etc. When a new record is created it automatically assigns a ‘number’ to it. So next in this sequence would be 5. However, for example if we now delete record five, and a new record is created after this, instead of numbering it ‘5’ based on the sequence, it starts at 6. This is a real problem because a bunch of records were created to demonstrate to a colleague, and were then deleted. So now the numbering is starting at much higher than the next in the sequence. Any reason why this is doing this and is there any way to ensure it’ll just create a new number based on the previous record number?

664
A
Y
Yellow_ElephantNew Participant
posted in Other Questions
Preselected HIDDEN fields in Embedded Forms

Hello, So I need to embedded several forms (to the same Table) on multiple pages on a website. These will capture roughly the same information. But, I need to know where the enquiry came from. For example, we have individual landing pages on our website for people coming from Google Ads, from Facebook Ads, direct enquires, etc. In Airtable I have a ‘Source’ field (Google, Direct, Facebook, etc) but I need this to be pre-filled BUT hidden on the form itself (so the customer doesn’t see it). This is so as the entries come into Airtable I know where they came from. I don’t want to use a separate Table (which I know would solve this) as I need all records in the same Table. It seems the prefill_ formula only works on visible fields, not hidden fields. Ultimately, Is it possible to differentiate somehow which records came from specific embedded forms on different webpages…? I hope that makes sense.

193
Y
J
Joel_FerrellNew Participant
posted in Other Questions
Formula or Script to append index of order line items

I have a Orders and Line Items tables that are linked together in the typical parent child relationship where an order has many line items. My question is how can I append the line item index (+1) to the order number in the line items table? For example: Order number 20001 has 3 rows of line items in the line items table. I already have a row for each line item in the line items table but I would like a column with 20001-1, 20001-2, 20001-3 ({Order #} + index). Thanks in advance for any help!

20
J
V
Vladimir_LebedeNew Participant
posted in Other Questions
How to apply company to marketplace?

Is there any form that I can fill out for the website to be listed on the marketplace page? or email thanks

01
kuovonne
A
Angela_KimNew Participant
posted in Other Questions
Is there way to keep track of employee's promotion (change in the title) and year?

I’m using employee directory base, and it’s great, but what if an employee gets promoted and his/her title or even department changes? I can manually update the data but is there a way to keep track of that so I can view the history or know when an employee got promoted?

91
J
H
Henry_DalzielNew Participant
posted in Other Questions
Add a "red" ROW color when a form is submitted - possible?

Here’s what I am trying to achieve: When a user submits data on our AirTable form it populates a row (as it is meant to). I’d like it so that when a user submits data the row has the sidebar change color to, say, “red” - this way I can quickly visualize the new data that has come into the AirTable Table Thanks!

32
kuovonne
A
Alex333New Participant
posted in Other Questions
Dragging pics from Photos App (mac) to Airtable

I’ve always dragged photos from photos app directly to airtable Attachments field. Now, only some of the time it seems to work, and the rest it doesnt acknowledge my hovering cursor… and I instead have to drag them from Photos app to desktop, THEN from desktop to Airtable… what am I missing here? why is it only sometimes and not all the time

20
A
M
M_kInspiring
posted in Other Questions
Is The Dedupe App Available

Hi Airtable! I am on the Creator Plan, and tried using the dedupe app, but it won’t open up. I was able to use it before, though. How can I use this app on the Creator Plan? Mary

62
M
G
Grace822New Participant
asked in Other Questions
How to choose or extract value from a list of values?

Hi, I have been trying for days and looked through previous posts but haven’t been able to find an answer. I created a linked table that shows how many engagements (essentially projects) per client account. NOTE: all of these records are completely made up and using as examples! Client accounts may have both active and inactive engagements, because there might be more than one engagement (project) assigned to an account. But my objective here is to show the account’s status as ‘Active’ if there is at least one active engagement. I got to this point, but how can I default to ‘Active’ if the field contains both active and inactive?

540
ScottWorld
A
Ademola_OyejideNew Participant
posted in Other Questions
Involves airtable formula and scripting

Hello everyone, I’m setting up a database to access people’s task. I’ll state a task and assign a score to it, 1-5 to show how important it is, then check 3 fields. If the fields are checked, the value should equal the value score value selected earlier and if not, zero. Then the total vaue sholud be calculated only if the completed column is checked that the task is completed. So there are four checked to be checked. Let’s say i select a score of 4, and i check all three fields and then the complete field, the total score should be calcuated as 16, but if 2 fields and completed, I score 12 but if completed not checked at all, the total shouldn’t be calculated at all. I don’t know how to setup the formula for this or better still a script that can run this. Pls help out!

31
Alexey_Gusev
C
contact11New Participant
posted in Other Questions
Adding a condition in vlookup script

Hello the community, I would like to add a return value condition in the vlookup script depending on another column containing a specific text. your support is really appreciate. Thank you Here my current script that I would like to improve: let mainTable = base.getTable(“Inscriptions”); let mainTableRecords = await mainTable.selectRecordsAsync(); let lookupTable = base.getTable(“Ateliers”); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue(“Promo”); for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("Promo") === lookupValue) { if (“new column”) is containing this specific text "A1" let returnValue = rangeRecord.getCellValue(“Date”); await mainTable.updateRecordAsync(record, { "Atelier 3": returnValue }); } } }

85
Alexey_Gusev
A
Andre_ZijlstraInspiring
posted in Other Questions
Linking to online images + showing the picture

I tried to find earlier postings, and I think I did find one, but oddly enough, nobody responded. So, let’s try again. Instead of attaching images to records I would like to add the link to online photo’s. I know I can add a link to a photo (URL), but it won’t show the picture, just the URL! Is this possible in Airtable?

127
D
A
anjaneshNew Participant
asked in Other Questions
Card view embed shows only 4 our of 5 fields

I have an airtable table with 5 fields. But when I embed, it doesn’t show the last field in the card view. Only after clicking on the card item does the entire details show on popup. Is there a way to show all the fields in card view ?

90
ScottWorld
J
Joe_EdNew Participant
asked in Other Questions
Conditional field populating

Hello everyone. Sorry if this isn’t in the proper category or if the question seems newbie. I’m kind of new to Airtable and was wondering if there’s a way to automatically populate a field across a whole table based on a condition within a field in that table and/or in another table entirely. To simplify, I have a table with the following columns: Website Name, URL, and Categories. What I want to achieve is create a 4th column based on values within the Categories field. For example, if Categories field has “Laptops”, the 4th column would automatically populate with a text like “Source1, Source2”, etc. Is there a way to do this across the whole table and at the same time be able to edit the “Source” text to add more websites? Photo for clarification: Is it possible to make it so that Sample Website 2 through 4 also have Source1, Source2 in their Sources column? Sorry if this is confusing. Thank you so much!

620
J
L
Lifebook_AdminNew Participant
posted in Other Questions
Merging lists and connecting the information in a new field but to the right row

Hey all, I really hope you can help me with this - I imagine it to be simple but I just cant find an answer for this! I want to move my spreadsheets to airtable. In one, my main table, I have a list of students with their names (here ABCD), etc. In a second table I have more information about these students, but the name list is in a random order Now I would like to import the second table and have the data matched to the first one, so that the right data from table 2 are listed in a new field, but connected to the right student A, B, … What would be the best way to do this? Thank you so much for your help! Best, Alina

93
Hannah_Wiginton
K
Kim1New Participant
posted in Other Questions
Lookup then auto popular the Link to field?

Hi, I need help. In a base, I have two sheets, the report and vendors. In the vendors sheet I made a lookup field column and created the lookup column. In the configuration, I linked the report and the report vendor category column. I can go to vendor category column and click the plus mark to add a record. The report had 1000+ rows. I don’t want to add these in manual 1000+ times. How do I get the vendor category column to auto popular with all the matching records? What am I doing wrong? Thank you Kim

00
K
G
GregoolParticipating Frequently
posted in Other Questions
Creating Dates: Where is the formula counting an additional hour?

Hi guys, As you can see I work with a formula. And I don’t get my(?) fault, why this formula in recordline no. 8 isn’t working as well as in the other lines … Anyone an idea? :thinking: Thank you in advance and best regards Martin

108
kuovonne
J
John_DiamondNew Participant
posted in Other Questions
How To Remove The Airtable Logo For Our Clients?

I have a few clients I would like to pitch our management services to and be able to provide Grid views and such. However, without white-labeling this is a big issue for us. How do we remove the footer “Airtable logo” and also on the login window that pops up when password protecting a shared view???

9010
K
L
LSTFRNew Participant
posted in Other Questions
Saving a Shared Base for myself

I recently was listed as a collaborator for a short term project. How do I go about saving an empty version of the base design before the collaboration ends? Thank you

232
L

Badge winners

Show all badges
Terms & Conditions