Other Questions

Does anyone have any advice for how to create a filtered view of data I have that only keeps the oldest date of a “group” of records? I have a table where a product iD can show up multiple times but have different data for it depending on another unique field (a batch of the product). But, I need to have a view that only keeps the oldest batch. I have a date field attached to each batch. Any ideas?

I have designed a simple table for the dismissal in our school. On one tab I have “Today dismissal” On the second tab I have 25 inputs : each line has a homeroom name and an image attached to the homeroom. The second tab is also attached to the first one. I have then from tab one created a form where we can select the homeroom with a drop down menu. I have also a view that shows ONLY the new entries based on a simple criteria: the date (today). I am then sharing this view so the security guard a the school gate can see from his iPad set up to refresh every 5 seconds the homerooms ready for dismissal and call the parents in. What i would like to do: If i sleeve homeroom x today, homeroom x is not available anymore from the drop down menu just for today. So i can see in my drop down when all the 25 classes have already been selected. The following day, because it’s day+1, all the 25 homerooms are still available in the drop down menu. How can I do

I have a multiple choice single select question and each answer is a couple of sentences long so the end words are cut off. Is there any way to extend the character limits for options? If not, is there a suggested workaround so I can allow my clients to read the full description of the option? Thanks!

Good day everyone! I have data in a table that I want to download to Excel. I’m stumped on whether or not I can arrange it vertically (think excel pivot table outline form) upon downloading it. I would love for the downloaded presentation to be easy to read and I don’t know if that’s possible with Airtable. Any advice or recommendations? Thanks a bunch!

Hi there! I’ve set up the following formula in an effort to show either the data that is entered into the ‘Invoice Contact Overwrite’ field, or if that is blank, then to show whatever is in the ‘Company’ field. IF({Invoice Contact Overwrite}!=BLANK(),{Invoice Contact Overwrite},Company) This formula has been applied to a field called ‘Invoice Contact’, that’s where I want the result to show. In this case, the formula is only showing data that has been entered into the ‘Invoice Contact Overwrite’ field and for anything that doesn’t have any data, it is showing as blank, rather than adding the Company name. Am I missing something? We use a variation of this formula to create a ‘Final Fee’ by showing whatever is in our ‘OS Fee’ field, but if our ‘Fee Overwrite’ field has data entered, then the ‘Final Fee’ is updated to whatever is reflected in the ‘Fee Overwrite’ field. This works perfectly. See formula example below. I

Hello, I’m new at scripting and have, I think, a basic question if someone can please help me. I want automate the creation of pre-filled fields with the script app. I’ve been able to run that successfully for basic ‘text strings’. But now I’m trying to add data to a field that is formatted with ‘duration format’ and I haven’t been able to make it work. The code I wrote was: //Ask for session duration var SessionDuration = await input.textAsync (‘Type the duration of this sessions’); //Create field and fill with duration let CrearRegistro = await ActivityTable.createRecordsAsync([ { fields:{ “DurationField”: Number(SessionDuration), }, } ]); And when I input data such as 30 or 60… the field always shows 0:01. I’ll appreciate any help… thanks.

Hi, I have created a table with fields as Name, Phone Number, Address, etc. And have added data into it. The requirement is I want to create an generic edit form for this table to update the data in it, In this Edit form I’ll be having a text box that takes in Phone number as input and as soon as I enter Phone number .Using the Phone number I added it has to query through the table and find the record having same phone number and fill the edit form with the data of the record that was found. Ex: Now here as soon as I enter phone number, the fields Name and address should fill with the record data that was found with the phone number entered. Is there any way to do this?

I want to change a date field to a create date in a base that already has records in the base. When I do that, all the dates in that field get converted to today’s date. Is there a workaround to have today’s date added to a field when a new record is created without modifying the existing dates in the field?

Hi there, I have given “comment” access to a base to a number of people and pay for that a few hundred euro a month (the base is on a Plus plan). My impression is that most commentators are inactive - meaning I am spending money for nothing. Where can I see that date of last activity per collaborator? Thank you Ursula

I am using Interface Designer but I can’t click it. Is there a way to enable it? If not, @Jordan_Scott1 , this a suggestion for your team. Thanks.

Hi Everyone. I am a teacher and just started using Airtable to create a music curriculum for my students and then want to use the forms view to track student grades and assessment. I have created all my tables and finally created a form view for my assessment grading. When I go to select the assessment I am going to be giving (“Level 1 - Bronze”) I want to be able to see more information about that particular assessment. For example, I want it to also include what book its in as well as the page number and exercise number (all information I have in listed in the table - I can see it when creating the form but then I add lookup fields on the form and they say that they are read only and don’t show up on the form). Basically, I want to be able to select the assessment but see more identifiable info on that assessment when I select it to make sure I a selecting the right one. Any help would be greatly appreciated.

I have a parent table and a child table. The parent table return ids of the child table. I will like to be able with the array of IDs fetch all the data in the child table Thank you

Hi :slightly_smiling_face: I would appreciate suggestions on how to write a formula to return only attachments with the same name. Attachments are in linked record fields. I tried using Rollup with ARRAYUNIQUE(), but it returns all since the URL is different. Any idea how I can accomplish this? Thank you, Pjero

I have the day of payment (PayDay value). and that the next payment will be after 1 month. I need formula which generates date of next payment, In correlation based with today, I have to pay either this month or next (the formula decides) there are some peculiarities If the payment date of the current month has already passed, PayDayToPayDate is before today, then add a period of +1 month to the date. OK I solved my task with US Date Format and it works well no bugs there. But EU is bugged - it increases value of month instead of day value. Am I making a mistake in the formula? My code here US_PayDayToPayDate IF(PayDay,DATETIME_FORMAT(DATETIME_PARSE(MONTH(NOW()) & "/" & PayDay & "/" & YEAR(NOW()), "L"), "L"),"")

Happy weekend all! So I have built myself two awesome automations: Creates 10 tasks for each record added Email me the list of ‘tasks’ for each new record added So when I ran the 1st automation it ran flawlessly! It was #2 that boogered me all up! It sent 10 emails for each new record… each with all 10 tasks listed beautifully! PROBLEM/OPPORTUNITY: The issue I am running into is that the 1st automation is running from where the new record lives. I found that if I add the ‘send email’ option with the same trigger, it emails an empty list (I’m guessing because it is sending the email before the list is populated). I’m sure this is an easy one, but Its been a loooong week already. As always, thanks for your time! DG

We are trying to find the easiest way to setup a date time stamp field, that is, either when creating a new record or triggered by filling in one of the others cells in a new record. that time/date stamp field is populated with the current date and time and it would be static, that is, would not update to tomorrows date if it is accidentally clicked again. What is the easiest way to do this?

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

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