Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 14,402 Topics
  • 40,192 Replies
10000 Topics
K
Kat_LevineNew Participant
posted in Other Questions
Unique array combining arrays from 2 rollup fields

I have 2 rollup fields in a table that are formatted to show ARRAYUNIQUE(values). I am trying to create a formula column that combines these values in an array, and only displays unique values. I was trying to use: ARRAYUNIQUE({Rollup1},{Rollup2}), but am only getting the values from Rollup1 to show up. Help?

3623
R
J
jakesNew Participant
asked in Other Questions
INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND", "message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct

I hope someone can help with this please  Connecting from n8n and I’ve created a personal access token and entered it into the Credential to connect with field, Below is the scopes and access permissions I’ve checked that the Base name and tables are correct  I’m not sure what I’m missing here , will be grateful if someone can assist

768
S
S
SoukiNew Participant
asked in Other Questions
Milestone dependency Gantt

Hi, I’m new to using Airtable. I create a Gantt view when I set up dependencies between some  milestones. I noticed  that in my Gantt view when I have  milestone that is dependent on another milestone, even if I move the first milestone it does not affect the milestone that is dependent on it. however, when a milestone is dependent on a task that has a duration, the change is reflected.Milestone 2 depends on Milestone 1  After moving Milestone1 one day later , Milestone 2 remains due for the 25th. I expected it to move 1 day later    

110
S
K
KnoxMuseumEdNew Participant
posted in Other Questions
Can I have Year (YYYY) ONLY be read as a date?

Hi! I am using Airtable to create an inventory of items in a museum of education related items. The vast majority of the items in our collection only have a year attributed to the item (i.e. class of '89, picture taken 1976, Spring 1935, etc). I am wanting to create a timeline view to show a history of certain schools, subjects, and other grouping criteria. Is there a way to have just a year (YYYY) be read as a date for timeline and gantt purposes? 

803
K
A
AlexW-DPParticipating Frequently
posted in Other Questions
Page designer - dynamic table sizing?

Hello,Am wondering if there is any way to have a table in page designer be dynamic in size?  We would like to use page designer to generate invoices, but some clients have only a couple of lines while others have 15-20.  The biggest current issue are the large invoices that have too many rows to fit into a one-page table.  Right now, it just gets cut off. Is there a way to extend the table to a second page?In an ideal world, my total price, etc. fields would be at the bottom of a table that only is as tall as the number of rows in it, whether it is 3 rows or 30.  Thoughts?Thanks,Alex

484
B
A
AW31_2New Participant
asked in Other Questions
New Form Builder Layout and Design Options

In the new form builder, can you modify the layout for more contrast (other group background colors)/larger text size like in the old one? The old one seemed to have more options to make it easier to read and follow. This current one does not seem to pass accessibility requirements as you can’t change the font and formatting of the questions and helper text as much.

314
Mike_AutomaticN
C
Chef TarikInspiring
asked in Other Questions
roles and permissions

Hi Dear community  I'm building an application for restaurant management And I need to implement roles and permission As the following Chefs can create recipe subrecipes and  menu creation menu engineering Store keeper can handle purchase orders receiving and invoices , inventory Manager or owner access to the dashboard to see reports and statistics  Thank you for helping and guiding me Warm wishes Chef Tarik 

392
T
B
BroNew Participant
posted in Other Questions
Viewing permissions

Hi, my staff are grouped in 3 areas. Central, West and East. Each team has a deputy manager (DMs) and a manager (Ms). It's important that DMs and Ms can not see records of staff that are not in their area. Does airtable allow you to set up granular permissions?Also how can you stop deputy managers seeing the managers or ceo records?Thank you

122
ScottWorld
R
RRiceNew Participant
asked in Other Questions
User permissions changed

Hi all! Did Airtable recently push out an update or changes recently?  Many of my users appear to have lost user admin rights with no change on our end to facilitate that.

141
Mike_AutomaticN
C
cecilia zhangNew Participant
asked in Other Questions
Performing tasks between workspaces

Hi, wonder if I can relate data in different workspaces. Or it will be completely separated?

8210
TheTimeSavingCo
S
Sebastian_CastrNew Participant
posted in Other Questions
Add Masive Options to Multiple Select o Single select

Hi, I am using the Typeform integration and one question (single select) has 750 options. In Airtable: It is possible to massively add options to the single selection or multiple selection. Instead of paste it the 750 options one by one. thanks

1036
K
jasonian
jasonianNew Participant
asked in Other Questions
Why are my bases External?

The bases I create are labeled “External” (even after accepting my Organization's invite) and lack the same functionality as bases created by the Big Boss. Are there currently settings that ensure bases created by users within the organization are internal (and benefit from the functionality associated with our price plan)? Would changing my permissions level from “Creator” to “Owner” make a difference? I guess I’m confused that a user can belong to an organization, yet the bases they create do not. Put another way, in practice, every user other than the Big Boss is individually on the “free” plan and creates only stripped-down “External” bases. I'm told we're in the process of migrating from Teams to Business. Will that remedy this? It doesn't make sense to me that only one person has full functionality, regardless of number of users in the plan. I don't have access to the organization's settings. Are the ones with access simply overlooking something?I appreciate any clarity provided.

263
TheTimeSavingCo
C
Chaya_RuskNew Participant
asked in Other Questions
How to use data from Airtable to fill out fields in a document

Hello! I’m trying to make a templated onboarding document that we can easily update with information fed from Airtable. Here’s the direct use case (Integrations are generally off the table in a corporate security setting): Hire Roster (lives in Airtable, holds new hire data) Microsoft Word/GDoc/OneNote (whatever!) that is complete with specific fields waiting to be fed new hire data, will serve as new hires’ onboarding document. Is there a way to automate the process of filling out a document without manually doing it?

5712
ScottWorld
K
Kyrstin_GravesInspiring
asked in Other Questions
Using a form to filter

I have an excel file that we currently filter by 3 to 4 fields to come up with a price for an item for vehicles. We filter by Year, Make, Model, and then for certain products, we also end up filtering by other parametes, but I’ll use size as an example. I am trying to create a form where instead of having to exit and go to the excel sheet, a person could potentially do the following: Select year → this should provide the filter for the next question and only return Brands for those years When they select a make, it should filter the next question to only show models for the selected brand. When they select model, if there are 2 models, it should bring up the size field for the next question, if there is only one model, it should bring up the ID for that specific model in the next question. After it brings up the correct ID for that model, it should show the only price option for that ID. I know I can import an excel file, but I’m not sure how to get it to let me make a form that filt

386
ScottWorld
Sareyh
SareyhParticipating Frequently
asked in Other Questions
Customizing Airtable form based on user

Is there a way to customize airtable form based on the user. I have a dropdown box that is selected by the person, then it shows the applicable questions based on the drop down. Is there a way to autofill in the dropdown based on the user filling in the form.  I need to keep all of the questions in one form for convenience. What would be the best way of doing this.  The reason I need to do this is because each person is required to fill out a form each month, selecting a name then shows what forms a person has not completed yet. Thank you 

433
TheTimeSavingCo
M
Marcy_KNew Participant
posted in Other Questions
How to Customize Gallery View Card?

Is it possible to have 3 kinds of fields in gallery view on a shared link? To clarify I want - 1- The fields displayed on the card 2- The fields you can see when clicking on the card, that aren’t displayed in the card view. 3- Fields that can not be seen unless you are the owner (i.e. me) and logged in. I’m using Airtable for a coin collection and want to have a field for price paid, but I don’t want that to be public knowledge, yet I want to make my page publicly accessible for research purposes.

183
R
A
Amber_Young1New Participant
posted in Other Questions
Multiple Page Doc in PageDesigner May 2023

What happened to PageDesigner?!?!?! I have been using the same extension for three years to print a two-page per record document. The page is set to be the size equivalent of two, portrait 8.5x11 pages. All of a sudden, yesterday, I opened up the Extension that holds my document and the entire second page was missing. The fields were there, but the white background was missing. I reset the page size to accommodate the length of a two page document. All appeared to be well, but when I went to print it, it only prints the second page of one record in the view. Any insights would be greatly appreciated

307
ScottWorld
J
JonathanBInspiring
posted in Other Questions
Automatic document creation and sharing from Airtable records

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:

10540
P
E
E007Participating Frequently
posted in Other Questions
Printing multiple records on the same page with Page Designer

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???

11310
P
C
Caroline_VNew Participant
posted in Other Questions
Page designer multiple page

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?

6610
P
H
Houssine_SAYARINew Participant
asked in Other Questions
Page designerHow 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 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

216
P
P
Patrick813Known Participant
posted in Other Questions
How to create more than one form in Page designer

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

396
P
K
kaminoanNew Participant
posted in Other Questions
Prefill form with linked entry and disable chaning it

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.

657
ziggypac
B
Brian_RussellNew Participant
posted in Other Questions
Barcode Scanning

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

314
J
Rodney_Beadon
Rodney_BeadonKnown Participant
asked in Other Questions
Sending an Automated email when a new record is received the To field confusing me

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  I have checked the field of the new record and the email address is displayed.. I dont know how to resolve this. Many thanks

385
Rodney_Beadon

Badge winners

Show all badges
Terms & Conditions