Other Questions

Hello Airtable community! I’ve created a table to keep track of a list of background extras on a film. The way the columns are currently set up is as follows: [Character Number] [First Name] [Last Name] [Character] [Scene] [Shoot Day] and so on. Each person is given a character number, and right now I have that column’s field as Auto-number. We already have records input for all characters that will be in the film, and just need to fill in names. The problem is that some people will have multiple characters assigned to them and we don’t know which people or which characters yet. If possible, I’d like to find a formula to assign a subletter to a record’s [Character Number] when a [First Name] and [Last Name] are input into a record that match an already existing one. For example: This is how the list would look before a new person is input 001-----MIKE--------WALLACE-----REPORTER 002-----SONYA-----PARKS---------PROTESTOR 003-----ADAM-------PHILLIPS-----PROTESTOR 004---------------------

I am trying to capture data from Google Analytics with the web clipper and I can’t get the CSS selector to work. I’ve copied the CSS selector from dev tools in chrome. I’ve also tried simply one class name from something I know is unique. None of this worked. I had an idea that it wasn’t working because the text is within a td or a div and not a normal text tag like a or p or span. I tried the class of something in a span tag and it worked. How can I get it to work with something like a td? Open up GA and all of the data is within a table and td’s. I tried div.className and td.className, the full selector and just the single class. I can’t get it to pull. EDIT: I just realized that all of this data is within an iframe on GA - so therefor impossible to pull with the extension. Anyone find a work around?

I am collecting names and photos for a memorial. I have created a form view and embedded on my website. When I use the form form the website everything works fine and the information appears in the grid. But when other people do it nothing comes up. I am desperate as this is a sensitive situation where we need these images and stories for a memorial this week. Please help!

When I sync a table to another database a comma is added in the target field if the source field was a rollup or a formula. Why is this happening and what do I do to fix it?

I have issue when install airtable in React Native project. I import and cofigure like that: Message error: My project enviroments following: react: 17.0.1, react-native: 0.64.0, airtable: 0.11.5

Hey there, I want to create a formula for a that says If {first name} and {email} column exist then put the word yes and if not then nothing Is this possible?

Hi! I currently use Airtable forms and Id like to connect that form with a contract they can sign that will automatically connect to their record. Is that possible? I currently have them rerouted to Jotform after they fill out the form on Airtable but hoping to see if theres a better solution for this. PS - not sure if that was the correct tag for this question. TIA!

hello i am wanting set up a zapier integration where i can add a new record in airtable when i send an email to a zaper address. However I need the attachments on the email to be attached to the airtable record. is this possible? please advise how to do this if it is. many thanks kieran

Can we add a checkbox that allowed “Same As Requestor Name” and “Same as Requestor Email " for the “Requestor Name” to be copied in “Recipient Name” and “Requestor Email” to be copied in “Recipient Email”? I tried automations but didnt work as couldnt figure the mapping of from field to be copied. Thanks

Looking to dynamically pull a specific record from Table 1 to Table 2 based on date. In other words Table 1 has a list of names and dates. Table 2 has the daily meal; what we’re eating everyday. I want to pull what we’re eating everyday (Table 2) into Table 1 by date for each person. I think linked records is the way to do it but I can’t tie the record it pulls from Table 2 into Table 1 by the date. Is there a way around this? I’ve looked in the community but it seems like this is a missing feature of airtable and hasn’t been addressed by the devs yet. Simply putting the daily meal from Table 2 into Table 1 isn’t possible due to other metadata in Table 1 that isn’t relevant to this; just simplifying the example for this post. TYIA

How to not show the list of lookup fields but still be able to lookup, As we will be adding more than 1000 fields to be lookedup into? Thanks

I have embbeded an airtable view in my website. When I’m opening this site I’m asked to klick on button to load the content of the airbase view. Is there a possibility to let the view load automatically when the website is loaded?

I am trying to add hours to a Date and Time field. The formula I’m using is: DATEADD({Flight Date and Time},-{Time Prior},‘hour’) I want the result to be the date and time, X hours before the original date ad time. Flight Date and Time is a date field with time showing in a 12-hour format, and it’s exactly what it sounds like—the date and time of a flight. Time Prior is a number field, and is the amount of time, in hours, I want the transportation to be on-site for the flight. For example, .5 means 30 minutes prior. 3 means 3 hours prior. So here’s what’s happening: Flight Date and Time: 11/10/2022 4:00pm Time Prior: 0.5 Result: 11/10/2022 9:20pm It should be: 11/10/2022 3:30pm (.5 hours prior to the time) Any ideas as to why this is happening?

How do I create report that shows data from multiple tables? This is frustrating. I have been looking for a straight answer. I tried a long time with interface, but not able to pull data from multiple tables. Even look for a Rollup field type, not working for that. Please help.

Is there a way I can create a custom Url for my airtable form? I currently have a website with godaddy and I’m trying to create a subdomain to forward with forward masking of my airtable form. However I keep getting an error message. Does airtable not allow masking or am I doing something else wrong? When I spoke with godaddy tech support they told me to check if airtable would “allow me to set up a subdomain via DNS settings and if they allowed forward masking.”

When using the Airtable field ‘# Number’ Airtable is rounding off my numbers to always end with 000 Why? I’m using the field ‘# Number’ to receive data from JotForm. The data I need Airtable to recieve is the ‘JotForm Submission ID’ which happens to be 19 digits long. A JotForm Submission ID could as an example be: 5044932613496971504 In my integration between JotForm and Airtable the number is synced into an Airtable # Number field and come out as: 5044932613496971000 Why? :-/

I do not have any settings in my android app. Anyone else experiencing this issue? It just shows me my email address, a build code and a link to “Libraries we use”

Hello, I am new to Airtable and want to use it to register information for assistants to an event however although I have managed to load the form builder can´t understand how to publish it. Am I missing something from this tutorial? https://support.airtable.com/docs/how-to-create-a-form-in-airtable

I am attempting to build an investment portfolio tracker. I have it built in Access but am attempting to build it in Airtable due to the lack of web integration in Access. I want to be able to access the database from my phone or any device. I am struggling a little bit with manipulating the data. I currently have multiple bases which consist of single tables of what I call raw data. They are excel exports of transactions. All of these tables are similar in nature where they have a timestamp, an amount, transaction type, and a description. Why do I have them all as separate? Each service uses different terminology, date formatting, and also has variations on the color of the value in the export. By color, I mean positive and negative numbers. For example, one service might say $5 was withdrawn, but another will say -$5 was withdrawn. I am using basic IIf functions in Access to handle flipping the sign. By differing terminology, one service may say “withdraw” while the other s

Hi there, Discovering the incredible power of airtable here so there might be a simple solution i’m just not seeing. If that so, sorry in advance. I have already hundreds of views in my first table and would like to avoid doubling the number of views there. In all tickets i’ve read with similar questions, this is almost always the solution but maybe i missed one. So in Table “SKU” that i use for pricing, first column is my sku name and i would like that column to sync with the first column of my other Table “CSV” that i use to import products to my website. I tried linked records but it seems first column will not allow it. Also, from what i understood, link record will not add a line in my Table CSV if i create a new one in my Table SKU. Right now, I just copy-paste in other bases the SKU but if i can Sync that would be awesome as I would save a lot of time by not duplicating information manually. Can i do that? If yes, how? Thanks in advance AT Community! :slightly_smiling_face:

I am working a field trip application to organize field trips for my school. Airtable is definitely game changer for this! I met a problem on my budget tab: For each grade I have a total budget I can select the trip record from another TAB on a column named TRIPS for each grade The TRIPS cell can allow multiple records from the tab TRIP (if my grade 1 are doing 3 trips, we can select the three trips) I pull the total cost from all those trips. I need to show the remaining budget for each grade by a simple operation: budget - (total costs of all trips) But the problem is that the total costs for each trip are all in one cell. What should I do?

Hello, I’m wondering if it’s possible to limit the fields shown in the Kanban view when a card is expanded? One similar post said that it pulls data to create the Kanban view from the grid listed at the top of the list but that doesn’t seem to work for me when the card is expanded. E.g. I want one Kanban view to show different fields when the card is expanded than another Kanban view, or rather, hide certain fields. Thanks in advance!

Hello everyone My company and I have problems regarding a synced field in our database. When this database was created I guess there weren’t any problems with editing, but now when we go to the source of truth, and when we try to edit metrics, the new metrics doesn’t show in the database. We’ve tried to press "update sync configuration, but yet again nothing happens. Does anyone else experience this problem or have solved it before? See the picture for reference.

Hi, my google api account has billing activated and I don’t see any reached limits on the Google side. Still I’m getting API limit errors on the Maps Block when trying to geocode 4000 addresses (after every 200 or so). Any idea why this is happening? Also you would think if there are such limits on the Google API even on paid accounts then Airtable should be able to slow down the requests. This way you always need to remember to refresh the browser again and again. That’s bad UX. Frank

Hi everyone, I’m using the map block, and have about 5,500 lines to map. At first I tried doing this without setting up billing in Google Developer Console, so naturally I hit the daily limit of ~600 or so and work stopped. So I went and finished my account, added good billing, deleted old expired cards (I read somewhere this can be an issue even if not primary), and went ahead and refreshed the map… stops after a few hits. Still won’t proceed. I waited hours (figuring maybe it takes time for Google to realize your billing is set up), and no dice still. I tried creating a new API Key, then using that new key now that billing is complete in Developer Console, no dice. I checked quota settings in Google API, it’s unlimited per day and 5,000 per minute, yet I can’t get more than ~3-5 out of my remaining ~4700 to complete each time I click to retry. I opened a ticket with Google but I haven’t had a response yet to the details I submitted, they did ask me for code to check why this is happ