Other Questions

A huge draw back for me of Airtable is its limited Zapier integration - and the fact that it can only trigger on new record (and in view) - I really need this to trigger on updated field / record. I know I can do this with Integromat but don’t want to introduce a new app to my stack. There seems to have been some discussion of this some time ago… but quiet recently - is there another hack or imminent zapier development? Thanks

Hi everyone! I have a table with a list of 6 different release dates - I’m trying to create a field that looks at all of those dates and picks the earliest/first one as “Initial Launch.” IS_BEFORE only seems to work with 2 dates and the factorial of 6 dates is 720 possibilities of combinations so I don’t think I can do a workaround combining multiple nested IF and IS_BEFORE functions. Maybe I’m over thinking this though. I also thought about self-linking and doing a rollup field? Anyway, any advice or recommendations welcome!

Scenario Goal/Context: I have set up an Annual Gardening Calendar for my area for 2021 for the typical earliest and latest frost dates, dates to sow vegetable and herb seeds indoors and plant seedlings and sow seeds outdoors (based on Farmer’s Almanac and local Master Gardening resources). Global warming and local microclimates will move these dates slightly but they tend to trend close to the same dates every year (and can, of course, be refined as specific conditions are observed and/or change). Q: How do I replicate this for each subsequent year to come? I’m sure I must be missing the obvious. There must be a simple duplicate solution but I’m an Airtable Rookie and I haven’t been able to dig up amongst the resources how to copy the calendar for future years while retaining the integrity of the Gantt chart begin and end dates with the respective category fields (and color codes). Please… edify me! THANK YOU!

Hi, Airtable folks! I have a trouble with sharing blocks in Public. I was given a beta feature to share blocks in Public but all of the records are also automatically shared in Public. There is a button saying “Show data” in the top right corner in the shared public page, which I want to hide. Does anyone know how to hide it? If I can’t do it, I want to vote for the feature which we can hide it with.

I am having issues with matching the typeform questions to the airtable: “You can now match typeform questions to specific Airtable fields to easily send answers from A to B” Even when I went to look for the compatible typeform options (Dropdown) to the airtable (Single select or multiple select) - I am still no getting it to work. Any idea’s? Thanks!

hello airtable family: i wanted to ask you about the new button field 1 I have a private and paying community to buy and sell things to us 2 the payments of the things I manage with stripe generating checkouts With the new button field I thought of the following 1 when a person registers and pays the community fee their data is stored on stripe 2 I want to create a base in airtable with the things that are for sale and add the field airtable button 3 I would invite my community to the airtable base so they can buy from there automatically 4 the button on each record I want to be a button connected to stripe 5 when you press the button, it picks up the customer ID of the person who pressed it (which I have saved in another table in the base) and generates in a new view a new record with the customer ID that pressed it (bought) 6 with integromat I will create a scenario where if there is a new record in a view I will gener

Hi! The new Button field is awesome for so many different things and a great addition. I was wondering if there’s a way to have a button open URLs from fields {URL1}, {URL2} and {URL3}, all by clicking the one button? /AT

I have of data that you want to import in one fell swoop and I have a bunch of photos that relate to each record of that tons of data. Whats the most efficient way of getting all the data and images up?

I have a form on my website which also has a single select field in it. There are 5 categories to choose from. How can I send form submissions to table 1 when category 1 is chosen. Send to table 2 when category 2 is chosen. Etc. Right now I can achieve this using Zapier, but I am wondering if this is possible within Airtable without using Zapier? Thanks in advance.

I’m using airtable as a contact database (currently 450 records). This database needs to be mass updated by exported information once a month. Is there a way to mass lookup the differences in one set of data and update the old data with the most recent information? I know you can use Zapier to do this, but it is super expensive. Any tips? We are also wanting to track progress for each contact. For example; John smith is a record that has not taken a course so on his record the course is marked as “No”. Once he takes the course we want to update his record but also see that it was marked as “No” on a certain date. Would love help figuring this one out. Thanks!

Hello, When you shared a view via a private link, you can then filter directly within the url. This is really interesting when this is public information to not be forced to create one view for each field you want to make a share view. It just seems filtering with the URL filter_fieldName=value on “lookup field” doesn’t work. It works on every other fields, but not on “lookup field” Does anyone have a solution to fix that please ? Thanks

I manufacture products, and have a customer that buys several items at once. They are requesting a spreadsheet with one Item and description of each item per row in said spreadsheet. Example: My current base shows the following “3 Pieces of green widgets that weigh 50 pounds each and 3 pieces of red widget that weigh 10 pounds”. The customer is requesting the information to be displayed in a spreadsheet as below green widget 50 pounds green widget 50 pounds green widget 50 pounds red widget 10 pounds red widget 10 pounds red widget 10 pounds Does anyone have a suggestion as how to do this automatically?

hello guys, i am looking for this apps to manage my several projects. i proposing to use table as my “portofolio” and use category as my “project”. I am little bit confusing how to add more category within the table. maybe some of you willing to share your experience in using Airtable to manage several projects and oversee project statuses in a glance. thanks you

I am maintaining a contacts CRM database for my supervisor in Airtable. We imported LinkedIn contacts, however, now with everyone changing jobs, the companies and positions are not updated. I attempted to download the connections from LinkedIn and then do an Import CSV merge so that the contacts can update. Zapier does not have a linkage between LinkedIn and Airtable for this kind of trigger. However, my supervisor has many contacts that have similar last name, first names that are repeated. The Last Name and First Name columns were originally separated, I then tried to combine them with a formula into a new column. When I import the CSV file and try to find the drop down menu for merging, the new 3rd formula column is never available. (I had already formatted the CSV file to have a “Last Name, First Name” column with a space between the comma, etc.) So the CSV cannot find the right columns to merge with. Since there are 1000+ contacts, I did not want to copy and past

Is it possible to access the Base View after clicking on a View only link? In other words, if I send a “View-Only” link in an email blast to people in and outside of my organization, is it possible for a collaborator to click on the view only link and then easily proceed to the same View in the Base? I am thinking of a handy “Go to Full View” button that if clicked checks the users credentials and forwards them to the View in the Base. If this doesn’t exist I’ll move this to Product Suggestions. Thanks!!

Hi Airtable community! I am working on a table that inputs schedules for our contractors. Their schedule is then linked to their dedicated record in our database. An issue arises when they schedule for next week before this week due to the sorting of the linked records. I found a way to sort linked records by the week they’re scheduled for by placing said week in the name of the record that we are linking. I can then order these by the week using the Batch Update block. So that solved my problem, now the issue is that the Batch Update block needs to run every time a new record is inputted into the schedule table. In essence, is there any code I can write in the scripting block that will automatically trigger when a new schedule is inputted that will trigger to run the Batch Update block?

Hi everyone, Having issue embedding my ‘view’ on a Carrd landing page: https://freshtradecaribbean-logistics.carrd.co/ This is the URL link I’m trying to émbed: https://airtable.com/shrXf1BLuH4TomVwP Any advice? Thank you!

My team uses the dedupe block quite a bit. When we open the block, the fields are displayed in a random order. They do not appear in the orderI have them in my table, nor are they in alphabetical order. It would make more sense if they appeared in the same order as they are in the table. Does anyone know how to do this? Thanks in advance for your help!

I’d love help on this. Having trouble with the attachments in Airtable at the moment, so I would love to preview the attachments in either a block or open in new tab (not download). Preview URL doesn’t work as the links are not proper format (Jotform/Zapier Uploads) and we would like to preview resumes without downloading to computer. If there is the basics of a script somewhere, I would take that too! I just need a quick save for this one as the attachments aren’t working and it’s holding up processes. Ever appreciative of any help! Jen

I’m having trouble viewing more than the Title and Date on my quick view while selecting an item on the calendar. Image for reference: How do I add an additional field to view so I don’t have to “Expand record?”

We use Airtable for our own campaign planning, but also have partners that use Airtable for various other reasons. They don’t have shared workspaces or bases, but they use the “share” link (see 1st screenshot) to provide visibility into certain views. Screenshot #1: My question: is there a way for me to save their view somewhere in my Airtable home? I have the view bookmarked in my regular web browser, but it would be awesome if there was a place I could store specific shared views somewhere within my workspaces? I know I could do something with blocks or in a different table or something like that, but it would be great if, just like workspace and block organization, there was also somewhere I could save shared Airtable links (see 2nd screenshot). Screenshot #2:

Yesterday 6/4/2020 a new view chooser (not sure what to call it) popped up. It used to be a simple drop down box which worked fine. Now I have this side panel that pops up and stays there. I hate this… I hate all extra mouse clicks, now have have to do extra mouse clicks to hide this. Any way to disable this?

Is it possible to create a new table programmatically When the table reaches 40,000 rows or when a week has gone by? I don’t want to click anything to make it happen. Planning on doing this for a lot of clients. I can do it in google sheets but I’d prefer airtable.

Hi Airtable fam, I’ve tried everything at this point… After banging my head against the wall for a full two days, I decided to stop being a dummy and ask for help. Full disclosure… I am a complete novice on Airtable, having just started to interact with it about a week ago. In essence, what I’m attempting to do is: Retrieve all the records of one table (exercises) Filter by two metrics (match difficulty of the exercise with a “difficulty selector”, + or - 1 on a different table, AND make sure the required equipment for the exercise matches what the user has, again, on a different table.) Paste the RECORD IDs of the exercises that pass the filter into a field in another table (there are usually about 20-30) I’ve been able to get pretty far down the road on my own using Integromat. The only step giving me grief is step 3… Here’s what my Integromat scenario looks like: Airtable - Watch Records

Hi there I need some help on how to configure dates in BC/AC thanks