Ask the Community

Hey everyone,In my databases interface section I have two interfaces containing several list views, that are of course referring to the same data. The first interface is ment to be for typing in data in our planning process and mostly used from desktop devices. The second interface is for executing purposes and is mostly used on mobile devices on location. This interface should be read only.Summarized:When we are in the office, we are planning and typing in data in the first interface. When we are out of office, executing jobs, we log in to our accounts an our mobile devices to read the condensed and important data.BUT:What we are faceing is, that it seems, that within the interface section of our data base alle lists behave the same in terms of a field being read only or being editable.In easy words: When I change the status of a field from read only to editable in one list in the interface section it does this not only in this list, where I am changing it but in all lists, that show

Hello,we have a ticket/appointment form, where we add all relevant team members to the appointment. Now I would like to create a page in timeline form, where I group by single team members and see all the appointments that are assigned to this person.Currently this is the case: I add an appointment through the form and select multiple team members. Then, in the view, if grouped by the Team Members, it shows me for each combination of team members the appointment.  How do I change this, that I see for each team member the appointments?Do I need to create additional fields in the base? Thank you so much for your support!Best,Philip

So a big reason I chose airtable was that it had an app, so that myself and my other user could input data in the field. Except now that I've spent dozens and dozens of hours building something with forms etc, I see that forms don't actually work on the android app...!What's the work around for quick in-field form submission? That's a surprising oversight, and I see people have been complaining about this for years..

Good morning everyone,In my company, I manage the content of all our Airtable bases. We’re on the Team plan, and the 10+ other members have Read-Only access.Interfaces : We provide multiple Read-Only interfaces to make the data easier to view.Scripting Extensions : We use scripting extensions that can manipulate table data (for example, to get the published versions history from one of our tools).Forms : I plan to add forms so team members can interact with some of our base content (for example, to submit development tickets).My questions :Interfaces : If I add an editable field in 1 of my interface to make the large text areas easier to manage, will Read-Only users be able to edit content ? If they do, will these actions incur charges ? Is the logic applicable if i make the entire interface editable ?Scripting extensions : Similarly, if a Read-Only member launches a script that appends changes to a table, will we incur extra charges ?Forms : If a member submits a form that adds conten

It looks like the forms in AirTable have recently gotten a bit of a revamp. Is there a way to add blocks that just contain helper text? I essentially want to include text giving directions and reminders to the form taker as they are going through the form. I know a field can have helper text added, but for the form I'm creating, there are certain pieces of info/reminders that aren't necessarily directly related to a specific form field question, but it's info that I still want to remind the form taker about. I can add it as helper text, but it won't flow as well.

Hey everyone,I think I’ve raised this before, but unsure if there’s a workaround …It seems from a record template, you can’t add an assignee to a task, who doesn’t have base access permissions? I guess the logic is that they won’t be able to view the task in the base?Similarly, if you have 2 views, eg) Admin and Tasks, with views of the same list of tasks, you can’t assign a task to someone in the Admin view, that only has access to the tasks view, even though they’re the same tasks?Any thoughts / experience with this? The main pain point is the Record Templates assignee field, as we can’t fully automate assignees in recurring project tasks, so they need to be manually added / an automation created.

I know a few years ago it was not possible, but I'm curious to know if anything has changed. I have a long form that I'd like to split into multiple pages. Is this still impossible to do in Airtable? Is my only solution to use an external service like JotForm?

Hi, I have connected Jotform with my Airtable. Everything works perfectly fine. Information was able to save on Airtable appropriate. I chose the E-signature widget on Jotform, is there any way I can save it on Airtable as an image? or what should I do with it? Any suggestion？

I see there have been a handful of posts pertaining to e-signatures in AT forms, but I decided to add another one since the most recent seems to be from 2021 and we know how fast things change in this space. My specific use case revolves around credit card authorization forms. As we rebuild our company website, one request from the CEO is to add an embedded form to our site. As it stands we use Adobe to create an editable PDF however I don’t currently have access to our login to explore what a logged-in admin sees when receiving a completed form. Currently we send the editable PDF form to clients via email. Most clients…it’s an old school industry, then print it, fill it out, scan it, then email it back. We then scan and file the hardcopy away. In my mind the ideal flow would be to embed on our site, allow user to fill it out with esign, and have submissions stored in a table somewhere (either adobe or AT) Any advice is appreciated.

Hi Airtable Community!I’m trying to set up a formula that will convert a printed price to its digital price equivalent, but the rules for those calculations are wonky. I was able to successfully tell the formula that for items under 10.99, it should subtract 1 or 2 from the printed price (depending on the original format), but my attempts to code a SWITCH clause for any titles over $10.99 (and thus subject to a specific price grid) are just returning empty values.I’m trying to argue that if a book is hardcover and greater than 10.99, then the digital price from a grid should be swapped in based on the print price. Same for if the book is a paperback, but the grid values are different, so it requires its own clauses.Here’s what I’ve got so far: IF({US Price (Printed)}="",CONCATENATE(""), IF(AND({US Price (Printed)}!="",{US Price (Printed)}<'10.98',{Format Type}="Hardcover"),{US Price (Printed)}-'2.00', IF(AND({US Price (Printed)}!="",{US Price (Printed)}>'10.98',{Format Type}="Har

 Working on row status for projects based on conditional fields pulled from external sources but am bad at formulas. I think I am close. Any help on this? . Issues with greater than zero and start dates in the pastIF( {Effort Current Total Estimate}=BLANK(), 'Scoping'IF( AND( {Effort Current Total Estimate} > '0', {Is Approved} = "checked" ), "Dev Pending"IF( AND( NOW()>{Target Start Date}, {Has Human Interface Impact}= "checked" ), "In Design"IF( {Substate}='Nominate','Intake',IF( {Substate}='Investigate','Engage',IF( {Substate}='Fix','In Dev',IF( {State}='Integrate','Feature Complete',IF( {Substate}='Review','Feature Complete',IF( {State}='Verify','With QA',IF( {State}='Closed','Closed',IF( {Substate}='Review','Feature Complete',))))))))))) 

Hi Community, I would like to create a new record that is automatically linked to a parent record when I click "+ Add record" in the interface detail view of my parent record in Airtable Interface.To try to explain clearly, my database is comprised of two hierarchies in two different tables.Table 1 is "Communications" and contains the parent records.Table 2 is "Web Articles" and contains the child records that are linked to a "communication" record in table 1.When I am in the interface list view of the "communications" table, and click on the details of the "communication" record, I can see my linked web articles (see screenshot 1).The only way to add a new record from here is to create one with a form. If I then try to add a new record (+ Add article), it opens a form to create a new record in the child "web articles" table, but there does not seem to be any way to link this new record directly to the parent record through which I clicked "+add article" in the details view, even

Hi Everyone Does any one know of a formula that could deduce the Week Number in the Year from a given date field? Any help would be greatly appreciated. Stephen

Background: We're a Danish furniture manufacturer using Business Central and need to automate our supplier PO confirmation process. Currently, suppliers confirm via email/phone which creates data entry errors and delays.What We Want to Build:Automatic Link Generation:When new PO is created in Business Central, trigger creates unique Airtable form link Each link is PO-specific and pre-filled with PO data (item numbers, quantities, dates) from Business Central Link expires after confirmation or set timeframeSupplier Experience:Supplier receives email with unique link (no login required) Clicks link and sees only their specific PO details Can confirm quantities, update delivery dates, request changes, or split PO lines across containers Submits form which updates our Airtable baseSecurity Requirements:Links must be unique and non-guessable (UUID-based) No ability to see other POs or supplier data Form submission limited to one-time useBC Integration Workflow:Airtable form submission trigg

Hello ! I’d like to track leads who fill the airtable form embed in my website in order to make Facebook ads. Do you know how I have to set GTM to manage it ? I first created a thank you page but my browser (Chrome) blocks it as a pop up page (perhaps because my website juggles between my domain name and Airtable one ?) and I’m concerned my customers have the same issue. Thank you for your help ! Greg

I’m trying to build a comprehensive marketing ‘universe’ for a company i’m contracting for. I’ve designed a pretty slick content calendar system, but i am really need a way to interface with other stakeholders without giving them full access to airtable. (think PMs, Creative team for creative review etc.) I want to use portals but is cost prohibitive for me right now. Anyone have any work arounds? where I just want to show them a view without inviting them to the whole base as a contributor?

If anyone is interested we created an Airtable Shopify Integration (SyncBase) as we needed it.It instantly syncs your store data both way so you can update your products catalog, received orders to follow your raw materials stocks and do a lot of others importants operations.We planned to create our custom ERP on Airtable and then use this app to received and send data to Shopify.Happy to get your feedbacks in order to improve it!

Hello !this might sound strange but I'm encoutering issues while wanting to allow users to edit or add new records to a list view in an interface. Sometimes the toggle button to allow this just doesnt exist ... this is quite frustrating and I haven't figured out the way out of this. Please help 🙂 See screenshot

Hello! I’m working on a series of budget interfaces for my team members in a university office, and I want them to be able to edit certain fields of their personal budget “dashboards” (not the Airtable Dashboard interface style, just the word they’re using) without editing all of the details...which would open us up to folks potentially messing up other important info by mistake.  Currently we have the dashboards viewable as grids, because they give us the option to have Sums at the bottom of each column, showing folks what their running balance is for each budget category. However, the only way I can seem to get the “edit this column” option is by using a List view, instead of a Grid, which doesn’t calculate the sum automatically. Is there a workaround for this folks have seen? Essentially, I want them to be able to edit some-not-all of the records’ fields, and I want an automatically calculated sum at the bottom of the grid/list/etc. Ideas? (The two images below illustrate what we’ve

Very new to this. Is there a way to create a fill-able form for my employees to fill out and submit. When they submit it, I’d like it to show up as an attachment next to their name in their row. I don’t want to create a new row for each form submission because it’ll add up quick with everyone doing weekly forms. My employees have to fill out a form every week and submit that so I need a way to keep track of who submitted/when and keep them all together. Thank you!

Hi All.  What’s the best way to set up the automation below—either in Airtable’s native automations or in Make—to reliably populate the linked field with the Trade’s subcontractors (particularly struggling to get the list of record IDs), and avoid reseeding after manual edits?Base: Dupl Construction Project https://airtable.com/invite/l?inviteId=invh3YFKHVkgkcl8h&inviteToken=ebe29e4b636f906f9bde46e9282074acf77e1634caac54dee00c188723eac427&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsThe goal:  when a record is added/updated in the Subcontractor Review table and Related TRADE is set, auto-populate Selected SUBCONTRACTORS (link to Subcontractors, multiple) with all Subcontractors linked to that Trade. It should seed once (only when empty) and remain editable and continue to be linked to the Subcontractor table records to create quote requests from the selected Subcontractors (which may be different to the initial allocation) later.What I’ve tri

Hello,I have a table with a file field, there I also have a “file url” field where I add the expiring downlad url of that file. As this url expire after 2 hours, I search for a solution to update this url every 2 hours so it stay available. I tried with automations first : Tried a repetition group but the problem is that all I can do is add the whole list of url (separated with comma) from all the records, i cannot find how to add the url of this record only. For exemple I want to have :File url of record 1 = url 1File url of record 2 = url 2File url of record 3 = url 3 But what I have is :File url of record 1 = url 1, url 2, url 3File url of record 2 = url 1, url 2, url 3File url of record 3 = url 1, url 2, url 3 So I tried with scripts, I found a script extension that work perfectly (its named “Convert attachments to URLs”) but I cannot find how to execute it automatically every 2 hours. So I tried the “run script” option in automations, but it seem I can’t connect scripts from exten

Hello Airtable community! I’ve got a new IF formula that’s giving me trouble - I’m trying to format titles from our database for a distributor that needs the components in a certain order, which changes based on other parameters. To begin with, I was able to set up a statement that only targeted records where the format is listed as “Issue” and then get the root of the new title created with existing fields like so:UPPER(IF({Format Type}="Issue",CONCATENATE({Title w/o Article}," ","#"," ",{CVR A, B, C}," ",{Cover Artists}," ","VAR"),""))That gives me, as an example, MADE UP TITLE #1 CVR A PABLO PICASSO VAR and also returns an empty field for anything that’s not an ‘Issue’. The problem with this formula is that if it’s CVR A, then there shouldn’t be a ‘VAR’ at the end. So I tried to modify that with an IF(AND( statement, and every version I’ve tried breaks down, like this:UPPER(IF(AND({Format Type}="Issue",{CVR A, B, C}!="CVR A", CONCATENATE({Title w/o Article}," ","#",{Issue #}," ",{CV

Hi all, we’re a custom sportswear company using Airtable to track orders. At the moment we have a single line item for each garment ordered, and the numbers of each size. The view is grouped by contract number so we have all garments for each client grouped together. So for example we might have: Line Contract Garment XS S M L XL 1 1875 Bobs Bikes Cycling Jersey 1 2 3 2 1 2 1875 Bobs Bikes Cycling Shorts 1 1 1 3 1 3 1875 Bobs Bikes Cycling Jacket 0 2 2 1 0 My question is whether I can collect this information in an airtable form to auto populate our airtable? I have tried creating a form for this but under Garment it will only allow me to choose one garment, OR I can setup the garment field to allow the form filler to choose multiple garments . But in the former case I can only collect information about

I will not go into full detail because it is exhausting, but I have run into a situation where data written into my base occasionally has a trailing space character, which caused confusion and havoc between airtable and softr over the past 4+ weeks.The extra [space] character is really just typo. But to the naked eye, it cannot even be seen. How can I prevent any trailing [space] characters being written in the future?? Is there a native trim function?