Other Questions

Ideally what I’d like is for the “page designer” block to have the ability to share its output automatically with different recipients who don’t have Airtable accounts themselves. I have a large base that is used to process reports that come in from forms. Each record is an individual report, which I can build into printable pdf using the page designer. But the only way to share these is to download each individual pdf and then send it by email. I would like to be able to automate this process, i.e. once a report is complete, the document generated by the page designer is automatically shared with a given recipient. Is this possible through Zapier, or any other platform? I’ve looked at a few google sheets add ons but I’m not sure they’re what I’m after. Thank you in advance for your advice! :slightly_smiling_face:

I followed this tutorial video to the letter (https://support.airtable.com/hc/en-us/articles/115013405168-Page-designer-app-overview) yet Page Designer won’t print/PDF multiple records on a page. My records are short — about one-eighth of a page per record — and I have 25 records. It’s ridiculous that my PDF is 25 pages. Can someone please help me stop the madness???

Hello I am building my invoice template in Page Designer. I was able to build my source table so I can see various tasks to bill to each client. My only isse is that table only show records that fit in the box and in 1 page. How do I format the table element so it show every records I want to show even if it takes multiple pages?

I have a question regarding the page designer extension. How to make the data fields automatically adapt to the amount of data to display and for the extension to create as many pages as necessary? I am setting up a contract. This contract contains a “travellers” paragraph. Under each traveler, page designer displays the information concerning him (package chosen, date of departure, date of return, details of flights, details of accommodation, etc.). The number of travelers naturally varies from one contract to another. There are contracts with 1 single traveler and others with 40 travellers. On page designer the reserved field does not adapt to the amount of data. In addition, we only have the right to 1 single page!! How to solve this problem? Thanks

Hi, Crazy question, but can’t seem to get this. Does the page designer only allow one form? I’ve created a form in the page designer. How do I create a second form, third, or fourth? Any help will be greatly appreciated :slightly_smiling_face: Thanks, Pat

I want to create forms to get reviews from some products I sell and for that I have created a Table which consists of the following fields:Product (linked to the corresponding "Product" record in the "Products" Table)Q1Q2...QnI want to be able to send form links with the "Product" field prefilled (using its RECORD_ID), so that the reviewer can easily know which product he/she is reviewing. However, I don't want the reviewer to able to change that value in the form and select by mistake any other "Product" record. How can disable the possibility of changing a prefilled value in a form?I have tried using the option "Limit record selection only in view" to another view, but it is not working.

It is possible to use a wireless barcode scanner attached to an iPad to enter data into an Airtable. I need to do an inventory of over 17,000 items and want to scan the barcode of each item into a table. It would be much faster if I could just scan the item - record is created - and it advances to create the next record. Much like you can do with a scanner an Excel. I know I could just use Excel and then import it into a table in my base but I was just curious. Using the camera to scan each barcode would not be and option due to time. Thanks Brian

Good DayI have generated a base and from that base a form. Once submitted the form automatically adds the information to the base. When the new record is generated in the base I want to send an email to the person submitting the form. There is a field in the form where the person adds there ID I used that field in the To part of the automation and I am getting an error.  The below is the layout of my  automation In the Body of the text is a member number that is automatically generated when the form is submitted.When Generating a Preview I get an Error Message 

Hello,I have a base and I want to create forms that allow some to suggest new entries into the base. Once the suggestion comes through I would approve it then merge it into the base. However I need to know who that person is and limit access to the form to okta users. Whats the best way to go about doing this?

Feeling a little stupid because I can’t figure out how to do this. It is a simple task on a spreadsheet, but I have failed in all my attempts to get it to work. I am managing a construction project and I have creating 2 tables, One for electrical costs and another for Sprinklers Cost. I then created a third table, which I call it Dashboard. The intention with that table is to show the sums of all costs from the other tables. For example, on the sprinklers table, I have a column (Quote) with all the costs I have incurred so far. I did the same thing on the Electrical table. On the Dashboard table I have created a record for Sprinklers and another for Electrical, and for each record I need to show the sum of the costs for the tables Electrical and Sprinklers As per the images attached, I want to be able to show the value of $14,300 (sum of all costs on the column “Quote” of the Electrical table) on the record of Electrical #200,

Hey guys ! i have an interface for my customer with a form and other data. He wants the form to be prefilled with the same message “long text field” in the interface. See the screenshot. it it possible to do that? and how? Thank you

Hi Everyone, I’ve been searching the community pages and it seems that there is no way to create PDF’s automatically from templates created using Page designer, is that right? I’ve created the field type ‘Button’ to click which displays the document in the page designer app perfectly. But, I then have to manually save it as a PDF. What I’d like, is to be able to click the button and for that document to be automatically downloaded and saved as a PDF file. Surely this must be possible? It just seems crazy that the button can produce the document but can’t save the file. Am I missing something? What do people use the Page Designer app for if not to create documents which they then want to attach and send to their customers? Thanks, Rosa

Our finance department wants to start using Airtable to send out invoices to vendors. Is there a way to place a template invoice somewhere, and then have an automation modify the template pdf with chosen data from our vendors listings with their invoice? (i.e- from template to a customized pdf with their information, amount to pay etc).

I would like to generate a PDF out of a record (to easily visualize the data) and attach the record as an attachment. I would like to do this for all the records in my base. Any ideas on how to do this using either a script or Zapier/Integromat, possible using Formstack (does not have to use formstack though)? Would love any insight - I am capable of coding in JavaScript and can leverage that if necessary.

Hi AllI am new to Airtable…..I have set up a base with all my customer records and imported sales data to populate all my fields.Now that I have new sales data, I cannot import the data to over-write existing data. All I seem to do every which way I try is create duplicate account information with new sales figures.This is really frustrating. I have tried using data from excel, CSV file as well as Google Sheets with the same result.What am I doing wrong???? Any help will be appreciated.

When adding a sync table to our base, we have an option to either “delete the records” or “leave the records” in the destination table when the records are deleted from the source table. See screenshot below for a screenshot of this option. I find this Sync Setting problematic for 3 reasons: It’s not truly a “sync” if the records are mismatched between 2 tables. We have absolutely no way to distinguish (in our destination table) whether or not a record was deleted in the source table. Airtable gives us absolutely no way to tell if a record still exists, or if it’s just a “phantom ghost record” that once existed a long time ago. This is yet another security hole in Airtable. If I delete a record from a base, it’s probably because I don’t want anyone to see that record anymore. Yet anybody who has formerly setup a sync to my table can now see previously-deleted records. From a security standpoint, this is greatly flabb

Is there a way to enable AI Assistant in a shared base view (from the shared link option)? I understand how to use AI Assistant currently as a user with access, but I share a raw database periodically with stakeholders without user access and it would be helpful if they could hit the database with their own queries.  

Hi!  I might just be silly, but is there not a way to copy and paste a status across several records in list view? In grid view it’s easy, just copy a cell and paste. Is there not an easy and quick way to do this in list view?

I manage a small farm, and want to build a better wholesale order system. I feel that what I want to do should be possible with airtable as a backend and an intergrated form builder (and/or using make.com automations), but I don’t currently know what tools to use. So I’ll describe what I’m trying to do, and see if anyone here has some suggestions to get me started. I’ve spent quite a lot of time with jotform and fillout, and don’t think they have a good solution.Ideally I’d do the data entry on airtable, and a form builder would automate a lot of the rest of the process.There are a few things that make the form building challenging:We deal with dozens of products changing each week customers order in different “units” (retailers will order 30x bunches of carrots, a restaurant will order 10kg; a retailer will order 25 bags of salad, a restaurant will order 3kg) customers have different pricing

I’ve made a print designer template with an A4 canvas. Every time I print it, it consistently exports two pages rather than one, and the first is always blank.  I’ve checked for random elements outside the canvas; however, I can’t seem to find any.I tried to shrink down the export, but that does not work either.Does anyone have any idea how I can get rid of the blank page?

Has anyone experienced all of your progress in Airtable Academy disappearing?  Logged in today and all of my completed courses and certifications are gone?

Hey all! We are just getting into using Airtable more across the company and are wanting to connect it with several of our existing systems (Sage Intacct, Workday Adaptive Planning, Asana, DocuSign, Google Suite). We are looking into Zapier, Workado, Make, and Power Automate. Do you all have any experience with any of these? Are there any others worth checking out? Thank you!

I’m looking for a way to track all the members of my teams workload. By that I mean I would like to imput a specific amount of time that they work each day, week, or month and then add the estimated time to complete to each of their tasks. That way I can easily check to see if someone has too many tasks for the amount of hours they actually work, or if someone has un-used time I can schedule specific tasks to them rather than someone who is completely full.

Looking to optionally TRANSPOSE the grid view so that Fields are shown on the vertical and Records across the horizontal. Grounding: I have two particular sheets - one is best presented Fields across / records down but the other requires fields down / records across (for reasons of navigation, data entry and readability. no functional changes, just U/I = transposed grid))

Hi our team uses form view to get status updates from people. We have people table, project table, then status update table that joins things together, and I use a formula to eventually display only the latest update. We’d like to get some finer grain on the update though. For example say we have John, Sally, and Bob giving updates. And we have Project1, Project2. In each of project1 and project2 we have possible categories of work being say, “prerequisites”, “training”, “execution”, “delivery”. Right now our form collects only name & project, and that’s it. But for example if John is working on “delivery” for Project1, we want to know that level of detail as well. I’m having trouble understanding how I could do this in airtable forms. In Google forms the checkbox grid would come in handy. But I don’t know how to to pull this off in airtable. I tried an automation to create records in another table when form was submitted but then I hit the wall of multiple