Other Questions

Hi there, I am new to Airtable and loving the capability however I thought that it would be simple to display the table that I am creating with particular columns visible in a clear A4 printable document. It is proving impossible or I have to sign up to multiple apps just to do it that is way over budget for the few that I may have to do per month. Basically I just need to print a table with columns visible and an image in each column for my business. It is to show clients what item they are having (for instance and oven) then a clickable link, some sizes/specs etc and then a tick box to approve. I have set it all up but cannot work out how to get this table to print to PDF that is legible and dynamic so the columns arent cutting off half of the images etc. I may only get 5 or 6 lines per page and the document may be around 30pages long, but I definitely need a print option. Page Designer doesnt seem to be the right tool, unless I am mistaken? I am also looking at solutions that can be

I am looking to pseudo-automate a stand-up/status message from about 25-30 people on a team. My plan is to schedule a slack automated message weekly at a certain time that links out to an airtable form. The form is linked to a status collection table that would collect these over time. The person would select their name from a drop down, a general status (choice of 4, linked to single select in table), the projects they’re working on (linked to a projects table), and a few notes fields. Ideally I want to show the latest update from a person. We’d then have another view of this data, filtered to show the updated entries. Currently I’m doing this by using Date of Entry > last seven days. However - the question I have - is there a way to instead simple show the latest record by person? For example currently if a person fills this form out 3 times in a week, the view will show all three records. But I only want the last update from a person.

Hi. I have a google sheet with students roll numbers, names, subjects & marks. My questions is: If I shift all this data to airtable, will it be possible to create a form which can be shared with students. The particular form will have only one field, roll number. Once the student enters it and submits the form, the next page/section they receive their marks for the particular semester. Is this possible?

Hi. I have one large database with clients. At different stages of the sales funnel, different managers interact with the client. I want the manager to be able to see the client card only when he became a collaborator. Is it possible?

Hi Since I assign jobs to our team, I end up getting tons of Airtable email notifications for all the back and forth comments that occur with that job. Is there a setting I can select to ONLY receive an email notification when someone @ mentions me? Looks like current settings only allow to fully turn on or off all email notifications. It would be extremely cumbersome for me to have to go into each task and “unwatch” every one I may have commented on. I’m hoping to fine tune that and only receive emails for @ mentions or when a job is assigned to me. Doable??? Thanks

I am using Airtable to organize/display entries in a video competition. Applicants will submit a video as an attachment in a form, and entries will be displayed on the competition’s website. I’m not able to use Youtube or a similar hosting site. I’m seeking inspiration if this has been done nicely before: Are there examples of using Airtable to organize videos (or other media) to be displayed on a website? To display the videos on the site, I’ve set up a gallery view with the attached videos as a visible field, and embedded it into the competition’s website. I’m interested in learning if there is a better way to obtain a similar display. Ideally, we would provide some kind of comment section, where viewers (not on our Airtable team) can submit questions about the projects, have them displayed publicly, and have someone respond to the questions. Has Airtable been used to organize comments in this way? I could link out to a different site for this (e.g., utilizing Google Docs), but I

I have a list of names of people enrolled in my class. Is there an easy way to place them into randomized groups of 5? Ideally, I could do this to have gender-balanced groups. Any suggestions would be welcome.

I’m trying to create a from that will search within the aitrtable DB anf return that result. I want to embed it to my website. Please help Thanks in advance

Hi Guys, I’m new to Airtable. I recently created a linked table where based on the code it will look up on the second table for a zone. so Centre Country is a formula referring to Centre cut and then I made it as a link to the Zone table Zone is the Value I return from the Zone table It works if I manually type the data in the Centre Country but I want it to automatically refer to the Centre cut and then pull the zone number. Every time a new value comes it doesn’t update. I know I can create an automation to update but is there a way to do without creating automation or using any integrations?

So I have a bunch of projects, in excess of 15. Most of them run for 3-6 months at a time. I want to be able to track gear used on projects and see how much gear I need on upcoming projects. If I enter a new project I enter the start and end date. I use a Gantt to see a global timeline of all my projects, which is nice, but I want to be able to basically go, lets check on November, see how many projects we have, how much gear/operators we may need. The problem is as I have many overlapping projects in November, and only a Start/End date…how do I basically be able to group by month? I tried to create hidden fields for each month, and a formula to determine if the date range for a project included that month, and if it did then I could at least easily count the projects I have for a given month, but certainly there has to be an easier way to do this…? Maybe I’m just overthinking?

Just lost 12,678 records. So, um, how many records can Airtable handle? I thought it was 50,000 for my pro plan. But I had 26,000 going and when I added a sixth field for price, 12,678 disappeared. Using the snapshot took me to someplace where my books are suddenly sorted by publisher when I need them kept in the order they were inputted so I can add the book id numbers my dad assigned to each book in what seems to me a random manner. I think I need to just breathe right now and admit to myself that all the frantic proofreading I did on Airtable for a week (on 8,000+ records) is gone. I’ll have to start again. Maybe I’m venting more than I’m asking a question. Can anyone commiserate?

Hi, folks. We’re about to do a big import, and I was wondering what is the maximum character length of a single line text field. Thanks.

Hey good afternoon, I wanted to create a view that gives me all the records from the Current Month and Current Day in history. So today being October 28, 2020, I want to be able to dynamically pull all the previous years for October 28th. I am sure I could add a month field and a day field and manually change them everyday as a filter in my view but wasn’t sure if there was anyway to dynamically pull the current date to get the historical values for the current date. Thanks in advance for any suggestions.

I would like to have a “Summary Table” of the sum info. That is the totals after grouping. How can this be done easily? Thanks in advance! Mark

Hey! We have created a long list of records and manually edited the order. Now it is only showing from First to Last. How can we go back to view the records by the order we gave them instead of the order of creation? Thank you,

I am able to share my base with other members in Airtable just for viewing the base table. Now I need to share this base with a person in China. Can a person in China access airtable? I think not so the question is how to I share a base ( with attachments) to teh person in china most effectively. I can export to xls but does not capture the attachments, so need to download manually. I will keep trying options, any ideas would be appreciated.

are european based non-profits eligible for discount or covid offer?

Hi, I would like that the customer who fills a form, receive a copy of the filled form. How to do that? thanks jou tarrat

I have three fields in a form. The first two hold a number, the last one I want to appear only if the second number is less than x% of the first number. Is there a way for me to use a formula within the display logic to achieve this?

Hi Everyone My question is can you use Page Designer to design different page layouts for Use within the same base? Eg. I want to issue invoices direct from AirTable. I have sorted that ok and everything is going well so far. Is there a way I can use Page Designer to be able to use the same table as I use for my invoice design to print Say a list of clients overdue invoices or something similar while using the same set of data that my invoices page design is based on?

Hello. I need help. Do you know some way to import to import photos in bulk to a specific field in airtable? Thanks

Hello! Here is the current situation: There is a JotForm used to collect submissions. Each submission will generate a PDF of the submission. My JotForm is also integrated with Airtable. Each submission in JotForm will generate a new record in Airtable. I have an integration with JotForm and Google Drive. Each submission made in JotForm will generate a folder in Google Drive which will contain all attachments as well as the PDF. I would like to have the PDF added to an Attachments column in Airtable. Is something like this possible? Or would I have to manually upload the documents myself for each record?

So I’m running for office. I have my voter database in here. I need to weed out all the voters who have already voted via mail/dropbox. I have the unique voter id number of everyone who has voted and have that as a field in my main spreadsheet. How do I weed those out so that I’m left with just the folks who haven’t voted yet?

Hi there - I am using createRecordAsync and am wanting to know how I can obtain the row ID or other identifying info from the new row that was created without needing to use a time stamp and then text match. Thanks in advance!

Hi there - I have a table where users are taking an attempt or two at a form. I am wanting to first have the script ask for the email to look up which works fine. I am then wanting to have the script choose which ‘attempt’ they would like to do the calculations on. I am having trouble filtering so that I can keep the ID and then push that to another ‘results’ table and still be linked. I can add code but it’s a bit messy and filtering based on text and not maintaining the integrity of the id to relink it. Part 2 Bonus points: I am wanting to create a button text or record so that when prompting, the date and /or session is given. Any suggestions are appreciated.