Other Questions

Hello, We are using Typeform to collect responses, which eventually end up in Airtable. Responses come with image links, due to limited storage in typeform we want those images stored in some cloud server e.g. Amazon/Google and once stored in cloud we want Airtable record to update the links to cloud stored links. What solution would you suggest for this? Typeform links look like this:https://api.typeform.com/responses/files/9f880b3c05bfc8db096c4cf291a5f15feb37efd0a99378ce1eb00d6299ca7da8/IMG_8486.JPG We want to upload it to cloud and update Airtable record with the cloud path.

Hello people, hope you can help me to solve my problem. I’m currently using a formula to substitute some character for cleaning my cell : SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Telephone,".","")," “,”"),"-",""),"(",""),")","") and after this step , i’m using an other formula : IF(LEFT(Telephone,1)!=“0”,CONCATENATE(“0”,Telephone),Telephone) it works perfectly but the question is : how can i do the same thing in one formula ? For exemple : (06-07-45)43.56 26 i want 060745435626 (6-07-45)43.56 26 i want 060745435626 Sorry for my english, i’m french :grinning_face_with_smiling_eyes: and thank you for your answers.

Is it possible to export the data operated by airtable with CSV etc.? Is it possible to migrate to an external database immediately?

Hey, is there a way to sort the columns of a grid view by name? Best, Andreas

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!

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

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!

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?

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?

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.

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?

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.

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!

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

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?

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!

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

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

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?

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!

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 }); } } }

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?

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 ?

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!

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