Other Questions

Hi Community - probably super simple, but I have looked through and done searches but I still can’t figure it out. I’m using DATEDIFF to find the number of days between two rental dates, but it is not counting the end date, ie hire date of 12-Apr thru 16-Apr counts 4 days, not 5. I think the same goes for outing weeks too. Any solutions please? Thanks,

The option to specify a card cover field seems to make that field appear in the gallery view when a card is clicked, even when the field is hidden. This seems like it might be an unintended. Obviously it’s not a concern over the attachment content being shown since it’s displayed as the card cover, but it seems unneeded. It’s also weird that it says “hidden field” but is still shown. Wondering if I’m just missing something…

Is there a way to hold zapier activation while I finish all the new record fields? I have managed creating a new view which is filtered to have the last field filled so that zapier takes it as a new record. Is there any way I can avoid this? Thanks

i am looking to create a simple formula , i say simple even though i can do it . :rofl: :rofl: but here we go if column Fab pack issued is not blank ( or fab pack issued in full is selected ) i want area value indicated in formula column can someone please help me

Being able to paste images into a rich text field is very cool. We do this all the time in our GitHub issues: This is currently missing from Rich Text Fields within Airtable and kills all my hope of using it in our company :frowning: Are there any plans in the near future? Ironically it works here in the community board :grinning_face_with_smiling_eyes: So the advantages of using this feature in a productive environment must be clear. We also want to include audio and video for bugs and user feedback. Having to tediously create and reference attachments by their filename in a long text is currently something we don’t want to go back to and stopped us from using many other Productivity tools like Asana. Especially with filenames like “Screenshot 2021-04-06 at 16.37.06.png” generated from MacOS and not being able to just “Paste media content from the Clipboard”. Painful.

Hi, I want to create a scenario in Integromat that will get all the records (Customers) in Airtable. How do I design for this? I have tried using “Limit” and “Max number of Cycles” parameters but no matter combination I do, not all records are returned. Updating with screenshots; Regards, Ruchika

Is it possible to send designed emails through airtable? I’d like to add the little social icons (facebook, instagram, google review) at the bottom of all my customer-facing emails to share about their experience and engage with our company. Alternatively, my company uses squarespace to send emails to customers also. Is it possible to integrate with squarespace to auto send emails upon a booking and a job completed?

Looking for someone to come along side our small company to set up airtable based on what we need to happen with automations. Could be weekly work to maintain as we grow our customer base. Please email info@realitycaptureexperts.com

We are new to Airtable. We have some .csv files that get pushed daily to an FTP server. We are hoping to be able to pull those .csv files and the data within them and dump it into Airtable. We are a bit lost of where to start with this automation without using the API ideally. If anyone has any experience with this use case or integration we would love to hear about it.

Hi Airtable Community. I’d like to create a medal tally for a school’s athletics meet where the results are counted by how many Gold, Silver and Bronze each school has. I’d like this medal tally to be automatically updated and sorted when I update an event table, e.g, if I update the winners for the table for 100m event by the school, the Medal Tally would automatically update.

My data consists of 4 tables, each table having a unique ID that is a number. Those numbers are the links between the tables. When I bring it into AirTable, everything is linked properly, but the linked field being a number isn’t of any use when a user tries a search, They need to be able to enter something other than the number of the record to find what they are looking for. If they are looking for something in the linked table with a column of City, they need to be able to search by the city instead of guessing at numbers until they stumble across the right one. A workaround is to use a concatenated field starting with the number then throwing stuff into it that would be useful for searching. I a working on converting it to use just such an approach but there are a lot of multi-instance fields that are a royal pain to convert. There has to be a better way. I know there is something obvious that I am missing.

I have inherited the task of updating and managing Airtable for our group. We have a Google form of data fields that I need to import into an existing Airtable. Or I need to revise/edit the column headings on the existing Airtable. Best approach? Thank you!

I have a field of categories like this: Consulting & Professional Services; Venture Capital; B2B; Enterprise; Intellectual Property; Professional Services Investment Banking; Finance; Capital Markets; Venture Capital; B2B; SAAS Professional Services; Consulting & Professional Services; Venture Capital; B2B; SAAS Capital Markets; Venture Capital & Private Equity; Finance; Venture Capital; Consulting & Professional Services; B2B I want the single (or multiple) select to parse out each individual category. Is there any way for me to do that?

I am using gallery view on my website to display membership profiles. One of the fields is essentially “preferred name” and one is essentially “birth name”.l I only want to show the birth name if the preferred name is empty. Any suggestions?

I would like to display the number of records that I have in a table on my website. I know I can do this manually, but I would have to keep updating it manually and was wondering if there was an automated way. For example: “567 products and counting!” Where the number 567 is the number of records (rows) in the table that updates automatically when records are added. Is this possible with javascript or something?

I am new to Airtable and would like to be able to use Vega-Lite to add charts to my dashboard but modify them to display the numerical value on top of the column. I have added a screenshot of the chart that Vega-Lite pulls in along with the code. Any help is appreciated.

Hi there, is there any option to edit a single data entry (row) by using a form or targeting it via API? Example: We’ve got 100 data entries / rows relating different 100 people. We’d like to give them the possibility to update their data by their own without having any kind of access to the data from someone else. How could we do this? Thanks in advance!

Hi, there is a wonderful app for Googel Maps. But unfortunately, I can’t use it as a view and share with my users. Can we get Google Maps as a View please? Pretty please?

Hello, I am trying to print a multiple record list from Page Design. I have tried this before and everything was OK. I haven’t changed anything recently but now I cannot see and print the whole pages. There is a two pages list and I can only see and print the first page. The second one is empty and so the list is not full. Please, can you help?

Hello, I am importing multiple values from zapier that are separated by a comma. I would like for them to be imported as an entire column as oppose to multiple values separated by a comma in a single cell. As seen in the image

Dear Airtbale Community, I own an E-Commerce store which makes personalized jewelry for pet owners. I use Airtbale for managing my orders. We used to upload a JPG file for each customization, but we changed some stuff in the backend of our system, so we have to use .DXF for fulfilling our orders. The issue I am having right now is that Aritbale automatically converts DXF to a TXT file and the file is unusable after upload. Is there a way to not convert the file and upload the file as is? Thanks so much Seung Kim

Hello :slightly_smiling_face: I would like to know if this behaviour is normal and how to fix it. Thank you

I need help. I tried to login but all the tab are not loading properly

Hello guys, is it possible to create a field where I have a drop down (multiple select) list where I can also set the number of items, without creating another table to do that? Something like having [chair, table, pen] as choices and the possibility to add the number of the items, (chair, 3), (table, 1) etc. Thanks for helping! PS: is it possible to create a form that references more tables?

Is there a way to create a checkbox grid similar to that of Google Forms?