Other Questions

Stick with me, there is a question at the end of this lol.BACKGROUND: I own and operate a medical records retrieval company. Law firms will hire my company to retrieve medical bills/records on their behalf.  They then use said medical bills and records in order to negotiate a settlement with the insurance company on behalf of their injured client.CONTEXT: We currently send hundreds of requests for medical bills/records each month to medical facilities all over the state. Each of these requests typically require us to do follow ups with the medical facility because they are often swamped and under staffed.  Often times this process can take weeks or even months to complete a single retrieval. Resulting in us have hundreds if not thousands of pending requests for bills/records at any given moment.  So, in order to not lose track of any of these requests, and to ensure we know where we are at in the "retrieval" process for each request, I created private bases for each of m

I set up my table with a Predecessor field (linked field back to the table). I’ve been using this to drive some calculations on dates for sequencing and showing in the Gantt chart. However I want to also use the successor for some other calculations. Here’s my question. In the Gantt Chart view you can click on a record and it will show the predecessor and successor (if they exist). I have only set up Predecessors in my table. However for a record that is “in the middle” of a chain - the Gantt Chart view will show the predecessor (which I set) AND the successor (which it knows as that successor record is set as a predecessor for the record selected). Is there a way (via a formula?) that I can access what the Successor record is? Clearly it’s available as it’s shown in the Gantt view but I can’t seem to determine it from a formula. Thanks!

Hello  Is there a way to copy data into airtable by copy and paste. My airtable table has a link field that points to another table. In google sheets I have the current data where I need to copy some missing records maybe a handful. Is there any way to copy in that link Field. I can copy to any of the other data fields that are not link. But it seems that I have to select the plus and manually enter the location is the link field. Is that correctSorry for w newbie question

Is there a way for the first field of a table (primary field) be a linked field? If so, how do you configure it.  

I am trying to use rollup, and not sure this is working the way I want. I think it would be easier if there is someone out there if they would be willing to have a quick chat on direction. No sure if this is appropriate, so please let me know. 

Hi team,I have classified post website and I want to add automatic user details(username) in database who posted classified.

Given all the complaints & negative feedback relating to the latest homepage UI update is the Airtable team going to address them in a meaningful way besides individual responses? I've even had Airtable support members agree with me they can't stand the new layout.Is anything being done to correct it? Will there be any changes to ensure something this bad doesn't occur in the future? 

I want to have an automation/setting/lock that when I click a certain table tab, it switches to a certain dashboard... can I do this ?The reason is in Dashboard 1 I have a map API showing locations based on addresses in that particular table.I want to be able to click on table #2 tab and see the map on dashboard 2 which will show locations based on that particular set of addresses      UNDERSTAND ??   can I do this ??

Hi, Is there any way to automatically upload/attach an image from a website when I input the weblink in a “Link” column in Airtable? Basically, when I input the weblink into the Link column, some function or some code would run (maybe in a separate “Function” column?) and then grab the specific image from the website and upload it into the “Attachment” column. Not sure if this is feasible or not… Any help or suggestions are greatly appreciated! Thank you! -Dave

Hi! I want to calculate time that falls within a specific intervall. I want 1 column for weekend hours, 1 for evening hours and 1 for night hours. The rules would be as stated beneath. How would I do this? My time columns are "start" and "**bleep**". If you know how to do this I would be super happy for a specific solutions since I usually get things messes up when I have to alter to much on my own 🙂WeekendI want to calculate all hours for a booking if it is within saturday 06.00 (6am) and monday 06.00 (6am)EveningApplies 19.00 (7pm) to 22.00 (10pm) monday to fridayNightApplies 22.00 (10pm) to 06.00 (6am) monday to saturday

I have three subcontractors working in separate (but similar) bases. For NDA reasons they can’t work out of the same base. However, for better admin, I would like to roll up all their records into a single base? And I would like it to be automatic, so whenever they make a change to a record in their base it updates it in the master base. Is this possible?

I just noticed this new option in my right-click menu for records: I clicked on it, but it looks like you have to have created a template in order to apply one, and I can’t find anywhere to do that. Is this a new beta feature?

Hi there! Airtable is doing this weird thing where you can no longer paste inside a text field like if you hit paste while IN the text field, it overwrites everything. We hope its a bug because I copy/paste to move around text all the timeIs it possible to have a solution about this?

Dear Airtable Community, when I try to embed a airtable view into notion as I always did (like described: How to Embed a View or Base | Airtable Support) it does not work anymore and just shows the link. Does anyone face the same problems and knows how to solve? Thanks!

Is there any way for Airtable to remember which nodes of an org chart you've expanded? I'm using the org chart extension for a large org (> 1000 people).Every time I reload the extension, it collapses every node, which requires me to click hundreds of nodes to restore the org chart to the state I need.

I'm making a new base for personal use.  I want all the tables in the base to have the same cells.  I created the first table and copied it per instructions in the help function.  I created several new tables by pasting the copied material.  Then i realized i needed to change something, so i deleted the new tables, went back and made the change, copied again, and created new tables, but now it will only past the first column.  When i copy it says "copied 30 records", but when i paste, it only pastes 15 (the first column) even though I'm selecting the whole thing (and yes i'm telling it to expand).  What did i do that made it not copy and paste correctly any more?

I'm using the YouTube API to scrape video data via the script extension and populate the Airtable. This all works fine until I try and take the "embedCode" parameter for a video to store in the table. Other HTML works fine, but as soon as the `<iframe>` tag is entered, the table throws and error and wants me to refresh it. Doesn't matter if the cell is short text or long text with or without rich text enabled.Is this a bug or some security related issue?Here's the embed code it grabs that causes the error: <iframe width="560" height="315" src="https://www.youtube.com/embed/654laEgXb7k" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>   

Hi, for the first time in my approx. 2 years of using Airtable, I’m finding I am missing records. This has only happened in the past few weeks and it seems tied to something I’m doing, but I can’t figure out if I’m taking an action that is causing it. I will outline step-by-step what I experienced. I have a database of ideas and each is tagged to a particular topic. A colleague and I are working with those ideas, so I needed to copy them from the database and paste them in another program. I created a filtered view for that topic and selected all the records in one column and using cmd+C copied the records, no problem. Later that day, I click on my filtered view only to find that there are no records. I check main view and it seems my records are no longer there - I used my copy to search for a few of them, finding the are completely missing from the database. There is no record of them being deleted in the trash and the undo button does not restore them. There was no pop up warning w

Hi everyone!I am trying to find the right approach to calculate the number of consecutive unattended days at course by a same student.I currently have a "participation" table. It is a junction table with: The date (date field) - The Student (link record)- The Class (link record) - Attendance (Yes / No)Every single day the teacher has the ability to say wether a student attended or not his class.01/March/2023 - John - English lesson - Yes ✅02/March/2023 - John - English lesson - No ❌03/March/2023 - John - English lesson - No ❌04/March/2023 - John - English lesson - Yes ✅etc. etc.I wish to calculate the total of NON attended consecutive days by a student every month for his course.Example above, the answer would be 2.Thank you for your help!

How a collaborator can view only their records

Our team is looking to print records in a 3 page format (could be more in the future). When I first realized that I could set a custom paper size, I set it to the px conversion for 8.5" x3 (2778 px). After ALOT of trial & error I realized that the actual size of the grid was less & so the conversion for 8.5" x3 in landscape had to be 2448 px. I have the margins set at “0” currently. This has worked somewhat, but since there are no visible page break guides, I’ve had to sort of create them by adding free text boxes that serve as headers & footers on each page. I’ve spaced out the distance between top edge & bottom edge of the grid & between each header & footer as best I could, literally, by moving things down 1 space at a time & reviewing in a print preview window. There are 2 challenges I’m having… For some reason there is a lot of extra margin being added at the bottom of the 3rd page. It doesn’t appear that way on screen, but when saving as a PDF, yo

Hello everyone.one of our critical bases got deleted and no one can find it.it was in this URL:airtable.com/apppoE9v0FOCBcCGsAirtable support is not responding. anyone can help me figure out how to fix it?

Context:I have three tables. Customers, subscriptions, and orders. A customer can have multiple subscriptions, and a subscription can have multiple orders. Every time a customer fills out the order form, it is created in the order table. So a 1-month subscription will have 12 orders for the year. I have columns in my subscription table that track the expiry date and formulate the days remaining for the subscription. This way, I can automate email reminders as the subscription is set to expire. What I'm trying to automate: When I complete an order. I want to automatically update the expiry date for the subscription. This is my thought process thus far. Scenario 1: The subscription has already expired. The customer orders a 3-month subscription. I activate the subscription and mark the checkbox complete on the table. I timestamp when the order was completed / subscription was activated. The subscriptions can be 1,3,6 or 12 months. I need to ch

Hi there - thank you for your comments and help in advance.My setting: I have 2 tables in one base, containing product information.My goal: to enrich one table (main-table) with the details of the other table (detail-table).context: The main table contains the product name (e.g. Solvent black 27). The detail table contains that name as well (Solvent black 27) - but additional details, like e.g. color index.How can I enrich the data in the main-table with further details of the detail-table.I tried to do a lookup, of course, but the I dont find a way how I can ensure, that the lookup field always has the same name as the name of the main-table.To make it more understandable: In SQL I would be a "clasical" join.Thank you for your support

We are using Airtable to inventory and create our perfume formulas. We have one Base for the Working Formulas. We would like to create a table that automatically creates a record whenever a new table is created in the base. This way we will be able to track its progress, etc. Is that doable or should we just create the records manually?