Other Questions

I need to create a view similar to this SQL question: select name, max(date) from xxx group by name; I have no idea how I can do this with airtable. Any help?

Hey there! So, a bit of an interesting request. I’m looking for a way to do a “auto number/autofill style” Date field. I’m usually working at a lot of odd hours and my days really exist from 10 AM - 10 AM in a given 24 hour cycle. With that, the general view filtering methods of view based on “current day” don’t really work well for me- I’ve found some loop holes- but nothing perfect. Given that I also would like to track time/duration data from a lot of my tasks via day/date tagging, I figure its just useful to kill two birds with one stone and tag a pre-set date instead. A caveat being, is that i have tasks going out months in advance, and it would be great to have a way to simply create a pre-filled new record with a descending date based on the previous one. I’m still plugging away but havent come across anything to obvious yet! Thanks!

Hi, I was wondering if you could set up a pivot table in a new table instead of using the app that just visualizes the pivot table but doesn’t allow you to add field to that table. I hope I’m expressing myself clearly. This is the idea: I have a table with properties that have a field with the responsible realtor (table 1) I want a table which lists the realtors and how many properties are linked to each realtor (table 2) in table 2 I want to add fields with for example notes (long text) or a status (single select) This sounds quite simple but I don’t quite understand how this works in Airtable. Thank you in advance!

I have a form that I have the following set up It’s a self serve purchase center. I have a condition - have you ever purchased from our company before if the person selects yes, I show the Sync field that contains all the companies we’ve done business with. User picks their company; I have the fields in the table to auto show through roll-up the full address for that company and the current status of their W9 from us - If I do manual entry through the VIEW in the table but not through the form. I can’t seem to get any way to trigger to show the address information for that Company that was selected in the form so the person can answer the “Is this Correct ?”. In my old days I built this entire form in Excel - so I know it can be done, in some automated way. Thank you in advance for taking the time to read and answer.

I have emailed for help to but thought if anyone is having the same issue. A couple days ago i noticed my form entries werent updating on my base like usual thought maybe just a bit slow so i left it over the weekend but still having problems. I have my form entries linked to my email with automation and can see for ages now not all entries are being populated in my base only some. I have included examples of screenshots so you can see the difference in entries per date in my email vs my base? Anyone know how to fix this bug? Thanks

Hi! I see that from the “link to another record field” type in the grid view I can instead of choosing an existing record, create a new one. However, in the form view, for that same field, the only option is to choose from existing records. Is there anyway to fix this and for the form to have the same capability as the grid (choose existing record or create new record)? Thanks for your help!

I have created a table in a base that includes a rating field (1-5 stars). I am sharing it on a website. However, I want to do the following and not sure if there’s a way to do it. I want to be able to show on the website ONLY the records that have 5 stars and nothing else. I know I can tell the viewer to create a filter but that’s a hassle. I don’t want the viewer to do anything. Thanks.

hi , everyone here’s quick question , can I setting a reply limit of linked record field on form view , linked record field are allow to selected more than one option now but I hope it can change into single select (maximum one option select) (not single select field , still Linked record field but only can fill one answer by user) is that possible ? because not native speaker and I’m worried about that I didn’t explain my situation clearly so please see the screen shot as below : thanks a lots !!! :grinning_face_with_smiling_eyes:

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