Ask the Community

Hi allI have an orders table, an order line items table and a products table.In interface, i want my staff to make orders using the products table where they 'add product to new or existing order'.So when they click on the product this should bring up order line items form to add quantity, sell price etc of selected product and then either create new order (parent table of order line items) or link to existing order (order ID, vendor, consignee etc)Any ideas? Thank you!

Hi, I want to update the choices a singleSelect field has without adding a new record.I tried this approach, but that yields the following errorTypeError: Cannot add property 2, object is not extensibleHere is the relevant code (MtypeName gets its value from a singleLineText field)let MtypeName = Mtype.getCellValueAsString("Meeting Type") let Types = MeetingsTable.getField("Meeting Type") Types.options.choices.push({name: MtypeName}) I this possible without residing to API calls?If this is only possible using the Rest API, I suppose I cannot use this without providing the authentication details, right ?

I am tracking two kinds of activity related to a list of locations that I keep in a table called LOCATIONS. One kind of activity (programming) has very specific dates. The other kind of activity (development) is hard to pinpoint in time so I do not want to assign specific dates, but I do want to know what calendar and fiscal year activity is happening. My question is, should I create one table for all location activity, so I can see it all in one place for each location (when grouped by location), or should I create two tables and then look at my LOCATIONS table to see all linked activity? Or maybe just track development activity in the LOCATIONS table? Thanks!

In the form I'm building, I need to list a field where the user can upload a picture or pdf or document or file. Is there a form building extension that does this or an Airtable trick?

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).The bit I'm struggling with is doing this with lots of IF formulas in the same formula field. (I need about 47 different dates each returning their own specific text. Is this the easiest way to do this or am I missing a trick somewhere? Thanks in advance. 

I've been submitting tests for me event form however there is no restriction on being able to put the end date earlier than the start date. Does anyone know how I can remedy this?Thank you.

I have a project management base. I use the in-built Time Tracker extension to track the time spent on each project. I have several ongoing projects, and I work on more than one project each day. It annoys me that I have to select the project from a relatively long list before starting the time tracker, so I am trying to figure out if there is a way to skip that step.I have a table with clients and another with projects (Project name, Authorized number of hours, Time spent, and Time left). Is it possible to use the button field in the projects table to start the time tracker for a specific project with one click on the button in that project's row? Or is there perhaps a better way of doing this?Please feel free to ask if my question is unclear.Thanks,Lene D. Kottal

Is there a way to automatically generate and download/send a pdf of a page designer? Or has anyone found a way to do this with zapier or similar? Our use case: We generate several reports a night which need to be sent to a distribution list. Right now an employee has to manually print as pdf and re-upload it to airtable – after that the automation sends it out. It would be amazing if we could skip that one last manual step.

Hi Airtable Community, Here is the problem I’m trying to solve, I would like to generate a new page designer report based off a new record being created and automatically email updated report. We are updating reports we have published in the work environment on a physical whiteboard so simply sending the record/data elements doesn’t quite do the trick, we want to have a standard look/feel to the report and we are getting that from page designer but can quite crack the code in regards to how to automatically send the report. Open to any ideas or thoughts on how to address this problem. Thanks all. Travis

Hi :slightly_smiling_face: I would appreciate if anyone have a solution… Is there a way to send the document created in page designer field straight to attachment field, rather than manually downloading it and uploading it to Attachment field? Thank you.

J’ai de nombreuses informations à mettre dans le concepteur de page, et ça ne tient pas sur 1 seule page. Comment faire pour avoir 2 pages pour un même enregistrement ?

Hi there Airtablers, I’m using Airtable + MiniExtensions to do a little CSV uploading and processing, and I need to add client approval functionality. This would be via a PDF emailed back to them once a list is ‘approved’ via a limited write-access version of my base via MiniExtensions. Could someone please help me with some code in a code block, along the lines of… if CHECKBOX is ticked --> create PDF in PAGE DESIGNER, then save PDF somewhere useful afterwards. Any help very much appreciated, Airtable wizards! Thanks so much in advance.

Hey there, I’ve decided to venture into trying to achieve my mail-merge in Airtable. Premise: I have pre-written documents written by a lawyer to issue to new clients. (the copy is multi-language but the details of the project and the client remain constant) I would like to synch the client name, and project details into the copy. I’ve read and have tried to make the CONCATENATE approach but I feel it is very messy, and ineffective should the copy change at a later date, it also I will need to weed through the formulas to fix it. I tried another approach of creating a separate table of “parts” that at pulled in as needed, but since they come in as an array it made it tricky for me to figure out how to reference each key of the array. I’d love to hear from anyone who has tried this endeavour before.

Hello there, I’m using Make / Integromat to create Google Docs and upload them as PDFs to Airtable. Occasionally this results (without obvious reasons) in broken PDF files. While the file name is correct, they’re missing a preview, open as blank and are read corrupted in external PDF apps. The automation completes successfully. If I open the Google Docs PDF export link, the PDF comes out alright. This makes me think the PDF file breaks while being imported to Airtable. Is there a known error, fix or workaround to this? I can’t find an indicator to tell the system the file is corrupted (still has regular file size) to let it redo it automatically. Thanks for your input

I have a couple word document templates that are localized on our company's SharePoint.I would like to create a button automation that would connect with Make to generate a letter based off the template and then create a pdf and upload it to the attachment field in AirTable.I am having difficulty in figuring out the right steps in Make to perform this action.   The word templates are in our document library in a SharePoint.   I was thinking of having the button in AirTable interface check off a box in the back end that would trigger the Watch Records in Make to run the scenario.  However, I don't know how to properly generate the letter and do the next steps that follow.Can anyone help?  Or perhaps offer guidance?   If there is an alternative method to generating letters that you prefer that would be accessible in the Interface Designer, I would appreciate it. 

Is it possible to have a shared view link expire or become disabled after a certain time frame? I’d like to be able to automatically expire a link after a week or on a certain date, so I don’t have this link floating out there after the event date or whatever. For example, the form view should expire after the registration deadline. Is this possible?

Hi,I am new to the Airtable forum but been using Airtable for over a year now. I am trying to create a Gantt view with multiple start and end dates for an employee (the employee has multiple contracts and I want to make sure the contracts don't overlap (too much!) with a visual display. Currently I was able to create a Gantt as seen here:The different contracts are highlighted with boxes, are sourced from a Lookup Field (from a separate, linked table) and separated by commas. How can I make the Gantt recognize the start & end dates associated with each contract? Right now it just shows the employee working (this is hidden off to the left side of the screenshot) from the start date of their first contract through the end date of their last contract, even if there are dates in which they are not working (on the top example 7/7–7/11).The Grid View the Gantt is ba

Evening All, I'm building a data structure in airtable to represent a rather large tree style database. We're talking about 50k to 100k objects in the tree. I've got the heirachy view working quite nicely by uploading the components using the api, and then (again using the api) linking the objects with parent/child relationships. The next issue I have is some of the data the objects have. Most objects in the tree have a unique set of data. For example, one might have {colour, size and weight} while another might have {power, consumption}Is there a good way of representing this? The cleanest way I found was by creating another table of this data and then linking it to the original objects, but with 650k data points, this doesn't seem feasible on a large scale.I can add them as generic fields i.e. data01, make it a text type and then put the value in like "colour:Blue", but it's not ideal.Let me know if

I know there has to be a solution for this, but I just haven't found it - trying myself.Pretty Simple I'm trying to make a simple purchase/expense tracking table for the different program team since we're an NPO and have to account for what is spent in the programs as part of the audits, especially with grants.  Each program has a specific budget amount.In excel this is a piece of cake.Fields are that I need to be able Deposit  (Field type Number: Currency)Expense (Field type Number: Currency)Row Charge (Formula)  [Deposit - {Expense Charge}]I now have two fields  that are formulas that I just can't figure out how to make workEnd Balance [{Current Balance} + {Row charge}]Row 1 has End Balance and I want to bring that information into a field called Current Balance which starting Row 2 would auto popu

Hello !I'd like external users (not on airtable) to find specific records in a airtable thanks to a form filtering a database.Ex : I have a dataset of clothes, with criteria : type (tshirt, pullover, pant), prices, size, colorAnd I'd like my customer to be able to tick in a form those criteria (or not), so that I send him (or he sees) a database with only the specific records. ex : he ticks thisrt & pant, between 30 & 60€, M, blue, then lands (or have by email) the list of the 40 products that meet those conditions (among 3K products).Thanks a lot !!!

Having a bit of trouble and would love some insight. I have 2 tables. The first table is a Work Order Table and the second is an Activity log table. In Table 1 I have a button configured to upon click open the form view on Table 2. I have a referenced field in Table 2 to reference the record the button was clicked on table 1. I am struggling with the button url on a table 1 record that will open the form on table 2 and prefill the referenced linked fields. Here is what I have so far:

Why does the logo at the top of the forms always appear so tiny? I have resized and changed image formats and the logo still appears very small. Is this intentional? Can this be changed?Thanks!H.

I have an internal form - how can I remove this line of text under the submit button? Never submit passwords through this form. Report malicious form Thanks!

Hello!We made the request to have the form answers emailed to the respondent optional; however, now I have a person who did not tick the box, who would like a copy of their responses. What is the easiest way to send that to them? I do have their email.Thanks!

My organization has several airtable forms for the public to use, and when a new submission is created, the form sends an email to the creator of the form (someone on staff). That staff person is leaving the organization and those emails need to be sent to someone else. Where is the setting to change this? Thanks in advance.