Other Questions

Hi! When I use the the dedupe extension I can select to exclude a record from the set, but when I run dedupe again another time it’s still there. Is there a way to permanently set a record as not a duplicate so that when I run dedupe I’m only seeing what is new? Thank you!!!

Hello to all, Today I would like to ask you a question concerning the generation of commercial documents, and especially quotes. I have already tested the Documint solution which gives me complete satisfaction for invoice type documents, but not for estimates. In my business, a quote has a section, which describes the items proposed to the customer. This section is a table with 4 columns (description, price, quantity, etc…) A line of this table corresponds to a product. The description column of a product is composed of a title and a long description text. It happens that several products are integrated in the estimate, and thus the estimate contains several pages. My problem is that with Documint, the red header of my product section (descripton - PRICE H.T - Qty - TOTAL H.T) is repeated on a new page, if several products are integrated in the estimate… Documint has no plans to add this repetition function for the moment…W

Hi there! I need a way to effectively view tables from multiple bases together in a “master base.” I was able to sync tables from multiple different bases together, but they are entered as individual tables within this one new base. I am not able to copy and paste them all together into one table because they are synced from an external source (the original base) so editing is not allowed. Essentially, I need to be able to see tasks from multiple projects together in order to view a high-level calendar, due dates, etc. Happy to provide more detail if necessary. Thanks!

I want to calculate a field with the “age” of people in my database from their birthday BUT there are several extra conditions, which makes it more complicated. So I need some help… (A1) For most people I have the birthday (day, month, year), e.g. 27.1.1955 (A2) But for some people I only have the birth year, e.g. 1955 (B) And for some I don’t have any birth date at all. In that case, the “age” field should remain blank. (D1) And furthermore, some people already have died and I have their death day (day, month year). For them I need to calculate the age when they died. (D2) While for some I have their death year. So the formula should calculate the age in years for people. What is that formula? I already got as far as to use this formula: IF({Birthday}=BLANK(), IF( {Died}, {Died}, {Died Year}-{Birthday Year}),DATETIME_DIFF( IF( {Died}, {Died}, TODAY() ), {Birthday}, ‘years’)) It works but not perfectly.

I took a snapshot of a base to update a new month that I was using to scan and validate our inventory with over 5000 records. I tried to create a new record on my ipad to scan a barcode to update the record, but it kept crashing and kicking me out of airtable. I finally had to go to the original base which was a month older to add these new records to capture the data. Anybody have a clue on why this is happening?

Hello, Is it possible to make a push-notification pop up on the APP icon, even when the APP is not open, like happens for emails and other chat apps? (see attached picture ) as written in the guide “These alerts are delivered through email, mobile push notifications and the bell-shaped notification icon in the app” (see screenshot) Unless I overlooked something, this bell-shaped notification icon is ONLY visible if I have the have the app open. It would be very useful to have it visible on the APP icon, ALSO when the app is NOT open. Many thanks ! Leonardo

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

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 “w