Other Questions

Hello, I am relatively new to Airtable and I am having difficulty creating a simple clustered bar chart in the chart block. In excel my table and chart looks like this… Any suggestions?

Hey! 😄I'm trying to use for the first time Airtable in a Macbook Air with MacOS High Sierra 10.13.6 and it won't work - error pglhNFcYRPMwnZ6Ry will appear constantly.I tried to refresh the caché, the page, use different browsers and use the Incognito mode, but still stuck with the same issue.Any ideas on how to fix it? Thanks in advance!

My friend shared an interface and gave me editor permission, but I don't have edit mode on my page and can't type anything in that interface, what could be wrong?

Hi, I wonder if anyone know detialed rules about what should happen when data is pasted into a table where the data is sorted.I have one table sorted by non-Key field (a-z). I was pasting a set of data from another table to this sorted table every day. All new data have the sorted field value > exisring value, so they appear at the bottom of the table. However, I found out recently that only 1 data was added (because I need to create 1 new record when pasting the data), and the rest of the new data was overwriting the data at the top of the table with the smallest sorted value.I guess that the 1st pasted record has the sorted field = blank for a split second which placed the first pasted record at the top of the table. This would have made the rest of the records to overwrite existing records. However, I didn't receive any warning messages during this process. I was believing that I was adding all of the pasted records to this table for a long time.

I've been unable to find or devise a way of chaining two actions in a row, triggered from a button on an interface.I'd like to automate two actions with a single button:run a script to prepare some data and,take the user to another interface, where those data will be presented to support another activity.Both actions are offered as separate options by the interface editor for a button, but I want to have them consecutively executed with a single keystroke, that is, associated to a single button.Anyone that can provide an idea / suggestion, I'll be happy to know.Thank you.

So we use Airtable to house an inventory system, for both existing and new assets. New assets are written into the system as a new record via a form. Up to this point, we’ve used autonumber to generate a unique easy value for vendors to reference to as a PO. I was under the impression that autonumber values COULD NOT be user changed unless the user was changing the field type to another value and changed it back, etc. We’ve spent about 6 hours today chasing down problems with the autonumber field seemingly renumbering itself, based on how a filter or sort is applied at the time a record is added into the system, or another user is editing a record, etc. Does anyone else have any history or ideas on this issue?

We are using airtable to manage our content with around 10 accounts. Now, our accounts are PRO (Comprehensive collaboration) level with 50000 records per base. We want to upgrade to ENTERPRISE (Maximum business value) with 100.000 records per base. I want to know how the cost will change per user / month. (Currently, we are paying $ 20 / month per user)

Hi all, Is anyone else experiencing quite significant issues with the new Airtable App update? We’re heavily reliant on using the app as a company & the update is throwing up a lot of issues. Couple of issues we’ve encountered so far… Opening a linked record will not present any data, just a blank record. To get around this, we’re having to create a new record and then it will allow you to open the linked record. Frustrating! Linked records are hit and miss with even opening. Having to close the app down and re-open and it will work. Cannot edit records. Again, having to close the app down and re-open to get any joy. We would love the ability to transition back to the old version! I really hope I’m not the only one struggling with this. Cheers

I am trying to sync information that needs to stay intact but it seems that it is being converted to a number somewhere in the process of getting appended to Google sheets. The actual field in AirTable is "Single Line Text" and the corresponding column in Google Sheet was set to "Plain Text". As an example, I have a field with value "030" in AirTable with an automation to create a row with that value. But once it gets sent over, the leading zero is truncated and becomes "30" instead in Google Sheets. I thought about appending some magic symbol such as "030@" and then removing the "@" symbol, but then that creates another issue because you would still need to go into the sheet manually and drag the formula to the newly created row. I checked the automation run log and it seems like "030" is getting sent to Google Sheets, so somewhere in between where it is getting sent to Google Sheets, the leading zero is getting truncated. Is there a way I can configure

Hello, similar to prefill a form with custom information (https://support.airtable.com/docs/prefilling-a-form), is  there a way to prefill a gallery view? Background:customerID is added to gallery linklogged in customer clicks on the gallery link on our websitenow he browses the gallery to see what he wantseach item has a button to trigger an automation/script,were the customerID is neededUsing a form will not help due to the missing images & information added to each gallery item.Maybe somebody has an idea how to solve it?best Dimitrios

Hi- How do you create a table to store your most URLs?  Thanks!!

I use airtable forms to capture customer data, I have the form embedded on my website, but it suddenly stopped working. I get this error whenever I try to use the form. Any help on fixing this would be greatly appreciated. 

Hi I am trying to create a form in Airtable so it fills out the fields and creates an invoice. I thought this would be really simple but I am stuck adding multiple products and multiple quantities. Basically, I have a table called ‘Prices’ this has all the products, product codes, prices, colours and sizes, I then have another table called ‘Invoices’, in this table we have the fields called, product, qty, size and location. From the '‘Invoices’ table, we lookup the product code from ‘Prices’ and display it in the product field, we then add our qty, size and location (This is taken from another table called ‘Location’ and it can be multiple selections). Finally it calculate the cost of the cost of the product, add the cost of the locations and gives me a total figure. So far this appears to work and I don’t see it being an issue creating an invoice as it’s all on 1 row. What I am can’t workout is… How do I add more products with multiple quan

Hi- I am new here to the community.  I am trying to Complete A Contact Master Table.Do I need to create multiple tables, How To Complete the Contact Master table ·Example Notes and attachment below · Use the Contact Master ERD found here: contacts_table_design.pdf - Leave the first field (Name) off; Begin with the Name Prefix field in the Contact Master ERD and add all the other fields.Do not add any of the other (one-to-many) tables: will return to them later. I Am Very stuck in just spreadsheets and tables.Can someone help or show - inform or direct? ? Super Thanks

I have created a bar chart and would like the x-axis labels to appear in the order they are listed in the multiple select field they are being drawn from. Currently, they defaulted to being displayed alphabetically, any tips on how to change the order they appear on the bar chart? Thanks!

Hello! How do i configure a automation in a way that when my action is triggered, the automation adds a user (people) to a already existing and specific cell? Please have a look at my screenshot, thank you so much!!!!Greetz, Bas

Hi there,I would like to calculate the extra hours I've worked each day by implementing a formula field. I've currently listed records with "Date", "Start" (date, time, timezone), "End" (date, time, timezone).How do I make sure the formula only lists the extra working hours? Can I implement a formula where weekend days are calculated differently then weekdays?Thanks for your help! 

Hi, We use Airtable as a database & are currently using Stacker to project it visually (front) but we don’t like Stacker UX & design. Is there a way to directly use Webflow as the front of our Airtable database ? If yes, would like support from the community on how we can do that :slightly_smiling_face: Thanks in advance !

I have a use case where I am entering data from an outside source. These records will later change on this outside source and I would like to be able to update the AirTable record based on these changes.The problem that I am running into is that you seem to need the AirTable record ID to do this - which I won't have. I am wondering if it is possible to do any of the following:Create a record with my own recId - so that I can then update it later using this IDEnter a value on another field - line myId - and then use this field later to update the recordSet the AirTable ID based off of something else - so that I can recalculate it laterI know that the create query returns the recId and I could potentially update my original database with this ID and use it, but I would like to avoid this if possible. It is confusing to me that the docs have an "upsert" option listed, but there doesn't seem a way to actually do this as we can't enter ou

I've developed an AT base for managing orders in my small business. What makes it stand out is how I use Calendar view to create a very elastic and robust calendaring solution that has no competitor. I've done lots of demos for folks in my industry and they want a copy of my base just for the calendar. Doing what I've accomplished is not intuitive in AT -- I asked so many questions in the community forums and never got anywhere. It was only through hours exploring the various features that I finally built a digital version of my analog calendaring solution.It seems like the best way to share/sell my base to my colleagues is to duplicate it to a blank version (essentially a template) that I could share and they could then duplicate into their own AT accounts. Am I correct? If I go that route, I'm assuming that I'm going to have extra fees on the AT side beyond my current annual subscription. How do I go about determining what those fees might be so that I can price my base acc

I have a database where I manage the personal time off (PTO) for a large team.  Each record has the employee's Name, Start Date, and End Date (as well as manager's approval, notes, etc).  These PTO requests can rage from a single day (where start and end date would be the same) to multiple weeks.  I need to produce a report for our payroll department of all of the records that fall within a certain pre-defined pay period which runs Sunday - Saturday for each week. I am also looking for a way to automate this or make it error proof.A filter can easily be created to capture the records that apply to a given pay period:Start Date, is on or before, the last day of the pay period~AND~End Date, is on or after, the first day of the pay periodThis will find any entry that has one or more days within the pay period.The brute force way to do this would be to manually update the filter definition each week, export a CSV, a

Hello! Apologies for the potentially basic question, but I was having trouble sorting through the existing documentation and I couldn't find a simple explanation. I'm trying to pass the output variable newCode into a new script, however I'm not sure how to define the variable before I pass it to the oldCode variable (see screenshot). Any suggestions would be appreciated!Thanks,Peter

Hi everyone, I just would like to know if it is possible that I can hide fields with empty value in gallery view. Airtable

Greetings,Maybe somebody is facing something similar starting today? When trying to submit a form the following error appears (below).  There were no changes to the Base. Also, the same started to happen to an older (4-5 months old) version of the same base. To add more, one of our automations started to act up - We have an automation which fills in 2 "single-select" fields, where the second field is a limited view depending on the first field. This error comes in "invalid item in array cell: foreign record is invalid: row is not visible in column view restriction". Both of these issues appeared out of nowhere. We do have only 1 GB and 10,000 records left in the plan (also tried to making some more to see if that help - it doesn't), but it doesn't seem like it can be an issue. "Cannot process form submissionOh no! Somebody made changes to the structure of this form after you loade

I have a Facilities Walkthrough table where each field represents an area.  For example:Store, 1.1 - Tables, 1.1 Issue, 1.1 Image, 1.1 Owner, 2.2 Awnings, 2.2 Issue, 2.2 Image, 2.2 Owner, etc.12, yes, scratched top, <image of table>, dave, , , , , In this example, there is only a problem with the table, not the awnings ... I have a Remediation Table that is setup like this:Store, Area, Owner, Issue, ImageI want to use a script to take any area with an issue and push it over to the Remediation Table.So in the Remediation Table, once data is pushed over from the Facilities Walkthrough, it would look like:Store, Area, Owner, Issue, Image12, Tables, Dave, scratched top, <image of table>Thanks in advance for any help!