Other Questions

I have multiple images in an attachment field. In another field, I would like to extract just the URL separated bei , oder another character to export it in a CSV-File. Is there an example of a formula to solve this? Thanks very much for support. Regards, Dan

Is there a way to calculate a rank based on the value of a field? For example, if the field is Total Sales, I can sort in descending order by this field, but can I create a formula that gives me the rank of each person in another field?

Hello :slightly_smiling_face: I would appreciate help regarding my case. I have two bases, Base “A” and Base “B”. In base A I have records that include documents in the attachment field. There can be more than one document in the same attachment field. I want to accomplish that when a new document is uploaded in Base A, a new record is created in Base B including the document that has been uploaded in Base A. This would result in having a new record in Base B, each time there is a new document uploaded in Base A. Does anyone have an idea of how I can make this work? Thank you, Pjero

Can one of you skilled gurus help me with a formulae to convert this: …ttps://steamcommunity.com/id/bitcointrader101/ (dots added at start and ‘h’ removed to stop post covering into embed) (everything up to and including “.com/id/” will remain static - the characters following will vary in type and length) To this please? https%3A%2F%2Fsteamcommunity.com%2Fid%2Fbitcointrader101%2F Thank you

I’m exporting CSV’s from Airtable and have introduced some fields which represent HTML code. This data is imported into wordpress blocks. I need to use commas in the text. Here’s an example: ''&'<p style="text-align: center;">For a local, reliable & friendly service call our <strong>'&Locality&'</strong> hotline today</p>' In this example the software that parses the CSV delimits the data on the , after the word “local” as you might expect (even when enclosed by quotes). No problem, I’ll use the unicode version of “,” which is , and then the commas won’t exist in teh output but will still show correctly when output as HTML … … but no, Airtable does an outstanding job and converts the unicode to a “,” and outputs it in the CSV as a “,” :frowning: It also does the same thing with #comma and other variants I’ve tried. Does anybody know of a way of preventing Airtable from “helpfully” changing these codes? Any way of “escaping” them?

Hey y’all – I am working on a local school board campaign and looking to map both the precinct locations in our district as well as our yard sign locations to make sure we’re balancing visibility across the district. I’ve got a Precinct table with address, # of registered voters, # of voters in our universe, etc. as well as a Signs table with address, location type, sign size, etc. I’ve already created an Map app block to display sign locations which is working great, but I’d love to pull in the precinct locations onto the same map block so that we can visualize around those locations. Is this possible? Suggestions on how to do it? My clunky workaround is that I’ve just been adding the precincts in as sign locations and making them a different location type and color coding the markers, but I’d love to have a cleaner experience that maintains the precinct name from the precinct table. I might be overthinking, but would love suggestions!

Ask questions about collaboration, sharing, and permissions.

When I embed a gallery in my website attached PDF preview is blocked by browsers. No problem when previewing in Airtable itself. this only happens when the gallery is embedded.

Hello :slightly_smiling_face: Need help with the Attachment field, please. For some time now I use the attachment field to store images, and I had “show attachments in reversed order.” option toggled on. Now, I want to toggle off “show attachments in reversed order.”, but keep photos in same order. How can I accomplish that without doing it manually, since I have a loot of files and reccords? Thank you, Pjero

Hi, Is is possible to share charts? I can easily share tables view by using the sharable link. But what about sharing apps like ex charts? Shareble from app or do I have to move the shart to a dashboard etc? Regards Kare

I need to create a client bio sheet and would like to customize the sheet to include three bios per page for a specific group of people that have the same tags in our database. Is there a way to do this currently?

How do I ensure that when I make an AirTable entry that it will actually save? I’m pretty annoyed and upset because I’m trying to study the Bible chapter by chapter (I have the free plan for Airtable and so I can put all 1189 chapters in one base in the end) but by the time I was on Chapter 4 (of Genesis) I put all the information I wanted in three different rich text fields and I thought it was weird that no preview was showing, but when I clicked on the entry the information was there. I’ve only worked on this base on my iPad and so I doubt it’s a syncing issue but when I came back to it today to review and continue along with Chapter 5, most of the information from Chapter 4 flat out wasn’t there… Has anyone had this issue of losing rich text formatted entries? Is there a way to get my information back? I don’t understand what’s happening here.

Hello, I am Kim Eunkyeul, a student of the Seoul National University of Science and Technology. I am posting this in hopes that it finds its way over to the head office. I sent an email with same content before but haven’t got right reply. My team is preparing for the “Global Challenger Contest” at our university. Our mission is to visit a prominent company that is managing a low-code system practically and efficiently, and to interview the head programmer (in order to investigate deeply about the low-code program, and to fully understand its current effects and future potential). Furthermore, we believe that through our research and analysis of the low-code program, we will be able to get a better understanding of the advancements or changes for programmers. We found that your tool has an impressive low-code programing system, inspiring us for an interview with the head programmer of your low-code programing system. We believe that when given the chance, you will be able to realize ho

I have 9-10 editors for a team project. Shall I choose Plus version or Pro version? Also, I want edit the field in the airtable, does Plus has the function? Thanks, Jun

I have one table that is a Roster of team members with various fields of data pertaining to each record. This table is imported for certain fields and other fields are manually imputed. The data on each record set has the potential to change at any given point. Changes are done manually. The second table is Synced data from an external source that contains some of the same data that is on the first table. I would like to setup a Validate field (checkbox) on the Roster table, this field will be checked if multiple data points (4 or 5 fields) matches exactly from the 2 different tables. Is there a way to compare this data across 2 different tables and if all matches correctly check the validation box? Additionally, if data changes in the Roster and now is different uncheck the box? Any help would be greatly appreciated.

I’d like to use Airtable to help me speed up the processes of responding to multiple RFP’s. Often a same or similar question is asked on multiple RFP’s. Rather than make a database I’d like to use Airtable to categorize and log the questions and answers that I often re-write from scratch each time. I would like to do a quick search in Airtable and and pull already answered questions or document content and pull it into a blank RFP template to partially automate the response process, and quickly access the questions Airtable database. Is this possible? Has anyone done it? Any know templates to start from? Thanks to you my Airtable Gods! :slightly_smiling_face: (not looking for an approval workflow at this time. may use my CRM for that)

Hello everyone, I am really impressed with Airtable and want to roll it out to our team. However, I want to get some questions answered before presenting. Every job we do has an assigned number to it. I would like to use the autonumber feature in order to assign numbers to our jobs. However, we need to be able to customize this. For example, not starting the autonumbering with 1. Also, we have different prefixes for each type of job. Some of them include MISC, R, and P, and some have dashes. The jobs look something like this: P3765, MISC-377, R451. We need a numbering system to create new numbers so that we’re not duplicating numbers, as this would be a nightmare. Regarding that, I’d also like some sort of error message to pop up if someone tries to manually enter a number that’s already been used. Can the autonumber feature handle something like this, and if so, how? Thank you so much in advance.

Hello- I know I have seen some threads on this topic before. Is there any progress with being able to annotate and comment/draw/add shapes/call outs directly on a PDF. Are there any apps that can support this, I found this, Image Markup - Apps - Airtable Marketplace but don’t look like it’s supported anymore. Anyone know when Airtable will enable this feature for PDF image mark ups? Thanks! Scott

Hi When I create a pdf from page dsigner i get a date and time at the top of the page and a url at the bottom. These are not in the designer view. How do i remove them. Thanks

Hello! Newish to Airtable, sorry. I am trying to sort a table that consists of all of the ISO 19650 Uniclass codes, links below: uniclass-2015 Uniclass 2015 Classification tables in CSV format Uniclass 2015 Classification tables in CSV format https://buildig.com/uniclass-2015/uniclass2015/Uniclass2015.csv The top level includes 12 tables. Each of these breaks down into Groups, Sub-groups, Sections, and Objects. The tables have no entry for Groups, Sub-groups, Sections, and Objects. The Groups have no entry for Sub-groups, Sections, and Objects. Etc. In the dataset there are multiple items with the same Group number for different tables, etc. I would like to reorganize it so that so that each Group has a unique identifier, possibly the titie. Would this best be achieved with a junction table?

Hello the community, I just started to use the Gantt View and I don’t understand something. When I create a milestone with the End date at 05/09/2022, it is displayed on the timeline bar at the top at 05/10/2022. How can I set my milestone to have the same date displayed in the timeline bar at the top (the 05/09/2022)? Thanks in advance Serge

We have an Airtable form accessible through our public website. But we do not know which base or table it was built from. The person who built it is no longer with the company. Without have to sift through many bases and many tables, is there a simple way to determine where this form-view lives?

I pay for a plus account. I would like to allow multiple people on the free account plan to edit the base I created. I want them to be able to add attachments, data, and info. To edit the base that I created as a plus subscriber, do the free subscribers need to pay for the plus plan?

I would like to hide the title of summary. And just to show the value. e.g) "Sum 777 " turn to only " 777 " Thank you.

:bomb: Airtable is dropping public url support for attachment in an upcoming update that will take place in Nov 2022. This basically mean all urls to all attachments uploaded prior to that date will cease to work, and all attachments public leads uploaded from there will only work for a “few hours” (would be great to know exactly how long, by the way). Supposedly being a security update, it’s more of a shitty update, speaking frankly. There are many other ways to achieve a similar result (where security is enforced) while doing it in a smart way that doesn’t hit all customers where it hurts. This will break like all our current workflows using attachments, and makes the nice UI to upload file completely obsolete to us and all our users. For instance, allowing to specify in the Attachment field whether to use a temporary link (and how long) would be so much simpler and effective. So, my take is that Airtable does this on purpose, because this way it forces all end-users to use Airtab