Base Design

View the latest field Hi, I’m totally new to Airtable and so far I’ve been fascinated by it. :smiling_face_with_sunglasses: I started doing is something that allows me to keep the daily balance of different accounts, see image, So I capture daily transactions and therefore the actual balance is the last recorded . How can you make a query or a summary, which brings me only the data of the most recent registration of the different accounts? Thank you very much for your help

I am trying to use XML to get and update information from my Airtable. I am doing the following for POST to update a value but I keep getting error 422. I am doing a very similar process for GET and it works, but not for POST. function httpPost(BaseID,tablename, APIKey){ var xmlHttp = new XMLHttpRequest(); var url = "https://api.airtable.com/v0/" + BaseID + "/" + tablename +"/"; var propValue = { "id": "recIYykIMqJGcvNNi", "fields": { "Variables": "Test 1", "Value": "136" } } xmlHttp.open('POST', url, false); xmlHttp.setRequestHeader('Content-type','application/json'); xmlHttp.setRequestHeader('Authorization',"Bearer " + APIKey); xmlHttp.onreadystatechange = function() { if(xmlHttp.readyState == 4 && xmlHttp.status == 200) { console.log(xmlHttp.responseText); } console.log(xmlHttp.status) }; xmlHttp.send(JSON.stringify(propValue)); }

I have a table which is an inventory of all of our computers in the company, with several piece of information (RAM, etc.), with the computer name being the primary field. I have a second table which is a data export of all DEVICES that have our software installed on them and what the software version is, including work computers and employee computers. I’d like to create a field in the first table, that’ll grab the software version from the second table. When I try to use linked fields, it populates the first table with all of the devices from the second table, though. Is there a way to only list the devices in the first?

I have tables set up with Autonumber as the primary key. It’s basically my version of a CRM. I have the Contacts linked to the Company records, but it displays the AutoNum instead of the Contact name. Is there a way to choose what displays when you link records? I saw a previous topic that the recommendation was to have the AutoNum NOT be the primary key. Since there can be a number of Joe Smiths or JaneMillers in a given set of names (examples only), I’d prefer to keep the autonum to get a unique key. It would definitely be helpful to see ‘Jane Miller’ in the company record instead of ‘1’…

Can you create a picklist for entry into a primary key field? This would allow a standard and defined list instead of letting anything go into the field. Thanks in advance. charley

Hi, I’m looking to link records from one table to another. At the moment, the way I’m linking the two together is by linking via the main table using the lookup function. Is there a way to directly link from one table to another without using the main table as the core linker. Thanks in advance!

Here’s the same question about tags that I have and there doesn’t seem to be an answer… How to use tags in Airtable to find matching records Ask the community Hi I am new to airtable and appreciate any help. I am creating a table of info product files that will have some tags attached to them. I want to: Have a field where I can store as many hashtags as are applicable Search and select only those records that match the selected hashtag To be even more ambitious, in my dream world, I’d like to be able to create a list of unique hashtags used across the entire table Is any of this possible? If so, any instructions would be hugely appreciated and …

Im positive this has been asked in the past because it seems like a standard thing in spreadsheets. but is there a way to view my data vertically? i have many columns with few rows and just wanted to flip the data somehow…

Hi Novice Airtable user question - advice gratefully received. I want to create a master ‘to do list’ - which I will primarily view as Kanban - which I can both add new ‘tasks’ and also pull in items from other tables; using the status field in the other tables to then organise the master to do list. The Airtable is helping me with my professional development covering working on a new business idea, networking, job hunting, writing etc. What is the cleanest way to create a grid that has ‘new items’ and linked records? How can I pull records in from multiple other tables into my master plan and create a status field in the master document that pulls from the status fields in the separate tables? So I might have some networking activities to do, some writing to finish, a job to apply for etc - each of these are currently in separate tables? I hope that makes sense. As a note, the sub tables (job hunting, writing etc.) aren’t just about ‘tasks’ - as they serve as repositories of infor

Hello, I would like to create a new base with data extracted from other bases. Do you know if it is possible ? Thank you for your answers ! Marisa

Hello everyone i am new to air table and i would like to know what is the best possible way to integrate lead routing into the system!

Hey all, I have been using Airtable for a few years now and I’ve got quite a few complex tables happening these days. Which is fun. But can also be frustrating. I am wondering whether there is any table or function that will allow me to view all of my fields in the one place, along with their linkages, their field types, descriptions, and their options (eg if it’s a single select, the options to select). Does such a thing exist? A particular use case outside the general described above would be when we are planning to build a new website. What I like to do is create different tables in Airtable to wrap my head around how the new website’s database would look. But I’d be able to better plan this if I could see an overview of field links with their respective options. Basically adding in another SUPER table showing this. Any help would be greatly appreciated!

I am trying to post a gallery link to Facebook and the link posts but only with an Airtable pic? Is there a way to do this? I am interested in my Notes information as part of the post.

I have published a gallery view to my wix page and thought everything was great. Question. Why when someone clicks on View larger version does it take them to an airtable.com site? 2nd question. If I like the larger view that seems to be appropriate how can I duplicate that view? Thanks for your help charley

I am moving along quite well. Quick question about embedding on a six page. I can easily change my page size to see more, but I don’t see an option to show more of the gallery. I know folks can scroll, but my current provider allows adjustable sizes of the embedded window within the Wix window if that makes sense. Thanks for any help. charley

Hello all! I am trying dynamically update my available inventory based on dates. For example: July 22, 2020 Event 1 Gear assigned A01, A02 July 22, 2020 Event 2 // When I go to select inventory I want to assign to this event, I want to make sure that A01 and A02 are omitted from the list since they are already being used on the same date for Event 1. July 23, 2020 Event 1 // All inventory will show as available now since it’s different date. Thanks so much in advance! Joanna

Hey everyone, In table #1, I need to create a field that calculates a SUM(values) rollup of the costs associated to records in another table (let’s call it table #2). I created a linked field that links table #1 to table #2, but is there a way to link to all the records in table #2? Let’s say the records in table #2 are labeled “A” “B” “C” etc… I would like a field in table #1 to link to all the records in table #2 that are labeled “A.” But there could be hundreds of them theoretically, so manually linking them isn’t feasible. I’ve tried copying the values into the linked field, but it only returns one link in each field instead of all the records that match. So instead of summing the values in all the records labeled A in table #2, I just get one of the costs in table #2. Sorry if that description isn’t clear! This seems a bit complicated to describe! I’m essentially trying to replicate the function of a Match/Index/Sum formula in Airtable!

Hi, Question about linking records between tables. I want to create a dynamic conditions linking in Airtable. Is this possible? I only see the option for static conditions. Here is a example to explain what I want Table 1 Firstname - gender - hair color Joost - men - yellow Ria - female - brown Robert - men - brown Table 2 Groupname - criteria - names(table1field1 where condition of table2field2 = table1field2) Mengroup - men - Joost, Robert Femalegroup - female - Ria Thanks in advance, Robert

We are a charity amateur brass band in the UK which plays music at charity events and teaches music to members of the community of all ages. We have approximately 100 members and will probably not grow very much bigger. I have designed our membership and stock database on Airtable. We will have about 10 collaborators, so would never be able to spend $50 a month to install blocks. However, we are looking for a solution to be able to send group emails to the membership from the database, so that leaders are compliant with GDPR and don’t have personal lists on their computer. Do you have any ideas that might help us?

I’m new and trying to figure this out but can’t find instructions if this action is possible or how to if it is. I am currently evaluating the product for use. Thanks for any help

Hello there, I am wondering how to create a new page for air table survey forms. Thank you

Can you please help me think though how I should design this base? I want to list classes and instructors, but I’m having trouble figuring out how to group by instructor since I’m using the same table for Instructor 1 and Instructor 2 Tables: Instructors: Name, Email, etc. Class: Class Name, etc. Offerings: Class Name (linked), Instructor 1 (linked), Instructor 2 (linked), Date Sample Data Instructors: Aminta, Iman, Catherine, Franklin Class: Waltz, Tango Offerings: Waltz (linked), Aminta (linked), Franklin (linked), 8/31/20 Waltz, Franklin (linked), Iman (linked), 9/17/20 Tango, Franklin (linked), Catherine (linked), 9/24/20 The question is this: Is there a structure that would allow me to pull instructor 1 and instructor 2 from the same table (like I’m doing) where I could also group them and get all the classes taught by each leader? For example, in this data set, if I group by instructor 1, I miss the waltz class taught by Franklin where he is instructor 2.

I have 2 tables: Customers Workouts When I create a new workout I want to auto-link it to every customer in the customers table. Is there a way to do this? I found a ‘hack’ of sorts on the forum - grouping workouts by linked customers and then adding rows from below the group that contains all customers. But the problem with this is that I need it to automatically include any additional customers when they get added to the customer table. Any suggestions?

I created a form with airtable because I wanted my users to be able to submit their own posts which include a title, description, and an image and I wanted it stored in the spreadsheet I made with airtable. Is there a way for me to connect my form with Thunkable so my users can submit their posts through my app?

Hi, Here’s what I’d like to do. On my website, I’d like one form (Table 1) to have two fields. Twitter Handle Writing Prompt On my website, a user fills in both fields then the data gets added to Table 1 (in airtable). When Table 1 fields are filled, another table (Table 2) on the same web page will display the Twitter Handle and Writing Prompt. However, Table 2 will only show the LAST record (Twitter Handle and Writing Prompt) input from Table 1. I found this page that I thought would be helfpul: View last record only but I’m unable to make it work. P.S. I want to prevent users from adding duplicate data. I’ve added a picture to make things more clear, this is the kind of page I’d like to build. @Jacks data was input earliest. It vanishes once the next user (@elon) adds data. This would be TABLE 2. @You and “Go ahead…” would be the form where a new user would input their data. Once the user ads the data, it gets shown in Table 2.