Other Questions

Hello! We are running a Delivery company and we need to sync around 20 tables (each one for each ryder) into a final table (a multisync function). I ve looking for the price of this task but is not covered by Pro. How can I find out the price of Enterpise version?

Hello! I am running a delivery company and we need to have an easy app for the ryders. We only need them to fill a simple ticket. Now we are using the tickets of the free version. Is doing well but we are wondering if there is an app that can improve this task. Looking forward your answer. Thanks!

Happy to do the following in both Airtable and Excel (and involving as many steps as necessary). I have two separate tables with a similar multiselect column in each, involving many values or “tags” as I call them: Table 1: Table 2: I want to add an additional column in Table 1 titled “Tags”. I’m trying to populate this column. If Table 2’s Product Tags can all be found in Table 1’s Product Tags (not an exact match, but rather if Table 1’s column contains the content from Table 2), then I would like to return the name of the brand (column A) from Table 2. Please help!!

Any advice on getting a PATCH request through PHP to work? I’ve tried editing just about every line of the following code (API key, base key, and row ID omitted). PHP doesn’t give any errors, but the ID won’t update. $ch = curl_init(); $api_key = ''; $base = ''; $table = $_GET['game_id']; $url = 'https://api.airtable.com/v0/' . $base . '/' . $table; $headers = array( 'Content-Type: application/json', 'Authorization: Bearer ' . $api_key, ); // json body $json_array = [ [ 'id' => '', 'fields' => [ 'coordinate' => 'test' ] ] ]; $body = json_encode($json_array); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'PATCH'); curl_setopt($ch, CURLOPT_POSTFIELDS, $body); curl_set

I’m trying to design a label to be printed using Page Designer. How does one configure the font size for single and multi-select fields? Is that function not available yet? It seems the community has been asking for this for a couple of years now.

Hello, I am working off a Wedding Planning template but would like to implement a table which sole purpose is to help me roughly calculate the estimated cost of each Venue + Caterer + Vendor combination. Essentially, in my Venue Table, there is a Linked Data column that links to the Caterer Table where the cell is populated with Caterers that serve that specific venue. In my Estimated Cost Table, there’s a column for the Venue, one column for the Caterer, and one for other Vendors. The last column performs pulls data from 3 lookup fields from each of the Tables and sums them into an estimated cost. However, when I go to click on the Caterer lookup field, it’s listing ALL the Caterers but I’d like it to only show Caterers that only serve to the Vendor I selected. Is there a way to do this? I realize this sounds confusing so I’ll provide an example: Venue Table: Venue Venue Cost Caterers Apple Field $1000 Caterer A, Caterer B, Caterer C Corn Field $200

I have destination table set up to sync all new fields created in source table but it is not happening. Has anyone else had this issue?

I’m using dropdown values for a “Project Name” data field. Some of the dropdown values do not show the text, but some do? Does anyone know why this happens, and if there is a fix? This used to work fine, but it changed a few weeks ago.

Hi there, we currently Airtable for our cycling club to record new members and as a register for attendees for cycling sessions. I have been trying to figure out if Airtable has a function that enables an admin to share a sign up link to a new parptipant so they can enter their details to create a new record for a rider. Is this possible does anyone know? Ie share a form so they can enter their details, without them gaining access or seeing other people’s details recorded? Hope you can help,

Hi, I hope you can help me: I have two tables. “Customers” and “Products”. The “Products” table shows all items that belong to a specific product: Multiple items are assigned to one product via the “Product” field (single selection). By then grouping by the “Product” field, I get a catalog that shows me which items belong to which product. (Ex: Product 1, items 1-5, 7 and 9-10; Product 2, items 1-5 and 7-12). Now we have a new customer. Again, in the table “Customers”, I want to show which items the customer gets. The easiest way would be if I can say via a link:Customer XY has product 1 and then Airtable automatically shows me the corresponding items in a single field (here in the example items 1-5, 7 and 9-10). So far I have only managed to link each record individually, but then I don’t need the summary for the product. Basically I am looking for a way to link groupings. I hope I was able to make my problem understandable🙈 Does anyone have any ideas? Is that possible at all?

Can we bulk edit column types? Change the width of multiple columns, at once? (community says no, but :crossed_fingers: double checking :crossed_fingers: )

I’m on Chrome (latest) on Windows 10 (up to date). I cannot find a key combination that will move the cursor out of a Long Text field. The usual suspects including Esc, “Tab” in various combinations with Alt, Shift and Ctrl don’t do it I hate having to take my hands off the keyboard to use the mouse just to move to the next cell.

I have Table 1 with thousands of records. In Table 2, I want to summarize the data by linking the records and then using lookup fields to get specific info from each record all in a single cell. I’ve linked Table 1 to a field in Table 2, but to get all the records, I’d need to manually select each of the thousands of records to add them to the linked cell. Is there an easier way to do this? I made a dummy database and screen recording to illustrate what I’m trying to do, but instead of 4 records per “company,” imagine thousands. Thanks for any help.

hello! did anyone experience this? I was working for my client. Showed me an excel spreadsheet that needs to be transferred to a table to a particular base. What I did was I created a new table in order to import the spreadsheet instead and configure relevant fields. I then inspected if all the data showing are correct. Everything looked fine. I also added linked records and looks good too. I then messaged him to check but said a few minutes later that he could not access. When I checked all the other tables are fine except the one I created. It looked just white screen. My client already tried refrehsing the site, closed and opened the browser too and it’s still the same.

When I first set up my base, I established one field, mistakenly, as single line text instead of a number. I recognized it with 100+ records in, and have lived with it ever since. Now I want to change the field type for this field from single line text to number, without losing the entries. I could probably sort the records by that field and add a new field as I want it, then add in all the new field entries, and last delete the old ones. Is there a faster or base-wide way to accomplish this? Many thanks.

Hi there My use case is that we’re an agency and each month we deliver items from a service catalogue to deliver services for our clients. Our service catalogue is in Airtable (see below) I now want to use AT to forecast the items we are going to provide each month so I can see the number of points (think ‘hours’) we are going to deliver both at a customer & global level. I have set up a simple table to do this (see below) This step is easy, however, the next level of detail I’m trying to crack is something I’m not sure how to architect in AT. A lot of our services are further broken down in terms of the resource required to deliver them (i.e Account Managers, Content Team, Design Team, Development Team etc.) and the total points for each item may be broken down into a fixed number of points per team. For example, creating a blog article is 3.5 points in total but those points are broken down across various teams. What I am trying to do is enter a list of the services for each cu

Hi there, I have a table that contains project records for all my projects planned for the year. Each project contains multiple tasks that have a start and end date. Is it possible to represent and distinguish all of these on a Gantt View without separating each task into its own record? In an ideal world, I’d color sections of the Gantt bar to denote what Task stage it’s in. Cheers, Peter

The view is shown as “Shared”. Every time I try to add a filter, I get warned that synced tables/bases will be affected. I want to find all the synced tables so I can change them to a different view that is specifically built for sharing. How do I find all the places a shared view is use? (If I rename the view, it gets reflected in all the other bases that sync it, but how do I find them all?)

Hi guys, I’m looking for a way to extract the changes from a specific column (string). I have a base with client names and each client has its account manager (each account manager can handle more than one client). We work in a dynamic environment, and the account managers’ responsibility changes frequently. Given the above background, I want to create new automation using Zapier/Integromat to inform the previous account manager via email that he doesn’t own this account anymore. The problem: I can create a last modified field and use it to trigger Zapier/Integromat, but how can I extract the old value from this cell? Example: Current A.M name: Dan I’ve added a new A.M named Stan Now the trigger has been activated, but the cell value is Stan How can I get the previous cell value in order to send the previous A.M an email? Any idea would be very helpful. Thanks in advance for helping!

Good day all. Let me first start with our existing workflow. We currently are using QuestionPro but are switching back to our Google Suite Enterprise for surveys, and generating the data to a linked google sheets. My question is how I can have this integrated, if at first what we already have running OR if there’s a more efficient way to do this ALL in Airtable without being a painful transition and/or losing data. Still seeing all the cool benefits of using AT!

I would like to create a Form in another application which shows all of the possible options in a Multi-Select field. To do so, I need to pass to that application an array containing all of the unique values in the multi-select field. The ArrayUnique function works for a rollup on a per-record basis, but I need to summarize the field values in an entire colum. How can I do this?

I am trying to set up IFTTT to automatically record my Tweets but the Airtable connection seems broken. The instructions say that once the Base is connected, you can choose the Table from the dropdown. But that’s not what I get when I’m going through the process. The Base is shown but the Table field doesn’t give me a dropdown of my existing tables. Instead, it just says “Add Ingredient” which are the ingredients from the Tweet, not anything from Airtable. Does anyone know how to fix this? Or if I’m just not understanding it? It does not currently match the Airtable instructions on how to create this connection. Any help much appreciated. Cheers! Valerie

Learn and ask questions about using dates and timezone adjustments in Airtable. For related support content, see the follow articles: Date and time fields Formulas and date fields Supported timezones for SET_TIMEZONE Supported locale modifiers for SET_LOCALE Supported format specifiers for DATETIME_FORMAT

Does anyone know an integration that will pull a Word Count from a linked Google Doc? For background, we create a record for each post in an editorial calendar. We have a field linking the Google Doc where the document lives and we’d like to add a field that shows the Word Count from the Google Doc. I’d love a way to pull that automatically rather than having to enter it by hand. Thoughts?

Hello, I’m wondering if there’s a way to highlight multiple cells in a table to get the sum quickly. In excel, I would hold “CTRL” and select the cells I need. It seems that I’m not able to do that in Airtable. I know you can highlight cells that are adjacent to each other, but the cells I need are not next to each other in this case. Thanks for any help!