Other Questions

Is there a way to set up a lookup field without duplicates? I asked this here and I just noticed that the response didn’t fully solve the issue: The rollup formula ARRAYUNIQUE(values) still includes duplicates.

Hi, Is there any way to include more text in a gallery view. There should be another bullet point after Moving forward and the text is also cut off after denying/avoiding/struggling Seems like an important feature!

An api on my site where I’m using Airtable as a CMS can’t get metadata for field. Current API can get value up to 7 for each record through table on my site due to that reason. can any suggest a solution?

The dedupe app/extension works wonderfully for me, except whenever I select a field of type “checkbox” i.e. a Boolean, in the record to be deleted, then the merging still happens but there is an error message and the base has to re-load for about 30 seconds. This gets annoying if there’s a handful of records or multiple Boolean fields. And means I have to go through manually checking the newly merged record in case anything crashed in the process whilst page was refreshing.

I am using pre-filled forms to collect records from users. The form fields include linked records. I’ve just realized that anyone with the URL can simply remove the parameters at the end of the URL link to view the base form URL and as a result, will be able to see all of the linked records in those fields. For example, we have a link for a vendor to add a bid. It is pre-filled with that vendor’s information from a linked field. If the vendor is smart, they can remove the parameters from the URL to see the base form and then view all of the vendors in our table from that field. How can we collect data from users with pre-filled parameters in a way that they cannot access the base form?

I wanted to log an interface at a certain point in time (such as a certain day of the year every year) and collect the data. Ideally, I can create a report/log every few months and keep track of the data and manipulate it to see how it’s changing. Is that possible for Airtable? Thank you!

I have a view that contains all the records for a set of people. Some new information applies only to a subset of those people so I created a view that filters on the criteria for this subset. Is it best practice to add the new information in the original view or should I add new columns to the filtered view? I’m trying to ensure that my data stays clean as I build the table and add records. Thanks.

We use a LOT of different grid views. I am finding that when I need to duplicate a collaborative view (so then I can slightly tweak it for a different saved view) it defaults to making the duplicate a “personal” view. I want it to remain collaborative, or at least be able to move it from personal to collaborative, but it does not seem to allow me to do that. It’s a pretty frustrating issue. Any pointers? Thank you!

I have a pro plan (50k records per base). I’m trying to do CSV import of approximately 2k records onto a base of 24k records for an approximate total of 26k records on this base. What other reasons could I be getting this error? See screenshot.

Hi! I am trying to create a simple If formula that shows how much my clients owe me. So if the amount billed is equal to the amount paid, show £0 else show the balance. My issue is, I am trying to append the £ sign before the balance calculation but it doesn’t work. IF({Amount Billed}={Amount Paid}, “£0”, ‘£’ & {Amount Billed}-{Amount Paid}) It only works if I place the £ after the balance. IF({Amount Billed}={Amount Paid}, “£0”,{Amount Billed}-{Amount Paid}&’ £’) Any help on how I can accomplish this?

I want to create a Single Select field with a list of all countries so that users can fill it out in a form. What’s the easiest what to do this without having to add every single country individually? Thanks!

I’m pretty sure this is a easy fix but I keep going around in circles… I need to create recurrent task with about 3-4 subtask for multiple records… Record: Johnny Task: Offer letter Subtask: () send offer () send background () get references I’ve figured out how to link the sub task to task in the “Task” table, however when I link it to the “onboarding” table… and check off a subtask … the checkmark populates for all of the records… so now Joan, Johnny, and Mike have sent offers when that’s not the case. Please, what am I doing wrong?

I have a survey form asking participants of their confidence scores that feeds into a table. Here’s 3 sample questions, all 1-5 score: confidence with financials confidence with communication confidence with strategy These go into columns B-D. I’d like to then have a way to display, for a single respondent (record), a sorted list view of these 3 columns to show highest to lowest rank. E.g. someone responds 2, 4, 3 respectively. I’d like to create a table (preferably in Interfaces) that shows: Communication (4) Strategy (3) Financials (2) Is this possible?

Running into a problem creating an order tracking form. I have 4 tables Customer Info - name, address, etc… Product List - products and prices Orders - each row has customer name and product and product quantity purchased. Primary field is a formula concatenating Customer name and product they purchased Now I’m creating a 4th table Order summary by customer. Primary field is an Autonumber. Second column is a linked record to Customer Name pulled from the Customer Info table. What I want to do is group by customer, everything they ordered and the total they owe. Where I am running intotrouble is I can’t pull the Quantity field from the Orders table using a Lookup; I don’t know why. Please help! Thank you

Hello Friends! I’m not sure how to do this but perhaps there is someone out there that can help me. With all my records we use 1 image to quickly identify the type of record. For example,: We have a tab with all our webinars. We use two images to identify which is which (CRO or PV). To do this with each new record, it’s annoying to upload the same image repeatedly. I like the idea of using the BUTTON feature to attach an image, but the issue is that it will only add images from Pexels. I’m looking to upload images from within my base with a table dedicated to images acting as a portal. Does this make sense to anybody? Any idea how this can be done?

Hello everyone, I’ve had a look on the forums and haven’t found a mention of this, but is it possible to have air table automatically rename attachments. For example. If I have a record named Ross and there are four images attached for those images to be named renamed ROSS-1.jpg, ROSS-2.jpg, ROSS-3.jpg, ROSS-4.pg? Thanks so much!

Hello Everyone, We have the requirement as explained below. I would like to understand how it can be achieved in airtable? The steps are as follow. There will be a form-1 where in user enters “company name”. Click on “Generate Data” button. This button will call the script to invoke external API.And whatever response we get from API,those responses will used to buld the airtable form-2 link with pre-fill option. After that, flow will be redirect edto this pre-filled form-2 link automatically. The challenges in above approach is as flollow: For step-2, when end user will click on generate data button This action will call some custom script to fetch response from external API. So, my doubt is how to build form-2 link using pre-fill option with the values got from custom script/external API on the fly. Apart from this, Let’s say we are on form-1 and clicked on generate data

Hi community, I have a question about using Airtable to manage the creative team workload over time. My goal is to build an Airtable template and ask the team members to write down the number of hours they spent on every task on a daily or weekly basis. And keep these records in the Airtable. This could help us to keep track of the busy weeks and days that are less packed. E.g., my producer can put down 2 hours today working on a video shoot task for planning, and 8 hours tomorrow on this video task again for onsite shooting, then 5 hours the day after tomorrow for this video shoot task for post-editing. As you can see, I need a series of fields, that are connected with consecutive dates, and to be filled with numbers, which are the working hours. I can then calculate the total hours they spent on a task easily with a formula. But I’m having difficulty building this template. Does anyone know how to achieve that with the Airtable? I’m open

Hello Everyone, I am really one man person try to build a system for the institution… I try a few things but seems not really work, so I am thinking can one grid view, just show one specific selective group? Hope anyone can kindly give me some inspiration about it! Thank you again.

Hi, I’m so sorry to be repeating what other people have already asked, I have tried a few of the solutions previously suggested, but I am such a novice, I’m obviously doing something wrong. I’m hoping that if I give my specific examples someone really clever and very patient can give me a step by step idiots guide please. This is the simplified version: Table A = purchase orders to buy various types of material Table B = batches of material booked into stock (from the purchase orders) Table C = customer orders to sell the material These tables are linked so that every time a purchase order is completed (Table A) the material gets booked into stock (Table B) and the quantities increased accordingly, then every time a customer order is completed (Table C) it deducts the corresponding quantity from stock - so far so good. In Table C there is a link to Table B check the stock levels and I want to also at this stage be able to see at a glance the price of th

I’m wondering if there is a way to setup a view similar to the Dedupte extension, where you can see duplicate entries that compare 2 columns of information. I like Dedupte but I want to use the automations feature to send myself an email when a duplicate entry is created.

I have a team of creatives that are scheduled on a shared calendar and all tasks are color coded to signify who is assigned to them for our coordinator to manage individual capacity. Many of my team members have been given the same color for their profile. I would like to change the users colors but can’t seem to find a way to modify that detail. Any help would be appreciated!

I have a base that includes tables synced to three other bases. I would love to be able to provide a visual representation of the base schema INCLUDING where the syncs come from. I want to be able to do this to show my colleagues what the entire flow of information looks like, making it clear that they will need to enter certain records in the source(synced) base rather than into the base where the output from the sync is.

Thank you in advance! I’m new to Airtable and have watched several tutorials and still I’m stumped. Here is the situation I have is a base with 8 Tables. Table 1 is the master list of products I sell. This table has fields with my product name, and number, etc. The other 7 tables are vendors where I can buy the products. Each vendor has a different name and price for the product. The first 5 fields on every table is the name of my product. The goal is to be able to move from Vendor A to Vendor B and so on and see my name and color of item and compare it to the Vendors product name. What I want to do is have the first 5 fields on table 1 linked to the other 7 tables. The goal is when I discontinue an item on my product list (table 1) and change the status to discontinued then the status changes on all the other vendor tables. Or if a vendor discontinues a product, I can change the status on the vendors table, and it will change on all other tables. I hope this makes

Per the attachment changes after Nov 8 - Any attachment URLs obtained via the public API and the CSV export functionality will expire after a few hours. If I am using Airtable as a CMS for my own site where the data (and attachment column) is being fetched via API, what url will the API return 2 hours after the attachment as been uploaded? For example let’s say the original url of the attachment is airtable.com/image-first-location.jpg, I understand after 2 hours it will return 404 not found. However if I make a second API call after 2 hours, would the url returned for the attachment field be a new “working” url such as airtable.com/image-second-location.jpg or would it still return