Other Questions

We are setting up a form that will be filled out by campus staff at many different colleges/universities, so there is no one @ domain. We want to ensure that no one submits a non-campus email address, however, so we want to make sure that regardless of the rest of the domain, it ends in .edu. Is there a way to do that ? They won't be logging in or anything, I just need the form to reject anything that ends in .com, etc.

Hello I have a form which accepts email from user. If the entered email is not in master list of emails, then form should highlight this to user and should not proceed with submitting form. Please suggest if there are any direct / workarounds Thanks

Hi all! So, here’s the use case that spurred some thinking… I have a HUGE, monster of a base that is a bit out of control. It contains many intricate rollups that drive some housekeeping/reporting processes. Now that Airtable Sync is available, I’m working on moving those high-overhead processes out to their own bases in the hopes of speeding up the “master” base. One of those processes is a nightly report. The report is driven off of a view in the master base. I synced this view over to a new base, and set up a duplicate of the report. To test it, I’ve been letting it run the past few nights to compare the new version to the current version… and surprise surprise, they are not the same. Current Report: Runs from source/master base, triggered by a zap that runs on a schedule - every night at 8PM a record is added to a table called [Automation Launcher]. This record triggers a script that aggregates the report data, spits out the HTML which is then picked up and emailed by Zapier. New R

Hello all. I am considering Airtable for a product/portal I need to build. I can't glean from the docs and other info how my setup would be billed or if it is achievable so am looking for some guidance. - I manage a database with data relevant to different clients of mine.- I want to share that data with the different customers I have via an interface for a nice user experience. Each client gets a login, and can see the data/projects relevant to them- Those clients then have customers who need to have access to the specific projects relevant to them. Those clients will need logins also in order to access their specific projects - The only action both my clients and my client's clients need to take is updating the status of a row of data (think a list/queue of items to review and approve) I have attached a crude diagram explaining it. Is this setup achievable? How would it be billed? Thanks,Darrell

Hi there, I’m new to airtable! I have a huge list of contacts that I need to categorize. I am using the drop down Multiple Select Field tool to create “Tags.” I have over 2,000 contact and airtable is only allowing me to select one contact at a time. Is there a way to select 100s of contacts and batch them all as the same tag? Thanks! Meredith

me: Can it be? … me: Airtable has no “Signature Field”? no… me: realy? noo… me: joke, right? nope… me: WHY!!! … me: crying :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob:

Hello Airtable Community, I've started building a Project management tool on Airtable for a marketing agency that sells consultants time. The Project management part is quite straightforward even though I believe this might change based on the agency needs and internal processes. However, I am now facing some difficulties to implement the "Time reporting" part to this tool. (bases are connected) : 1 - Project (information regarding customer, start/end dates, tasks, sub tasks, consultants, #total available hours, #total spent hours #nb of tasks completed ...) This is meant to organize projects, track budget and project progress. Projects, are tracking time on related tasks. 2 - Tasks (information regarding the tasks to perform : start/end dates, sub-tasks, status, priority, consultants, predecessors/sucessors, time for the task, time spent on task ... ) these are the main action to perform within a project. Tasks are tracking the time spent on related subtasks. 3 - Sub tasks : (details

I am trying to use Airtable to fulfill Dialogflow requests. I have limited coding knowledge. Wondering if there is anyone who has got this to work? This thread seems to imply it is possible - Create Slackbot for Airtable Lookup.

Dear community, I have a table in which I am tracking multiple records, each has a PDF attached to it. I am trying to create an automated report using Documint that will list all these records. I am trying to attach the PDFs to the Documint Report, but it does not display them. It works fine with image files though. Any ideas? Thank you in advance.

Good morning, what alternatives are there to generate reports or export our views to PDF that are available for the free plan (I know that in the payment plan is the export to google docs). Thank you very much for your support

Hello AirTable Community, I am trying to export multiple AirTable records in one PDF. Concrete case is a list of samples that have several values, I want to create a pdf that will be handed to the lab for testing containing a list of multiple selected records in a nice format, not just a CSV. Are there any tools or extension for that? I couldn't find anything so far. If this is not possible in AirTable, does anyone know a work around? For example exporting a view as CSV and then automatically converting the CSV to the PDF format, maybe in Google Workspace? Or through the interface? Thank you very much!

I know zero about coding, apps, etc. (yes, I can hear you saying “OK Boomer”). I am looking for a basic explanation of what API is (besides what the acronym stands for, which I had to Google), and why I need it to use Airtable. I am trying to use Airtable as a shared resource for a team to track tasks and task deadlines and status. No integrating with cell phones, no accessing data from somewhere else.

I want to copy “Sum” values of grouped fields within a table, and a field’s “sum” value agnostic of groupings. The information exists, I can see it, but there doesn’t seem to be a way to copy the data for pasting into other fields and/or external applications. Currently, I have to visually reference and manually type the sum value to use the data. This is arduous and prone to errors. I feel like I must be missing something obvious…Does anyone know how to perform this basic function? Thanks in advance!

I am trying to create a form to simplify uploading files to a “Lookup” style attachments field. The table we work out of (Table W) consists mostly of lookup fields pulled from another table (Table S), including the attachments field in question. Multiple records are generated on Table W from Table S and we do not want to upload project files separately to every single related record on Table W. The primary field on Table S is a formula field derived from entries within that record. There are no other unique fields that can be used in a form to select a specific record to allow an upload to the desired field. Any ideas on how to make this work? I can’t show any examples of the tables, but I can try to fill in anything I may have missed in my description. This is where I am stuck, we have a few users who are unable to navigate through the linked fields to add the files to the correct place. Asking these users to switch to Table S and then find the correct field for upload may be equally

I’m trying to design an easy-to-enter table or form where people can enter bookings very quickly. The issue is with choosing a date, a start time and an end time. In other software I’ve used - you can tap a 'Start time" field - quickly type 10 or 1030, or 10:30, or 7 or 730 or 0730 or 07:30 and the software sorts out the formatting. (This is 24hr format by the way) I’ve been trying to get something similar in Airtable and got halfway there with DateTimeParse - but it has been choking on 3-digit times (eg 730 for 7:30am). I’ve even done a formula including an IF statement to check the length of the input and try a different format. But frankly these all seem like massive cludges to fix a basic lack in Airtable - either a Time-only field type, or Input Masking - or input format forcing. I should be able to easily choose the correct format for a field and if someone enters a time incorrectly it will pop up a message to direct them to use the correct format (in this case a 4-digit time fie

I need to create form with header and stylings for text and submit button of form is it possible? I wanted to change color of button and font of the text so that i can embed the form using iframe in html pages. tried to custom css in my html pages it doesn’t reflecting the styling changes of the html content generated in iframe of main html pages.

Hello all, I’m trying to figure out a way to randomly generate a 6 digit randomized number for confirmation use on future bookings. So far I’ve come up with using ‘Autonumber’ and a formula to add six 0’s as a prefix. However, I’d like the number to be completely random. Does anyone have any input on how to achieve this or if it’s possible on Airtable? Thank you! Alex

Greetings Everyone, I would like to know if I can copy values from field to another field automatically without using formula or rollup. I have attached the screenshot of my table for your ref. I need to copy the values from the original fields to the helper fields automatically. Please advise. Regard, Thanveer

Based on an earlier post on connecting airtable data to Power BI, some folks, including me, have problems reading Airtable fields/columns that have blank/missing values for some records. Based on an note from a user in the early post, I am able to revise the Airtable M Query code from the Airtable support site (https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query). I added the "List_fields"= line near the end of the query. Now the new M Query can read in all columns / fields of an Airtable table even if they have blank/missing values. Here is the revised M Query. Hope this can be of help to you. let Pagination = List.Skip( List.Generate( () => [Page_Key = "init", Counter=0], // Start Value each [Page_Key] <> null, // Condition under which the next execution will happen each [ Page_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null, // determine the LastKey for the next execution WebCall = try if [Counter]<1 then Jso

Hi guys ! I work in a Shopify ecommerce and we are in the process of integrating Airtable into our environment. We have started to synchronize our data (Products, orders, customers, etc …) in Airtable using the AirPower app. Airtable seemed like the perfect platform until the data limit was exceeded (50,000 for the pro plan). We looked at the business plan but the 100,000 data limit seems very low. We have 63,000 customers right now so we should hit the limit sooner or later. We want to have the orders table linked with the customers table. Do you have a solution so that we can store all our data? Thank you in advance !

how could i use zapier sync the Unsubscribes that can remove the record from Airtable?

Trying to connect Airtable to MailChimp using Zapier but keep experiencing errors that no email address is found. Goal is to enter contacts for local business owners in Airtable and also have them automatically added to our email list. Anyone having good luck using Zapier to update a MailChimp list who might tell me what I’m missing? It appears that when we enter a name of a person in Airtable it’s creating a record, which triggers our zap in Zapier. Well, if the email is not the first thing we enter it seems like it’s too late, the zap is already triggered and the email is not sent to Mailchimp. So my question is how to make a record create zap work where it’s not so quick to send the data that some of the data isn’t there yet.

Is there any way to create a view with specific fields in Airtable, and sync it with Asana so that when a record is added to that Airtable view, a new task will be created in Asana, including those specific fiels from Airtable? I know a premium Asana subscription is necessary to add custom fields to the tasks. But does anyone know a way to sync these fields between both apps? Thanks.

I have a base and a Main View for Selection. I enter the main view and select a few things. The go to the view selected items. the latest selection don't show up and they are not just out of order etc. Going back into the Main View for Selection and then going back to the View Selected Items now shows the selected items. Why do I need to go back and forward to see the selected items. The filed is a tick box in the form which works OK but the view selected only updated on the second enter. Thanks for your help, Peter Wallis

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?