Other Questions

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?!

Hi friends! I just noticed the “Date” field automatically sets to Month/Day/Year. As a Canadian, this is super confusing lol. Is there a way to set it to Day/Month/Year, or even better, Year/Month/Day? Thanks!

Here is the use case scenario (I LOVE SYNC btw) I have a bunch of micro tables which I use as lists across the Company for different departments bases States Countries Month Number/Name 01-Jan Industry names I don’t care to track back to the micro table who is using them as they are there to cut down misspellings, and keep continuity for how some fields need to be presented. Is there a setting I am not understanding how to make it where the origin table that was shared to sync does not contain all the different entries across multiple tables and multiple bases. The reason I am doing it this way is in Excel I am able to point to one location for a list feature - it is the master list I only need to update and all the spreadsheets that use this list get the new information to be able to utilize. For example Our business is a Movement. We have a CRM - I have a table for each of the following: Contacts, Companies, Communities, Organizations - they all have State/Prov and Country Fields i

Can anyone please help me? Sorting of records by creation date is enabled in the table. Further, the records are grouped by a common feature date range. But the records are not sorted correctly, look at the picture. What have I done wrong?

Hi all, I am hiring a staff member to work with my in my small business. I have a recruitment agency and naturally my database is so valuable to me. I would love to know if there is a way I can stop a collaborator from being able to download the data in my base? What is to stop a person from taking my database (either by copying and pasting or downloading) and starting their own recruitment business in the same, very specialised industry. No harsh comments please — I know I need to trust my future staff and sure I will eventually but in the meantime I also need to protect my intellectual property. PlEASE NOTE: they do need the database access in order to do their job Thanks in advance!

I need to create a view similar to this SQL question: select name, max(date) from xxx group by name; I have no idea how I can do this with airtable. Any help?

Hey there! So, a bit of an interesting request. I’m looking for a way to do a “auto number/autofill style” Date field. I’m usually working at a lot of odd hours and my days really exist from 10 AM - 10 AM in a given 24 hour cycle. With that, the general view filtering methods of view based on “current day” don’t really work well for me- I’ve found some loop holes- but nothing perfect. Given that I also would like to track time/duration data from a lot of my tasks via day/date tagging, I figure its just useful to kill two birds with one stone and tag a pre-set date instead. A caveat being, is that i have tasks going out months in advance, and it would be great to have a way to simply create a pre-filled new record with a descending date based on the previous one. I’m still plugging away but havent come across anything to obvious yet! Thanks!

Hi, I was wondering if you could set up a pivot table in a new table instead of using the app that just visualizes the pivot table but doesn’t allow you to add field to that table. I hope I’m expressing myself clearly. This is the idea: I have a table with properties that have a field with the responsible realtor (table 1) I want a table which lists the realtors and how many properties are linked to each realtor (table 2) in table 2 I want to add fields with for example notes (long text) or a status (single select) This sounds quite simple but I don’t quite understand how this works in Airtable. Thank you in advance!

I have a form that I have the following set up It’s a self serve purchase center. I have a condition - have you ever purchased from our company before if the person selects yes, I show the Sync field that contains all the companies we’ve done business with. User picks their company; I have the fields in the table to auto show through roll-up the full address for that company and the current status of their W9 from us - If I do manual entry through the VIEW in the table but not through the form. I can’t seem to get any way to trigger to show the address information for that Company that was selected in the form so the person can answer the “Is this Correct ?”. In my old days I built this entire form in Excel - so I know it can be done, in some automated way. Thank you in advance for taking the time to read and answer.

I have emailed for help to but thought if anyone is having the same issue. A couple days ago i noticed my form entries werent updating on my base like usual thought maybe just a bit slow so i left it over the weekend but still having problems. I have my form entries linked to my email with automation and can see for ages now not all entries are being populated in my base only some. I have included examples of screenshots so you can see the difference in entries per date in my email vs my base? Anyone know how to fix this bug? Thanks

Hi! I see that from the “link to another record field” type in the grid view I can instead of choosing an existing record, create a new one. However, in the form view, for that same field, the only option is to choose from existing records. Is there anyway to fix this and for the form to have the same capability as the grid (choose existing record or create new record)? Thanks for your help!

I have created a table in a base that includes a rating field (1-5 stars). I am sharing it on a website. However, I want to do the following and not sure if there’s a way to do it. I want to be able to show on the website ONLY the records that have 5 stars and nothing else. I know I can tell the viewer to create a filter but that’s a hassle. I don’t want the viewer to do anything. Thanks.

hi , everyone here’s quick question , can I setting a reply limit of linked record field on form view , linked record field are allow to selected more than one option now but I hope it can change into single select (maximum one option select) (not single select field , still Linked record field but only can fill one answer by user) is that possible ? because not native speaker and I’m worried about that I didn’t explain my situation clearly so please see the screen shot as below : thanks a lots !!! :grinning_face_with_smiling_eyes: