Solved

What are the reasons you would create an additional (new) base for your company’s info rather than store it in another table? We have a lot of info to track but I’m struggling with when to know what belongs in the same base, and what calls for its own base. For example, we have 2 separate production divisions that handle the same kind of work, just on different types of accounts. Clients Jobs per Client Projects per Job that can utilize different internal teams Deliverables for each project Tasks that add up to the delivery/completion of a Deliverable Regarding the users… There is a leadership team above these divisions with the need to see data from both divisions rolled up into one place. This makes me think Division A and B’s work should all happen in the same base. For the most part, the team members within each division are not shared with the other division (although this could change in the future). For this reason, I tend to think Division A and Division B should be in

Table 1 is a list of clients with attributes. The table is as follows: | Company Name | Contacted? | … | … | | Company A | :green_circle: | … | … | Table 2 is a list of interactions with clients The table is as follows: | Contact person | Company Name | … | … | | Jeffe Bezos | Company A | … | … | Company A in both tables are matched together (as in I select from the drop down list the Company Name in Table 2). How would I make the “Contacted?” column in Table 1 automatically add this green emoji, if Table 2 has a match of the Company?

I currently have this: DATETIME_FORMAT({Date of donation}, ‘M/D/YYYY’) & “—” & IF({On behalf of corporation?}, {Donor’s employer}, Donor) I have another field named “Member Donor”. If the Donor field is blank then I want it to pull the Member Donor field.

Hi everyone. We all know the script in the airtable scripting examples to create a running total. The script below is as such: // change these names to pick a view: let table = base.getTable('Marketing'); let view = table.getView('Grid view'); let result = await view.selectRecordsAsync(); let runningTotal = 0; for (let record of result.records) { // change the field names here to adapt this script to your base runningTotal += record.getCellValue('Amount'); await table.updateRecordAsync(record, { 'Running Total': runningTotal, }); } The issue with the script is that it takes the running total from the previous row and adds the number of the current row to create the running total for the current row. I was wondering if there was a way to filter based on linked records. That is: for the current record, you only add the current number to the sum of running totals of linked records. Would anyone know how to do this?

Trying to make a post request to Notion to create a new page. Receiving an Error 400 Bad Request and can’t find the issue. Here’s the documentation - Create a page and script below let payload = { 'parent': { "type": "page_id", "page_id": "my page id" }, 'properties': { "Name": { "type": "title", "title": [{ "type": "text", "text": { "content": "My Page Title" } }] } } }; let response = await remoteFetchAsync(postUrl, { method: 'POST', body: JSON.stringify(payload), headers: { 'Notion-Version': '2022-06-28', 'Content-Type': 'application/json', 'Authorization': `Bearer ${apiKey}`, }, }); output.text('**POST RESPONSE**' + ' - ' + response.status)

I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to be GMT. I don’t see a way to correct this because switching the datetime field to GMT for all collaborators produces bogus times that cannot be used for local dates. Is there an operator to add in the formula that corrects the glitch from the source datetime field, or is there a way to “lock-in” the time in the base so that GMT doesn’t muck things up?

I’m using a “record review” layout in interface designer to allow our team to review categories assigned to objects. I can’t seem to make the category field editable in the interface, even though I have no trouble with this for other fields. I’m wondering if you just can’t do that for lookup fields? Background: We have a table with all the items in our system. We also have a form that allows our wider team (who do not have airtable accounts) to assign categories to those items, then a lookup field in the main table to display those category assignments. We want the internal team to be able to use an interface to approve and, if needed, revise the category assignments. I am hoping that the interface can display all the items in the main table, whether they’ve been assigned categories or not, so I picked the record review layout and connected it to the main item table. I can display the category field (which is a lookup field connected to the form table), but I can’t make it editable. An

Hi everyone, I’m working on a table where there are two checkbox fields (yes and no) for each record (employee). I would like to track the total number checked on each checkbox field from all the records. So the total amount of yes and no selected by the employees. There are 100 records (employees) in total. Does anyone have a way to achieve this? Thanks for the help! -S

I saw that there was no solution to this in early 2021 (Is there a way to check if a script is run from a button field or the script app itself?). How about now?

I’m building a credit card base where we store expiration dates. One formula will simply tell us that a card is set to expire (aka when status is “Expiring”) within the month. At this point I have an automation set to email client with expiring card message. Now I’m trying to set up a second automation triggered by a formula field to let me know what the card is now “Expired”. So far this formula works to tell me if the card is Expiring or Valid. IF({Expiration Date}<TODAY(),“Expiring”,“Valid”) However now I want to add an “Expired” status too. Yet when I do this entire formula it doesn’t work. IF({Expiration Date}<TODAY(),“Expiring”,“Valid”), (IF(DATETIME_DIFF(TODAY(),{Expiration Date},‘days’) > 30, ‘Expired’)) What am I doing incorrectly?

Continuing to work on a base for automated emails regarding expired credit cards. @Ben.Young already helped me with a formula field, but now as I take the next steps into automated emails I’ve hit a weird issue. As part of my automated message I want to include a link to our blank fillable Credit Card Authorization PDF. So I found the amazing script for converting attachments to urls, executed the script, filled my new form link field with URLs (formatted as long text), however when I attempt to enter this field as dynamic data in my automation it isn’t showing the URL.

Hi guys! New user here, feel like this should be a simple one but just can’t figure it out. I have a table for Athletes and a table for their AthleteRecords. On the AthleteRecords table each record has an ID, and lists the Athletes schools (HS and College). I have a field in the Athlete table that is set to the ID of the most recent AthleteRecord for that athlete, and I would like to pull the SchoolType field from the AthleteRecords table that matches that ID and set it to a field in the Athlete table. This way I can have a field in the athlete table that shows the athletes “Current School Level” based on their most recent school entry. Thank you for the help I cant figure this one out!

On my view, it shows the form on the left hand side, and I can see that Jenn created it. On Jenn’s view, it’s not showing the form. Help! :slightly_smiling_face:

Hi Airtable Community, I have created new fields and an automation to allow me to automatically send out an email and Teams message 2 days prior to an observed holiday in our Company Calendar table. I have successfully figured out the date when the automation should fire, but now I’d like to take it a step further and ensure that it goes out at 9:00AM EST on the reminder date. Here are the relevant details: I have a formula field called “Remind Today?” that will either be set to “Yes” or “No”. Formula: IF(Category=“Observed Holiday”,IF({Reminder Date}=TODAY(),“Yes”,“No”),“”) ‘Reminder Date’ is a formula field. In the Formatting tab, I’ve selected “Date Format” = Local, Include Time, 12 Hr format, and use the same time zone (GMT) for all users. Automation triggers on conditions: Category = “Observed Holiday” and “Remind Today?” = “Yes”. Since the ‘Remind Date’ field shows a date with time = “12:00am”, I thought the automation would fire at midnight, but it actually fired at 8:52pm t

Hello community! I’m trying to implement a simple badge system within an volunteer program. Basically, when volunteers pass certain checkpoints I’d like to award them a badge e.g. ran workshop X >> badge 1 ten total workshops >> badge 2 The pivot table extension creates a visualization of what I want to do where… row = volunteer name and columns = count of each workshop But I want this to perform this calculation within the base itself (perhaps using arrays in a formula field?) with badges being awarded via once certain conditions are satisfied. If there’s anyone out there that thinks they might be able to help but don’t yet have enough information pls let me know and I would be happy to try and explain further. Thanks very much, Alex

Hi, I am trying to get field names by request in table. airtable.table('Classes').select({ filterByFormula: `SEARCH(RECORD_ID(), "recr0DOF3YWjN9wAH,recwrHZ9zBIYFiU07,rectGHWsZVmkeRwGh,recJKCgej9ihrL2pK") != ""`, }).firstPage().then((data) => { data.forEach((data) => { console.log(data); }); }); In Students I get field ID’s, but I want to get it’s names by one request: I tried to search with select by record names, but it didn’t work. Table structure:

As you can see a formula that generates a date. Also as you can see, no filtering options by date for this formula field. Have tried a RAW and unformatted date in the formula which achieves the same result.

Hi, I have a database of professionals for whom I want to create a formula to search for the appropriate therapist using MAKE There are categories where I want to search all searchable categories, and there are categories where I want to search one or another category. for example- I am interested in looking for a therapist “for children” in the area or “Tel Aviv” or Jerusalem. AND( SEARCH(“children”,{categorys}) OR( SEARCH(“Tel Aviv”,{categorys}) SEARCH(“Jerusalem”,{categorys}) ) ) But apparently the formula is incorrect. Would appreciate help

Hello! I am using the covert url to attachments extension and I’d like to run it every time I do an upload via csv, but only have it go through the newly uploaded records. Right now it does give the option to skip fields that already have attachments in them which is nice, but I have about 30,000 records and a decent amount of them don’t have urls to convert in the first place so it takes a while. Is there a way to only run a script based off a view or conditions? I’m not familiar with JavaScript, but I feel like there should be a way. I’ve attached a screenshot of the extension script, any help is appreciated - thank you!

I’m trying to create automatic due dates for video production timelines. We have different production timelines for different videos - ads and standard videos with a 5 week turnaround time, short form videos with a 1 week turnaround time, and instant videos with a 2 day turnaround time. I want to be able to select a final due date for the video and for the production due dates to calculate automatically based on the type of video. I’ve sort of figured it out - my problem is that the formatting is very difficult to read, and I can’t change the formatting. Here’s what I have: I’d like the due dates to look like a regular date without the time, but it won’t let me choose the formatting when I add the IF statements. Any suggestions? Thanks!

Hi Airtablers, I’d like to turn a normal link into a Rich Text Editor link automatically. See screenshot - “Link” is just text, “Zoom link” is a Rich Text link with the Zoom link as the click through. I’d love to automate turning the Link into a Zoom link whenever a new Link is added. Would this be possible?

Hello, I’m trying to develop a custom extension, but I’m facing an issue. I’ve defined a button associated with action “Open Custom Extension” that points to my custom extension. However in both case, I’m unable to retrieve the recordId of the line of the clicked button: When extension panel is closed When extension panel is opened I’m trying to retrieve the “selectedRecordIds” but upon a button click, it remains empty… Is it possible to retrieve this? Is it possible for the custom extension, that the source event is a click on a button? Thanks, Raphael

Hi team again, I need a quick hand, block with this atm In a table I have the following to fields File - Attachment : It could be an image, gif, video or audio Type - Multiple Select: Details de type of the image based on manually set options (image, gif, video or audio) Any ideas on how to set the Type based on File extension? If you’re wondering, the Type field will be used in a user facing filter to search by file types.

I’ve scanned the forum and I do not see a way to share JUST the view to a specific user in the same way a base or workspace is shared. Am I missing it?

I know how to test for the presence or absence of a value in another field, e.g. IF( MiddleName != BLANK().... But it does not seem to work with a field that should return a number result, when the parameter being fed to the formula is empty. Here’s what I think is the standard Airtable formula for an Age calculation: DATETIME_DIFF(TODAY(),DOB,'years') Works great so long as there is a date in the DOB field. If DOB is empty, on the other hand, this formula returns “NaN” (“Not a Number”). That’s ugly. So I tried IF(DOB!=BLANK(),DATETIME_DIFF(TODAY(),DOB,'years'),BLANK()) But get the same result. Apparently BLANK() isn’t a number value. This wouldn’t be a problem in FileMaker, but if it were, I could coerce the (empty) result to a (non) value of type Number. In FileMaker these are both valid expressions: GetAsDate("") GetAsNumber("") But Airtable doesn’t have a way to do this does it? Something like COERCE(BLANK(),Number) Is there another way to get rid of the “NaN” result in my Age fiel