Other Questions

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.

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!