Shayne_Bundy - profile

Shayne_Bundy · Nov 27, 2022

I have an Automation set up to append items to an existing Rich Text Field, in the format of a checkbox list. The append Automation works well, except it always leaves a line break above the appended item, making a blank line in my list. The Rich Tex...

Shayne_Bundy · Apr 01, 2022

I have a table that is synced from Google Calendar. It seems that by default, the primary field is the Title of the Google Calendar event, but I’d like it to be the Start Date instead. Am I missing a setting; is this possible? Using Title seems like ...

Shayne_Bundy · Jul 30, 2018

I have multiple image attachments in each record, and want to combine them into one image. I realize that Airtable cannot be expected to do this natively, but wondered if anyone had any suggestions for something that would. It would have to read/down...

Shayne_Bundy · Jul 25, 2018

I cannot get DATETIME_FORMAT to work in a Rollup Field. There are multiple dates present in the Rollup Field, and each displays correctly when NOT using the DATETIME_FORMAT I am attempting: DATETIME_FORMAT(ARRAYJOIN(values, “\n”), “M/DD/YYYY”) But th...

Shayne_Bundy · Jul 25, 2018

I have a Date Field (Field A) for the date I last wore an outfit: “7/28/2018” This changes regularly; I change it each time I wear an outfit.I have a Long Text Field (Field B) I use for ongoing Notes on where I wore the outfit: “Special dinner XYZ” I...

Shayne_Bundy · Dec 16, 2022

Same issue here! Hoping for a fix soon.

Shayne_Bundy · Dec 01, 2022

Thank you for this breakdown! I will review the inputs that are causing the problem, and check for extra whitespace. If the issue seems to keep popping up, I will explore the scripting "clean-upoption as a solution, because trust me...I have enough "...

Shayne_Bundy · Apr 06, 2022

Is there a way to adjust this for situations where there is a space in the {First Name} field? Such as if they had a first and middle name entered there, both in all caps, and I wanted to correct it? Thank you!

Shayne_Bundy · Mar 13, 2022

Justin_Barrett: IF( NOT({Look Links}), 0, LEN(ARRAYJOIN({Look Links})) - LEN(SUBSTITUTE(ARRAYJOIN({Look Links}), ",", ""))+({Sub-Type} != "dip powder") ) Thank you for this clean-up! I found out the “0” vs. 0 thing on my own, but I am a...

Shayne_Bundy · Mar 04, 2022

I know this is an old post, but it is so close to what I need. My formula with this problem is: IF( {Look Links}=0, “0”, IF({Sub-Type}=“dip powder”, LEN(ARRAYJOIN({Look Links})) - LEN(SUBSTITUTE((ARRAYJOIN({Look Links})),’,’ , ‘’)), LEN(ARRAYJOIN({L...

User Statistics

User Activity

Append Rich Text Checkbox Adding Line Break

Different Primary Field for Synced Table?

Suggestion on Combining Attachments?

[SOLVED] DATETIME_FORMAT in Rollup Field?

"Running List" Formula Field Populated Using Data from Other Field

Re: cannot assign list of object to collection of complex types

Re: Append Rich Text Checkbox Adding Line Break

Re: We still need a simple TITLE CASE (PROPER) function alongside UPPER and LOWER

Re: Nested IF() Output Won't Convert to Number with Value()

Re: Nested IF() Output Won't Convert to Number with Value()