Other Questions

I am trying to create a view based on rooms and multiple items within that room. Is there a way for me to just output the room number once at the top and then the related records for that room beneath? Currently, i have it grouped by room in view, and the records just show up in rows with the room number on each. Current: Room 111 table Room 111 chair Room 222 lamp Desired: Room 111 table chair Room 222 lamp

I have a set of tables with a descending set of relations. Grandparent has children which have children etc. I choose the linked records from a parent record and this stores my order since the ordering is dependent on the parent. When I create a view from the lowest level I want to be able to group by the ancestors and then sort each group by the linked order. I only get options for alphabetical. Is there some other way around this? Can I somehow get a calculation to expose the ordering of the array of linked records?

Hi very new to airtable. Was wondering if there was a way (lookup or formula) to display the most recent collaborator comment on a record in a tablef? so for instance, be able to include columns such as: col X: Shows content of the most recent comment made by a collaborator on a specific record col Y: Shows the name of the most recent collaborator comment col Z: Shows the date stamp of the most recent collaborator comment Hope this makes sense Thank you!! Jason

Hopefully this is a simple one and I explain this correctly: I have a table of products containing several fields, including: unique product ID and price. (Let’s call this the primary table) I am using the Data Fetcher Airtable app to pull updated product information from an API into a separate table in the same base. (Let’s call this the secondary table). This also contains a unique product ID and price I want to fetch the price in the secondary table and update the relevant price field in the primary table, using the product ID to ensure the correct item is updated. If these were two tabs in Excel, I would just use a vlookup to look up the id and return the price. However I can’t figure out how to get this to work in Airtable. Any advice much appreciated. For info - the two tables do have a name field, containing the name of the product, however the names in the primary & secondary tables don’t always match, so I cannot use this field to match an item. Many thanks

Hi, I have a customer order table that includes, customer name, order date, order… etc. I am aware that I can create a CSV file with the fields explicitly shown, however, I would like to create a CSV file just with the customer contact details, name, email, etc which is currently set up as an expanded record field. I need to know how to create a CSV record of the customer details only. I hope that is clear! Thanks

I’m seeking a way to protect from records becoming accidentally unlinked (or at least being able to relink them again). Example scenario: Let’s say table1 in db1 (table1.db1) is synched as table1 in db2 (table1.db2) and table2.db2 is linked to table1.db2. If table1.db1 gets filtered and synch’ed to table1.db2, the missing records will get unlinked in table2.db2. And I see now way to relink them again easily. The solution here (“If a record is removed from the destination table, that record will unlink from any linked record fields to that table”): Sync FAQs – Airtable Support does not protect from the main db admin from accidentally filtering the main table (table1.db1). Is there some way to store the record ID of a linked record in table1 within the linked record in table2 (e.g., with a script)? This would then make it possible to at least repair the links after they’ve been broken (and after fixing the filter in table1.db1).

Hi, I have been asked to track data (think revenue and cost) over time. In the tables where this is calculated, I can easily see what the current revenue is for a project. But I need to get revenue per project at time intervals so it can be graphed. I set up a Summary table where I can write an entry per project and capture the timestamp. I did this simply for proof of concept using a checkbox field. An automation runs if the checkbox is selected, creates the entry in the summary table, then clears the checkbox. But now I need a way to completely automate this without having to select a checkbox. I thought running an automation on a schedule (perhaps once per week) would let me capture the weekly snapshot and write a record to my summary table so that the data can be graphed. But, it doesn’t appear that using the schedule trigger will work. While it will fire exactly when I want it to, I can’t create a “Create record” action to add a record to the summary table using values in my so

I have two tables in Airtable. In one table I have a monthly cost field, and 3 date fields, (date of invoice, start period of invoice, end period of invoice). This table tells me how much a customer is paying per month, when they started receiving the service, for how many months they paid, and when the service period ended. In a different table, I have a list of dates with monthly intervals (e.g., Jan 1st 2021, Feb 1st 2021 etc). In that table I want to calculate how many customers in the first table were paying customers on each date, and how much they were paying in total MRR.

I’ve created a simple table to inventory my card supplies. After creating I decided to make changes and combine two columns into one, then I deleted the no longer need rows. I now realize that I should not have deleted the rows but should have left them empty for reuse. My question is…when I want to create a new row is there any way that I can re-use a deleted row ID?

hello, i have been using sendgrid as an applicatin to send mails for several months without any problem and today i have an invalid utf8 in request error. Do you know why? Thank you

Hi Guys i am trying to show my records of my table on INTUIFACE which i can do with list records, but i need to be able to edit the records live. when i try update record it only shows 2 records not all and when i update a cell it updates them all even if PATCH is used, i delete data from the cell in intuiface so it doesnt change it and it deletes the data also. how do i show a list of all records and be able to edit them and selec each record and its fields to edit like normal

I’m building a database to track uniform assignments for the local high school marching band. I have one table for students, another for the jackets, another for the pants, and so on. In the Students table, I have a field using the link to another record option linking to a jacket. I’ve been careful to make sure to not Allow linking to multiple records. I’ve then gone into the Jackets table, and made sure to not Allow linking to multiple records. What I can still do, however, is assign the same jacket to multiple students. And when I go to the Jackets table, I can see that the same jacket is assigned to two people. I would love to have this set up in such a way so that once a jacket is assigned to one student, it is not allowed to be assigned to a second one. Is there a way to do this?

Hey, I am trying to create a hierarchical structure for different projects. To simplify the whole thing let’s say there are 3 Tables: Categories → Project → Tasks I would like to create a hierarchy within the Projects Table. As far as I know, it is not possible to create both-way sync within one table but I was hoping to achieve that with automation. My current automation selects the parent ID and adds the record to the child column. (To be more specific: The automation selects the original record + a lookup of the current child values and writes that in the child column) The problem arises when I change multiple parent records at once. Is there a better way to do that? Ideally, I’d love to recreate the sync both ways option from Notion when linking a table to itself. Thanks for the help already.

I am wondering, if I have an Email address field inside a restricted email domain form (which requires a user to log in - Pro Plan feature), is it possible to prefill the Email address field inside the form with the user’s email? Is there a way to access it so it can be prefilled within the URL already? Thanks in advance!

Hi, I want to write a formula that will return ‘Yes’ if a record has been modified before a specific time of day. I have my team ticking a checkbox, which if checked before a certain time will mean a yes result. If the tick box is ticked after that time the result is no. I’m using the ‘last modified time’ field type as the time stamp to use in the formula I tried Is_Before with TimeSTR but not sure about how to specify the deadline time. Any thoughts?

Hi! I’m trying to figure out how to get the gantt view to display a background grid of column & rows so it’s easier to read quickly. Is there an option somewhere for that? Just a plain ol’ outlined set of cells, basically. Thanks!

Hello!! Is there versioning for the sheet/table you made in Airtable? if so How to do versioning for the sheet you made in Airtable? your cooperation in this question is greatly appreciated. Thank you Ahlam

I have a simple table with Attendance columns by date. 5/21 5/22 etc. I have secondary grid that limits the view 1 date at a time. My goal is to have a student take attendance at the door on an ipad. However, when I test, when ever I try to click on the check box for marking present, it opens the entire record and the recorder has to scroll to find the current date. It is not hiding the fields I don’t want them to see. What are my options. This works perfectly on the Desktop, but need this to be portable. EDIT: Upon research, it looks like hiding in the expanded view isn’t possible on the app. SO…What about not opening the record and just editing in Grid view on the app?

When i disable “Allow viewers to copy the data in this base” or “Allow viewers to copy data out of this view” and try to copy the data. If I copy a batch of cells i receive “Sorry, the table’s owner has disabled copying” but if it is still possible to copy one individual cell. Is there anyway to disable copying one individual cell?

I’m using BravoStudio (a No Code tool) to design an App. Random content can be obtained by clicking. I use Airtable as a container for random content, but I am currently stuck at this step: I don’t know how to get random records. What is the solution? I tried to use a third party such as Integration, but I didn’t know how to do it. Can I write an App script to achieve it? Who will teach me… :cry: :sob: :cry: :sob:

Is it possible to log/record the active filters for a given view of one base to a separate base? Essentially I want to create a log that captures the filters/queries used for the saved views.

Is there a template for organizing photographs? I have thousands of digitized photographs and would like to organize them.

There are two linked tables: Posts (ie. an index of blog posts, with dates) Companies (a list of companies who author blog posts) Companies already has a Count field column to display the total Posts by given Company. However, I’d like also to count the posts by Company within the last seven days. One view of Posts is filtered to show records with dates within the last week. But how do I utilise this or similar on the Companies table? Thanks.

Hey all ATers. I was wondering if there is currently an “alert”/email, etc that is sent to the main creator whenever an editor or less does something in one of the workspaces, bases, tables etc? I’m the Admin/Creator and need to be made aware of any changes, deletions etc. that are made so that I can check them immediately. Does AT do that? Thanks!

Good day again ATers! Quick question on AT rights. Is there a way to set various users beyond the “creator, editor, etc” to only allow them to edit certain fields? I have a set of teams, including my own internally, that will be working in various tables, and instead of creating duplicate views for each user, is there a way to just give each a different access/lockdown? For example, All users need access to the full “course” table, Each user needs to be able to create, edit(but not delete) a course, they can leave memos in the expanded field if they need that. Each user can only edit THEIR courses, not others(if this isn’t possible, that’s fine). So basically, needing to limit user access to not screw up the huge database :). I think that’s it :). Any suggestions, comments, ideas? Thanks!