Other Questions

Here is the use case: I have barcodes that are scanned to match data from Sheet 1 (Bins) to Sheet 2 (Pickups). Barcodes are in rotation, but only one barcode is scanned at each Pickup and Bin on the same day - giving us ability to match the data from each location. I have created a formula to create “Barcode - Date” in both sheets, then copy/pasted them as I read on this forum that you cannot link formulas. Issue is: When I go to link them and pull data from Sheet 1 to Sheet 2 it cannot find the data I am looking for (a dropdown of “customers” from “pickups”). Instead, Airtable seems to copy/paste my entire table, add it to the top couple thousand rows with no data pulled except for the Row ID (a long string used as a unique identifier) and matches that to the customer. So all other columns are empty, it is matching it to the wrong column from Sheet 2, AND in the table I have in the bottom couple thousand rows, it cannot lookup the data I want. Is this a bug?? Am I doing this wrong? Th

My Volunteer Application is filled out by people interested in volunteering. After attending an Orientation, they decide if they want to volunteer, not all people volunteer. For those who do volunteer, I need information from the volunteer application for two separate Google spreadsheets. Can airtable perform these functions so I don’t have to type in the information for the two spreadsheets? thanks

Hello everyone I’m trying to delete a file that I’ve uploaded. I realized that after a record delete, the attachment still existis in dll.airtable. How can I delete definitively any attachment from Airtable? Can I use the API for it?

Hi, I want to achieve the following, wonder if it’s possible with airtable I have an ongoing table of data, which I’m updating daily, I want to share this data with other users so they can add their own data into it but also get the updates I add daily into their table, in another word, there is a table AA, which updates daily, there are some user tables, which are based on the table AA, Users need to be able to add data into their own table but there is a need to import all the updates from table AA into the user’s table. does this sound doable in Airtable?

Hello! I’m new to airtable and formulas, and I’d love to figure out an automatic way to check if things are ideal as they or, or if I need to work on them… I have two fields: “Whose Job Now?” and “Whose Ideal Job?” that contain the same multi-select options. How could I use a formula to compare the two columns and check a box in another column called “Ideal?” when they match? Thanks so much for your help! -Allie

Hey I’m using zapier to link my typeform to an airtable, which is all working fine apart from the multi-select type form (choose 1-3 options). It is not linking to airtable’s multi-select field type correctly. Attached is what I’m getting - all inputs are in one entry instead of separate. I’ve even manually added all of the input options in the field on airtable. The workaround would be to use 3 separate single entry questions in typeform but this is not very user friendly and would mean separate fields which also doesn’t help when comparing data. Please help! interested if anyone has managed to do this or have i reached airtable’s limits? How it is How it should look

If you are saving a URL, what is the advantage of using field type URL vs single line text? Is there any difference? I can’t see a difference, but there probably is one! PS I love you all!

Hello guys, Im have a simple question about timeline view, I want to creat a timeline view with hours insted of days is that possible?

Organize everything with view sections Once you start building out an Airtable base, the number of views (like the new Gantt view ) can quickly multiply. To help better organize all of your views we’ve created view sections to enable base creators to organize views into collapsible sections. This provides a new way to manage your views - especially for bases that take advantage of all the different view types, including collaborative, personal, and locked views. Utilizing view sections will allow you to easily find and take action on your views while keeping your view experience organized. Learn more about view sections in this support article Hi, All “Organize everything with view sections” Tools disappeared from my UI ! On each and every Base, even after hard resetting my computer ! Am I the only one to know this issue, both in Firefox, Chrome and on two different MAC OS & Devices ? Thx, olπ

Hi there! I noticed a problem on a multiselect field. The problem is on the Android version app. I click on a multiselect field and select some values from the available choices. My choices are normally noted as selected. When i go back or revisit this record, these values appear as selected but when i click on the field to add some values or change what i have selected, no value is selected. If i try to select again some values for this field, i get the following error message “Sorry, your request conflicted with another change” Have you noticed this problem? Thank you

Hello, I have a table where all records have the created time field. I would like to add a view with only one record, the latest record created. It needs to update every time a new record is created being always up-to-date. Is it possible? Thanks

Hello, I’d like to count repetitive information only 1 unit and not all time it appears. For example in this image attached. I have 2 REIs and not 16.

Hello, I’m having a bit of trouble with the final piece of a project. In Table A I have a list of clients with their service rates for on-going deliveries. In Table B I have a set of fields used to capture specific components of the delivery and this acts as a database for all deliveries performed. I have set a linked record in Table B which links back to the client in Table A and have also set up a form for our drivers to capture the delivery within Table B. Now to keep things simple (as 90% of the time deliveries are the same each week but some do change), I made a calculated field in Table A which says is delivery today = “Yes” or “No” in Table A and created view which filters is delivery today = yes. This means our drivers know which clients to deliver to on a specific day. Now the problem is, I have the URL for the form from Table B in Table A showing to the driver and each time they perform a delivery they need to choose which client. Is there a way I can pre-populate the from fr

New to Airtable! I’m using several different forms to add contacts to a CRM (each with a new name) - is there any way to use a formula or automate a column or something similar that will note which form the person filled out?

Hey there! We’re trying to make our team check and update their own info already recorded in a table. Everyone will get a unique user and password. Let’s suppose John signed in correctly… the form will check if his user and password does exist and will show some fields like his full name, address,… that are in the table. Now John can update his info if needed. Is there a way to populate the fields based on the table’s records? Thanks in advance.

Date field are single date entries only. Other than manual entry in a long text field or multiple select field (using the actual date), is there a way to enter more than one date in a date field? Also, how can I filter for a range of dates, for example 30/10/2021 to 01/04/2022 tia

Hello! I’m trying to find a way to link 1 table to multiple rows in another table within the same base. For example – The first table in the base lists all of our customers (one per row). Another table in the base includes all of the action items that should be done for each customer (they are all the same). Is there a way to link the action items table to each customer, and further, allow for items to be checked off as they are done for each individual customer, without impacting those of another customer? Thanks in advance!

Hello is it possible to import data from an HTML web page into Airtable for example, i would like to retrieve the data “priceValue” in coinmarketcap.com/currencies/solana i’m trying with DataFetcher but it seems not to work properly. Is there another way to achieve ? thanks for your answer

Within a base, I have 2 tables that I would like to merge into one, is this possible, or do I have to re-create the 65 records from the smaller table into the larger table that I want them to merge with? (Not sure if it makes a difference, but I am currently on the free plan) Thanks

Just discovered the possibility of sharing your bases on Universe. Is it possible to ask users for a payment before making a copy? Or is there another way to allow people to copy your base for a remuneration?

I can’t find how i can delete a single field thru the API. And i rather stay away of the PUT command and feed everything back from a request, minus the one field i want to delete. So… how can i empty a field or blank it with a patch command?

Hiya! I’m trying to calculate employee tenure with DATETIME_DIFF. I’m able to show it by years, months, or days. What I’d ideally like is to break it down to say: 3 years, 2 months. So I have a field for start date and end date (as screenshot suggests). I have the formula applying today() if they are still employed. Just can’t figure out how to get that month figure to be months into the current year. Thought I’d add my current formula. DATETIME_DIFF( IF({End Date}=BLANK(),TODAY(),{End Date}), {Start Date}, 'Years') & " Years, " & DATETIME_DIFF( IF({End Date}=BLANK(),TODAY(),{End Date}), {Start Date}, 'M') & " Months" Thanks!!

I need to calculate my clothes cost. how to design a table that have to sync fabric price, material price, working hour cost to a costing sheet.

Hi all, I have a requirement for a form to allow a user to input (draw) via touch/pen. This doesn’t have to be a legally binding e-signature so I’m hoping to avoid complex 3rd party integrations. Is there a canvas widget/app that allows a field to capture touch drawing as an image/svg etc? Microsoft Power Apps has a built in “pen input” control - I’m hoping there’s something similar. Thanks in advance! Sub