Other Questions

Hello, I am looking to create a script triggered when a condition is met that opens a static URL and Clicks a Button - or any process that would accomplish the same. My Problem I am using Stacker as for my web-app and Airtable (AT) as my DB. When a field is updated in Stacker, the data is being sent to AT, triggering an AT automation that updates other fields within the same record however, AT is sending a RESULT back to Stacker before the AT Automation is complete. This means the data being displayed to my users is inaccurate and the app not usuable unless I find a workaround. I have contacted Stacker, but they are not able to provide a solution - so, I’m now asking here. My Solution Have a script triggered using a field affected by the automation that opens the Airtable update page in Stacker and presses the “Start Update” button. While this would require my users to refresh the page to see the updated info, its

Hola, me gustaría saber cómo exportar los METAS para un Repositorio. Hello, I would like to know how to export METAS from Airtable CSV for a Repository/ an open digital repositories. Is that possible? ( I am not developer) Any help welcome, thanks. Have a good day :slightly_smiling_face:

Help! Text functions don’t seem to work with a lookup field - FIND always returns 0, SUBSTITUTE always returns “#ERROR!” and so on…

Hi everyone, I’m having a lot of trouble setting up a Zapier-Gmail-Airtable integration. Basically, I want to be able to do the following: Create a PDF of an email that is sent to a holder Gmail account (will only receive the emails that I want and forward to the account); Find a record in Airtable that matches on email or sender’s name Update the record in Airtable I was wondering if anyone has done this particular setup before or otherwise has experience with using Zapier to PDF an email (this is where I am struggling the most). Any help/suggestions would be much appreciated!

Hi, We have a base set up where we track our agents appraisals, listings, sold properties etc. The appraisals tab is currently set to be viewed by everyone however I need to hide it from everyone that has read only access so only administration (editor and above) can see the tab/views. Is there a way we can do this? I can’t remove the agents as we have automations running where I require them to have access to the base and I can’t remove the tab completely from the base because that then affects our agent dashboards in apps. Any advice would be appreciated. Thank you, Sarah

Date Field in Forms is not inputting any values. Please Heeeeeelp!!! My company is losing orders!!!

I can see there are some threads on this. But where is it up too? Is it possible to limit the records a user can see. I work with a number of contractors. When I allocate a project to them it would be good if I could give them access to airtable but limit the records they can see. Ideally when I select the contractor in a field they get access to that record. Is this possible?

I am not able to select a date in the first field on this form: End of Day Report. I have never had issues before and have been using the form for awhile. The issue is only in form view. When I go to grid view, I have no problem inputting data. Any ideas?

I currently have a date as the intitial column in my form. I then have a separate column in which I have been hand entering the previous records date in order to have a third column with a formula to figure out the number of days between those two dates. Is there any way to have this done automatically without me having to hand ender the previous record date.

i have a date field which works ok - except that for no apparent reason it won’t save 4/7/2013. i have tried entering other days in July 2013 using the date picker but nothing. it will save today’s date. On another record (on the same view) the date field is working as it should. Any suggestions?

Hi all, The “+Add or Import” links at the top in left and right in a base header as flashing AND the link doesn’t work. That’s the only place. Any ideas? It’s rather annoying. Uploaded video to youtube: thanks Ben

hello, I am using a field with multiple select (or single select) and I would like in a form to have the capability and select Other and then have a text in order to add a new option Do you know if this is possible ? Thanks

Hi, I am trying to import a google sheet where the one columns is all URLs. In order to make the URL column readable, I made each cell the word LINK and then linked that to the actual URL. To put that into HTML terms, <a href="http://www.airtable.com">LINK</a> (I am not sure how Google sheets stores that internally.) Unfortunately, airtable converts that all into either the tag LINK (with rounded corners and pretty color) or the relative URL “link” if you assign the type URL to the column. I suspect that on import already, Airtable discarded the URL information and just kept the link text? Is there anything I need to tweak this on import to get the desired effect? Going through all thousand rows an hand-unpacking things back to just the URL is not really an option.

I have a unique need and I’m hoping you all have some ideas because I haven’t figured out a solution. I work for an organization who is recording symptoms for a group of people (clients). We also want to record symptoms that volunteers have experience with. Then, the question: How can I compare these two sets of data and find volunteers that have similar symptoms of the clients in order to best matcha volunteer to a client. Not sure if this could be done with an app, a script, junction table, some sort of data export… any thoughts? By the way, I have a whole base for volunteers and a whole base for clients. Thank you so much from me and this non-profit!

Hi, i have two tables. Keywords (2 Views: 1st “All records”, 2nd “Records without topic”) Topics After importing new keywords to the Keywords Table i 'm using a script to link all keywords without a topic to a topic which i define while i’m running the script. The first time i’m using the script - f.e. i’ve just imported 3 Keywords (Keyword 1, Keyword 2, Keyword 3) and after that running the script to link them to “Topic 1” of the Topics Table - everything works as expected. But if i import another set of keywords (Keyword 4, Keyword 5, Keyword 6) and run the script again - again i like to link all of the just imported keywords to “Topic 1” - the first three keywords of the first import gets unlinked from topic 1 and the new imported keywords gets linked to “Topic 1” instead. Seems i’m making a mistake in the script but i have no clue what to do to make it work. Could anybody help me out here? Thanks a lot. Kai

The idea is that on a separate table, I want to calculate sell-through rate. So at any given time, I want to pull up this table, and see how many records I have across all my inventory tables. These are organized onto separate tables based on category. In the next column, I want to be able to calculate the quantity of sales from a particular month within my sales table. My sales table already records the month each sale was made, so I just want the total quantity from the particular month on my sell-through rate table. Any ideas?

Hello - I am trying to use the CREATED_TIME field in a formula and am getting a different date: Created time field show Date format as Local 2021-01-30 9:59pm When I use this in a formula: FirstName &" “& LastName &” "&DATETIME_FORMAT(CREATED_TIME(), ‘YYYY-MM-DD’) it shows FirstName LastName 2021-01-31 I’d appreciate any insight on why these dates are showing as 2 different days. Thank you

Hey everyone, I’m fighting with a thing that I wanna do with airtable: Table ‘customers’ holds all my customers information Table ‘orders’ holds all orders with all the order information Table ‘catalogues’ holds all catalogue orders (as they are vastly different from orders) with all catalogue infos. What I want is to have a column on the customers table that shows the last catalogue ordered by it’s catalogue name. This is for example “Winter 2018” and is kept in a select field in the catalogues table for each catalogue order entry. I already have an auto number on the catalogues table and are showing the highest ID on the customers data row but I can’t seem to map a catalogue name to that. So what I need is to lookup that catalogue name from the catalogues table. I am already showing things like last order but it’s way simpler there as I can use the data and use a max() rollup on that. That’s not possible with the catalogue names as they’r

Can someone tell me why my comments would get flagged? No foul language and all i did was point out an issue with another users sample base and it was an automatic flag.

Hi, I’m having trouble using Page Designer. I’m currently pulling from a linked field to create a table with all the relevant items for an invoice. If you look in the attachment, you’ll see that the “Total Due From Client” is all on one line and separated by a comma. I’d love for $900 to sit above $150, on two separate rows, without any comma. Is there a way to design that in Page Designer? I’ve been banging my head against this issue for several hours and I can’t seem to find an answer. Thanks so much for all your help and consideration. Cam

Is there a way to change the appearance of how the linked options show on a live form? During the edit mode the links show more information, which is necessary for the purposes we would like to use this for. I have tried to scour the community for anything similar, but haven’t been able to find anything that addresses this. See below for pictures of what I’m talking about… Live View: Edit View: Thank you!!

Hi, I am wanting to receive a notification to let me know that a due date is coming up. Is this possible?

Hi everyone, i’m trying to set my apps for sending an email after creating a new row on Airtable. Unfortunatly, doesn’t matter how many times i have tried, the mail doesn’t show the image even using markdown. I have tried this or logo512-Bartender-Social-Ricette-Cocktail-Maurizio-Polverini.png both dont work. May you help? Thank you very much

Hey, new to Airtable. Is there a way to get a clickable link from an email in a field? I have a project management template that I am using. In the project description I have several fields, using the “URL” type I paste the unique email link of the format: message:%3CCAPTktyxYeuqfNsDaLDg864AO=b4MawVwSaaBwRRgOSTuWX5fCA@mail.gmail.com%3. This tries to open Safari and it doesn’t link to the email app. Is there another way to do this? (I also tried with a “long text field”.

We have a table of jobs for volunteers to sign up for. Each row in the jobs table represent a ‘job’. One of the columns contains the volunteer’s ID who has sign up for that particular job. The problem is every volunteer creates a personal view filtered to show only their own jobs. Is it possible to create a view (or form, or ???) that automatically filters to the viewing account’s identifier? Thanks!