Other Questions

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

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 su

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

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!

I have spent hours and hours on this thing. I am not able to copy paste the records to new table ( it has the same structure ) It doesn’t show the option of Dialog box of Expand cells etc. Please help.

Hi, I discover Airtable, it’s a very good tool I’m trying to make a summary that summarizes the number of rows in my tables on a table dedicated to that Could someone help me on how to do this? Thank you

Hi there. I am currently a admin for an alumni organization. I use the Airtable to manage member database, and trying to find out how I can use this member data to automatically sync to a list or table on a website using wordpress. Before Airtable, I was using excel to manage member data, and had to update the website (member introduction list) manually using wordpress. I was hoping by using Airtable, I would not have to update the website manually, but instead focus on maintaining Airtable so it will automatically update the web at the same time.

Hi everyone, I am trying to get my head around how to structure an inventory location app. I see there is one that I can clone which is great but the secondary level of complexity is that we track multiple locations in the warehouse. This template has the ability to track multiple locations but not multiple quantities in multiple locations. As you can see in the screenshot below I have added 3 locations for the first product but I need to work out how to structure a quantity for each location. Here is the Locations image below, so how can I add a qty for each location? Thanks so much for your help folks in advance.

I would love to use airtable i think it is a fantastic product :relaxed: :relaxed: however i live in Skandinavia and apps created with it Just seem a bit slow to load. Are you guys considering serving airtable from other places than the States?