Other Questions

Hi! Here is my set up for importing Jira Due dates into my airtable. What am I doing wrong? Jira Due Date Chooser: Is it Formatted Wrong? Airtable Column Jira Mapping

Does anyone have a Web clipper for grabbing book information from Amazon? Title, Book Cover Photo, Author, Summary and Genre? Bonus: maybe length and Age range (for kids books)? I’m creating a free resource for parents and grandparents looking for great kids books and this type of Web clipper would add huge efficiency in the process. Thanks!

Hi - this is maybe a pretty basic question, but after reading through some help docs (e.g. how to link records, using intermediary tables to join many-many relationships, etc), I’m think that either I’m missing something, OR airtable isn’t a good fit for what I’m trying to do. Basically, I have 1 table, the ‘Research Questions’ table, which is populated with 5 columns and 4 rows. Column 1 is a list of Properties. Rows 1-4 each contain a different property: Property A, Property B, Property C, Property D. Column 2 is a particular Feature - let’s call it Feature A. The remaining columns are Feature B, Feature C, Feature D. The intersecting cells are research questions which combined the intersecting Property and Feature. So, Column 2, Row 1 is a research question based on Property A and Feature A, etc. This results in 16 research questions. I would like to duplicate this table into, say, 5 new tables, with each table representing a single interview with a research informant. For each inte

When viewing a record that has multiple tasks assigned to it, I cannot find a way to have a task removed from that view once its completed. I understand that I can filter out completed tasks by customizing a table view, but cannot seem to remove tasks when looking at an individual record. I do not want to delete these tasks altogether… Thanks

Automation keeps shutting itself off after 5 seconds. Tested all the step success all the way through. Trigger: New Google form Submission Action: Find Record based on email Action: Script to format data Action: Create new Record with data and linking to found record Error just says try again no information Airtable Documentation suggests it’s issue with managed accounts so I did a reconnect still no difference. Seems to be the Google Forms connection ideas as to why when the connection works and tests successfully welcome

Hi folks, I’m in the process of moving some data from Google Sheets into Airtable. In the Google sheets I have three tabs. The first two have data added manually. The third tab uses formula to pull through the data from tabs 1 & 2. This formula is working fine in Google sheets, but I get an error message in AirTable when trying to switch the column type to formula. I’m sure it’s something simple, like I’m referencing the wrong fields in the formula, but as I’m a newbie to AirTable, I’m struggling to find a solution.

I am trying to create a hierarchy within one table. The Gantt-view is only getting me halfway there through the predecessors and successors. Unfortunately, the most vital part is missing. When I select multiple predecessors they don’t show up as having one successor. It is only displayed that the successor has multiple predecessors. I know I could fix this with automation but I thought this should be a basic feature. Database wise I prefer Airtable over Notion but Notion has this figured out already. When I select that I want to link to the same table it gives me the option for syncing in both ways. This means I have two columns within one table which update each other. This would be a gamechanger for Airtable!

Hi - As a one person marketing team I use Airtable as my master of record for collateral, etc. The sales team has asked for a central repository for materials. a perfectly valid request and I’d like to use Airtable for this as I don’t want to have to populate yet another tool. So, I thought using a gallery view would be a nice approach and, indeed it is a nice visual layout. It’s a shame that I can’t group the gallery by category, only sort and filter seem to be available. My biggest concern is when a gallery card is clicked, it opens a popup that displays all the fields in the table. Since I use the table for tracking, posting, usage, etc there are a lot of fields, and the vast majority they shouldn’t or it wouldn’t make sense for them to see. All I want them to see when they click on a card is - document title, direct URL and download the file. How can I accomplish this? I’ve tried to create a different grid view, but the gallery always seems to be built off the master grid.

We have a base with many tables and one table is over 100k records. We’re on a paid plan. Today we can’t even add records to tables with only 2100 records. Is anyone else experience ridiculous slowness? Our people can’t work. Trying to determine if it’s wide spread or us.

Hi I understand about giving collaborators “permissions” but the “lowest permission” I can assign a collaborator is a “read only”. How do I configure it so that some collaborators cannot see certain view or fields? In other words only admins and editors can see certain information. Some of the information we have is extremely sensitive and I don’t want this being in the wider domain.

I am building a form that links to another table. I need to search the contents of the table to add the record. The default behavior of a field linked to another table only allows the user to search the records by the information in the first column. But in my linked table the first column is only the last name. I want the user to be able to search other columns, like the first name, county, etc. Is it possible to set a form up so that searching for records in another table searches multiple fields? It appears someone asked this 2 years ago and did not get a response: Finding an Existing record - limited to one field search Product Suggestions When I am searching for a linked record, I can only search if I know the first field (locked) for that table. However, when I start typing, I can see other fields listed in the options for each record that comes up. I’d like to search by those other fields, that will still get me to that linked record, not by just the

Someone with problems of slow access or synchronization with other pages e.g: sites.google, today? Thanks.

Hi, I get a date in a field, using Rollup and Max (value). Now I would like to know the number of day from now, usinv DATETIME_DIFF First column is the rollup with max value. Seem to work since I have a summary MaxDate. Second colum is formula Today, and third is the calculation of the difference between two column before. Formula of column Today Formula of column Calculation Why do I got such an important result, instead of 0 for instance for 12/05/2021 Any idea ? Thank you

I have an issue with data prefilling into my form-view from my gallery view. See below. I have a set of products where I’d like user to be able to shortlist and then go stright into a form where the selected products from gallery views is prefilled in the form as their selections. Kinda like a shopping cart? I checked the scripting api in bubble and it seems we cannot use localstorage or any of the client side caching options. So any other ways to do this? Right now, I can just prefil one product at a time with the request a sample button. Also - while I am here, is there a way to get a nice view of the multi select choice when in the form view? I can only see the below layout when using my form with a logged in user and not as an anonymous web user.

Hello! I’m fairly new to using Airtable but right now I am creating an application where I pull data from a table I created and populate React components with that data. It’s a pretty simple integration and has been pretty straight forward for the most part but the only thing I am struggling with at the moment is pulling an image I stored in a table. I know Airtable has the “Attachment” datatype which is what I’ve been using but it’s been causing me runtime errors every time I try to pull the image for each record. Is there a better way to store and fetch images using Airtable? Is it better to use a third party alternative?

Hi everyone, I want to create a formula that gives the first day of the current month, one that gives the last date of the current month, and one for the first day of the next month. Does anyone have suggestions? Thanks in advance

Hey there. So, I have a base with a table of inventory of devices that includes their IP address. On that table, I already made a button column that where you click on it and it takes you to that device using the protocol best suited for it (VNC, HTTPS, SSH, etc…) based on the device’s type. (The formula was quite scary). These devices are link to another table that lists all the rooms. What I am hoping I can do is consolidate all these buttons to the room in a way that you can simply look at the room and connect to the intended device. I tried to do this via a lookup/rollup on the rooms table, but that got hinky cause I sometimes have two of the same type of device in a room so lookups and rollups return more than one IP. Any suggestions or thoughts? Need more info? P.S. - I wish button labels could be generated with a formula too.

Hi there, Does anyone have experience with the Google Search API? Because the Airtable-internal search in the database can’t do fuzzy searches - in other words : Airtables search does only find exactly written keywords. Pretty old school, so the integration of the Google Search API would be a great solution. Thanks for your support Florian

I’ve seen this question posted here before but since it’s been a while I figured I could bump the topic. I’ve recently been trying Notion, hoping it would solve some of my issues with files, spreadsheets, documents, projects that are spread across multiple platforms (including Airtable) in my digital universe, by trying to collect them all in a single “dashboard” or “launchpad” where I have access to everything from a single place. While initially falling in love with it, there’s just a few things that are limiting and therefore I want to continue using Airtable for the time being. However there is one thing that Notion does really well, and that’s the cross platform design. I recently bought an iPad for an upcoming project where I’ll be using the iPad as a shared device for team members to access the database and other shared tools, and one of the strongest selling points for me diving into Notion was how well it works on the iPad. The tables are laid out exactly as they are on the d

What’s coming in next update and what should be updated or improved. Please everyone help airtable and give some of your precious time and tell all of your suggestions below:-)

I have followed the directions in the helpful support page (https://support.airtable.com/hc/en-us/articles/218151657-Using-Zapier-s-Multi-Step-Zaps-to-find-and-update-records) to find and update records) to create a multi-step Zap to record the “last contacted date” of a particular contact in my Airtable base. The support page says: we can set it up [the Zap configuration] so that the Date of last contact field of our Airtable base gets updated with the Date data of the most recent triggering Gmail, and the Last message field of our Airtable base gets updated with the Body HTML of the most recent triggering Gmail. However, upon running the Zap after following these directions, the message body text in my Airtable base’s record is updated, but not the date of the most recent message. The date of the most recent message always remains the same as the original message from the sender. So, to summarize: the message body updates properly using the Zap, but not the date of the most recent

I have come across airtable as a resource to potentially solve a problem for a project. I am building a wedding car hire website so I want to be able to list all the available vehicles (probably in a gallery view) that can then be filtered so as an example A convertible red car in Nottinghamshire (Type Colour location) Once the list is filtered the client can then tick a checkbox on the cars of interest which would then form the enquiry form where they input wedding date contact details etc. is this possible and what are the steps to do so Thanks

Hi all! I’ve created this to send out emails from formula fields in my base. I’d like to add a BCC that’s dynamic (based on a collaborator field in the base) and a way to add the Attachments in the Attachments columns to my email. Any input? “https://mail.google.com/mail/u/0/?view=cm&to=” & ENCODE_URL_COMPONENT({App: Candidate email}Coach) & “&su=” & ENCODE_URL_COMPONENT({Endorsed Subject}) & “&body=” & ENCODE_URL_COMPONENT({Endorsed Body})

I have a large number of properties in a table (~3000) and am using the Map App to display their locations. When I open the app, I get a very long delay (as it plots each property?). A display top right of the map shows me how many remaining, with the spinning progress wheel. Even when I restrict my app to a filter view with only 100 or so properties it takes quite a while (2 or 3 min). Am I using this wrong? I guess it’s pretty handy displaying only a handfull of locations but how would I use it that way? Also, we’d like to download Street View images and save in Airtable. Possible? I’m guessing this is request and response only. Filter your selected properties into a view, open the app, see what you need. Click Street View if you want, but save nothing? Does anyone in the community have insights into how else to use this app?

I’m working on a new personnel base and I’m having trouble wrapping my head around how to execute a link I’d like to see. Here’s the scenario: I have 1 table of Staff. They are numbered based on the order I would like to hire them to work an event. So, if I need 5 people at an event, the staff numbered 1, 2, 3, 4, and 5 will be called in for the event. If I only need 2 people for the next event, it will still be staff #1 and 2. I have another table of Events. Here I put in the number of staff I need, and I would really like to build a way for it to auto pull and link the appropriate staff members. Any ideas?!