Other Questions

Hi. I have a base with a Table "Projects" with a multiline text field where I add simple updates on the progress on that proiect. These updates are generally brief but vary in length. There will be a lot of them over time.I have that field linked back into the table, where I would like to only show the most recent update, is there any way to acheive this please. Can you format that linked field to display the primary field only to a specific character as a thought?In the longer term I'd like to find a more elegant solution overall as appreciate this is basic but having something in place for the short term was my thinking.RgdsRobgriff

We have been using Airtable as our internal database and have built some simple scripting extensions to update data from our backend. Every row has an Update button and clicking on it runs the scripting extension showing a dialog box which somewhat creates a bad experience when editing multiple records quickly.Would love a feature to set the extension to run in background or to show a small toast showing whether the run was successful or not, rather than showing the entire dialog box again and again.

I’m trying to use a Rollup to create a numbered list of linked records that reflects the order in which they’re linked within a field. I’ve tried a couple different array options but can’t crack the numbering part.

When uploading an attachment, it loads but instantly disappears Does the same thing happen to someone?

Hello Airtable Community,Is it possible for an admin to delete a base in which they are not a collaborator?Thank you,Liz

Hello,I am using page designer to create some forms for my business.  Currently I am taking an image that is embedded in Airtable and putting that as the background to complete the form.  The issue is with airtable moving to all expiring url's I have to adjust this daily which is not practical.  From what I have seen I can do it through google drive.  How can I take an image from Google Drive and use it in Page Designer to avoid my links expiring? Thanks,Zak

Hi! I want to use the Formstack app, but I’m getting this error when I hit the “Create document” button: Similarly, in Formstack, the Merge History shows: I’m signed in to both applications and am not having any other problems in either of them, but something about the integration is obviously not right. I haven’t seen this problem discussed in other posts - has anyone else seen this behavior? Not sure what to try!

HiWhen using the HR base for recruitment purposes, can only set only certain people in the organization to see specific aspects (permission levels) i.e. someone you have recruited and is now internal you would not want seeing who applied for their position; people in mid-level positions, you would not want them to see senior-level positions.  Can you only allow certain people to see certain positions e.g. for shortlisting purposes?Thanks    

Hey Airtable communityWe're a 100% volunteer non profit organization, using Airtable to handle events where we match street artists with underserved communities and local organizers. That means dealing with a lot of images and we're maxing out the 20GB in our Pro plan. With inspiration from John Siciliano's post where he build an image compressor with TinyPng for a single image, I wanted to extend it a bit. A friend tried to add:multi-image iteration,renaming,image resizingmove PDF's to a different cell in the recordand got something put together on top of John's script. However, when it runs, it keeps looping through logs "compress null" and "TinyPNG API failed with status code: 400 and message: Bad Request"He's a bit excessive with his let-variables, but I don't see that being the cause. Can anyone help make the script run properly? Any help will be appreciated.

Hello! I'm creating a check-in form for attendees at events. The goal is to only make one form that links back to an event grid. As events are added to the event grid, they will populate as options to select in the check-in form. Is there anyway to make sure that attendees cannot click past-dated events when using the form? Thanks  in advance!

I'm using a base to track my time on projects/tasks. I use these times to create estimates for clients and to create invoices. It's great to have the built in time tracking in Airtable, but I've made the mistake many times of walking away from my computer or switching tasks only to realize later that the timer is still running.Does anyone have a good solution / workaround for this?I can think of two things that would help this:1. Idle alerts. Most of the time tracking software I've used will alert me if I don't do anything for a specified period of time. If I forgot to stop the timer at the end of the day, the next morning, I get an alert that I've been idle for x hrs and a prompt to keep tracking, stop the timer now, or set the end time of the timer to when the idle period began. Currently, this is particularly tough in Airtable since the Tracker doesn't make distinctions between timed sessions. So if I've worked on a project off an on for days, the whole total

I need some help using an IF statement within a CONCATENATE formula. I have tried many permutations but have just not found the right syntax. I have the following fields: AirtableID CompanyName Project Sub-Project Person In the Name field of a table, I want to concatenate these fields as such: If Sub-Project is not NULL, then Name = AirtableID_CompanyName_Sub-Project_Person Else (Sub-Project is NULL), then Name = AirtableID_CompanyName_Project_Person Here is as far as I got, and I know the syntax is not right: CONCATENATE({AirtableID},’’,{CompanyName},’’,IF({Sub-Project} = 0,{Project},{Sub-Project}),’_’,{Person}) Thanks!

I have a table with a linked record.  I am grouping by the link record, however the show group with no record toggle that shows up for single select is not there.Is there a way to show all groups even without records?

We put orders daily into PROJECT TRACKER.    We have reached our "limits".    Many old orders are not needed anymore.    I can go back and delete items one at a time, but it would save time to search a keyword (bench) and delete all the items with that word or just highlight all the items and delete those.

Hey friends, family, and everythign in between,So, I have a table embedded into a landing page, and like, overall, I am pretty happy with it! That being said, there is usually a footer in an embedded table that says "view larger table" in the bottom right hand corner of said table. For whatever reason, mine doesn't show up. As a workaround, I have implemented a button that brings you to the airtable website view of it, but would like that little footer back in case people need it, or to at least have an option for such both above and below the table. Any thoughts or insights as to why it might not be showing up? Let me know!

Does anyone know how to lock this feature of “view larger version” from embed on bottom row?

All of a sudden my workspace is no longer there. And i have no more bases. Trash is empty. Please help.

Hi there,I am currently using the page designer to create a document I can print to PDF, which works fine. However, in my base I have 2 tables that have identical record names; it's just the content in the records that's different. I have already made the page for one. Is there a way to simply change the table it is referencing without having to completely re-make the page?Thanks.

I have an AirTable Form embedded on my website. But after submitting I get a message saying “You’ll be redirected to https… in a few seconds”, but it doesn’t work and the form returns. I’m receiving the form data in my AirTable, but the user is left confused. I have filled out the settings correctly as far as I can see. Stewart

I’ve setup a beautiful multi-table Airtable database system for one of my clients, and we’ve got 5 different tables that are all linked to each other & working perfectly. :slightly_smiling_face: But now — we’re interested in creating a form where our volunteers can be in the field and submit brand new data into the database. In other words, this submitted data is brand new data that will need to be spread out across the multiple tables & linked across multiple tables. I know that none of this is currently possible with Airtable’s built-in form capabilities, because Airtable forms don’t currently support: Creating new linked records from a form. Adding new data into a linked table’s fields via a form. So, I know that this can’t be done with Airtable’s native form tools. But I’m wondering if anybody has their “personal favorite solution” for automating this process? I’m thinking of a few different solutions, but I was

Hi everyone,I have an automation where all field become empty everyday. So far it's ok. I made a sort by last modification to find the next day all last changes.I try now to sort (please find the attachement) by type (Légume or fruit) when the total >0 but i can't find the solution. When i sort by type, i have all the type first even the articles with total=0 and i don't know how to make it. I tried to group my table by type or multiple sort but i have the same issues.I want to have by type all products wich are not total=0 and sorted by type (fruit or légume)Thank you so much for your help 🙂

As title mentioned, I got maybe 6 sheets in my table and I'd like to share SheetA to Mr.A, SheetB/C/D to Ms.B.Wonder if possible in Airtable?BTW why im looking for this solution is I still need to collect data from SheetA and do some summation in SheetB, but dont want Mr.A to see SheetB and other sheets.

HelloLooking throughout this community for any additional insight on third party applications with AirTable.  In particular exploring better Forms options and capabilities.  Through looking at different program applications JotForm seems good, however limited in the ability it cannot use the linked field option to the AirTable base.  The other option was On2Air which does appear to have an option to link records within its form. Limitations we are experiencing and would greatly benefit our current project and future within the company are:A form that can be accessed by any user with the link and submit directly into AirTable.  Current process is using a Google Form that is manually updated into the AirTable table import feature.  This process is very manual as well as the linked record fields must be completely done manually. A form that allows outside elements, fields or structure to be add

We have created a form that once completed, creates a timecard.  How can I add restrictions to the form that would block someone from creating a timecard under another users name?

I have a script to generate task lists via a button trigger based on the "Create records for multiple templates" script in Marketplace Extensions. I have one extra field added.I have moved everyone in my organization to interfaces and removed them from the base. They cannot click a button to run a script from an interface.I was attempting to change it to an automation. When {Status} is updated, run a script. When I copy/paste the current script, it errors. I know next to nothing about code, so it was really challenging to create the first scenario.I suspect that the input.config are the issues, because there is nowhere to input in the automation. Also, not sure how to create the selected event.Can anyone help me with how to update to work in an automation? It's a major part of our workflow.