Other Questions

Hi, i have problem with form responses, so i have created form from multiple table but there's no option to get from responses, is there something missing or i need to do something for someone who fill the form can get the form responses?

Hi,Sorry about the newbie question: via scripting, I´m trying to import a csv using .parsedContents however my csv has several spaces and non-AlphaNumeric characters in the headers so when I come to map the fields I don´t know how to specify them, for example line 4 in this snippet there´s a space between LAST and NAME:1 let newRecords = fileRows.map(fileRow => ({ 2 fields: { 3 'Email': fileRow.email 4 'Last Name': fileRow.last name, 5 } 6 }))As I have several files to import several times a month I would not like to have to "cleanup" the csv in some other spreadsheet as it´d defeat the whole purpose of using airtable as I already have (an ugly) way of doing it all in excel.Or is there a way to use the extension CSVImport via scripting using a predefined csv>table field pairing for each table?Also, I´m wondering if it´s possible to run a script any other way apart from the side extensions panel.  Is there any way to have a custom but

Hey there!Started playing with the new "List" view type and noticed that there is no way to reorder "Level 1" records. When I hover on a record, I can see the icon that usually implies ability to drag and drop the record... but when I try to do this - the record just gets selected (check mark on the left) and nothing happens. I know how to reorder records on grids. I made sure the view doesn't have any sorting rules or anything else that could interfere with the drag and drop function (reordering)... and nothing helps. Is this a BUG?p.s. thanks to the Airtable team for the new view type! I'm overall enjoying it so far.

My code is really long so I'm not posting the whole thing, but here's the gist:  let choice = await input.buttonsAsync('Is the stock received from a pending order, transfer or unsure?', ['Pending Order Received', 'Transfer', 'Unsure']); if (choice == 'Pending Order Received') { //code here with no errors } else if (choice == 'Transfer') { //code here with no errors } else if (choice == 'Unsure') { //code here }  I'm getting this error with the last if statement for 'Unsure' and I don't know how to fix it:

I'm attempting to create an invoice and all fields are pulling in except one. No matter what I do, it isn't being imported into the Google Doc. Here's the formula:"$" & {Materials to Plain Text} & ".00"The formula works fine and returns the value I'm looking for in the base, but it won't come into the Google Doc. All other fields are coming in as expected. What might be going on?

I added all my files to my projects a few days ago. After I uploaded them, I realized I was WAY over the limit. (I had misunderstood how that worked). So, I went through and took out all of the photos and voice recordings. It got me back under the limit. I decided to add links to my published articles for each project. As I'm doing so, I realized I was over the limit again.What all goes into the amount of space that causes an account to be over the limit? Right now, upgrading plans isn't something I can really afford but I can't keep going forward in adding things to this chart if I have no idea what the parameters are. By the way, I've looked at the tutorials and either this question isn't answered, or I missed it.Thanks.

I know Airtable was experiencing issues this morning but I continue to have trouble with bases not loading. Anyone else? I have tried all recommended troubleshooting and one base in particular that is showing an issue with records loading is one of my smallest datasets, so I am confused. 

I'm creating a project management platform and need some help in terms of organising tables.I have three different tables:Users - containing private informationProject - containing projects we haveProject participants - containing a row for project name, user id, and custom fields (columns 1,2,3) which contains information about that user for the project only. For example project user id or if they are participating in the project currently.I'm having some hard time as we use Softr for this development, and I would like to be able to allow a manager to add or remove participants to a project via the project participants table. That is at least the workflow I have now, but might be that it needs a full redesign. Anyone who can help on suggestions and best practises?

I have granted external 3rd party apps access to a base for testing purposes. How can I remove this access again?

Hi everyone!I want to get Cell values with ID from multi select field by field id of a table using php.https://prnt.sc/HasxED_1cZTbI have a table named "Cand", and there is Irish_Affinity field in Cand table.I know the field ID of Irish_Affinity.So, I want to get Cell values with IDs based on Irish_Affinity field id using php.I can't find any fomulas in airtable API.Is it possible?Please let me know, thanks!

Maybe someone knows what to do… We use Airtable for order management and are filling in new orders with a form. If a new row is created by form, prefilling cells doesn’t seem to work (we have a column for the approriate amount of VAT which is used to calculate the right invoice amount). The cell is correctly prefilled IF we create new rows straight in Airtable without using the form. This seems to a bug, right? Or does anyone know how to fix this? Thanks!

Hello community, there's an overwhelming number of suggesting apps (eSignatures, Docupilot, SignRequest, PandaDocs, SignNow, PDFFiller, DocAutomater...) to create docs with an e-signature from a template. I'm particularly looking for a recommendation that works with Make/Integromat and supports line items to build dynamic pricing tables. Thanks!PS: Alternatively, what service would you recommend to add e-signatures via Make to unique Google Docs.

Hello,I have been building a database for my small newspaper/publishing company. We want to track accounts information, ad orders and runs. It's important information.It seems to me on the pro plan that anyone can share any table by default is they're able to add data?? How can this be? Is there a workaround? If I hire someone, they could theoretically share the data with someone else or clone the entire database without my knowledge? I've read the other posts and documentation and this seems to be the case...Can anyone enlighten me on this? It's such a glaring issue that it is making me stop the Airtable process. Is this better controlled in Enterprise?

Hello, I’m trying to send a Javascript array with multiple values to my Airtable (multi-select field). Array example: var colors = [ "#4BC2A4-a", "#4BC2A4-b", "#4BC2A4-c", "#4BC2A4-d", "#4BC2A4-e", "#4BC2A4-f", "#4BC2A4-g", "#4BC2A4-h", "#f4a261-j", "#f4a261-10-k", "#EF616C-11-l", "#EF616C-m", "#EF616C-n", "#EF616C-o", "#f4a261-p", "#f4a261-q", "#f4a261-r", "#f4a261-s", "#EF616C-t", "#EF616C-u", "#EF616C-v", "#EF616C-w", "#f4a261-x" ]; But Airtable creates only one unique item with all the values inside: How it should be: How I should format the array to make sure Airtable will separate the items by comma ? Thanks.

I tried to set up a Zap to create detailed events in Google Calendar when new records enter an Airtable view – the Zap will NOT work (error 400 bad request) if I try to update the event's visibility (public/private) through Airtable mapping. So my question is WHAT kind of field in Airtable will cooperate with updating event visibility in Google Calendar? Through Zapier, when mapping Airtable fields, there are options to select the calendar default, public, private, or 'custom' where you can then map the Airtable field. I selected 'custom' and have tried a single select, multi-select, and even (ick) a single-line text field to be able to update event visibility through the integration, but no luck yet.  Any advice?

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.Now, I am reviewing all of th

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 the Google Sheet to conver

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