Sean_Lake1 - profile

Sean_Lake1 · Oct 16, 2023

Hey all, sorry this topic sort of covers not only bases, but also interfaces so forgive me.We have a few itemsCourses that have a field of "Who Can Teach", this field is populated from a linked fieldThat linked field is currently derived from a synce...

Sean_Lake1 · Aug 04, 2023

Good day!I have an issue with an automation that SHOULD populate a table from the above data. The records that don't have the little green star should still be used for the automation to populate this table:The first table has 6 records that aren't b...

Sean_Lake1 · May 16, 2023

Good day all. I have some records where an attendee fills out a form and selects multiple events. This form populates several things:Calendar Table(which also generates GCal events)Junction TableAttendee's table with all the courses(Array)I want to...

Sean_Lake1 · May 04, 2023

Good day all.I have a formula that currently works:IF({Course Status}='Retired',"RET-"&CONCATENATE(LEFT({Course Level},1),{Course Type Coding (from Course Type)},".",{Sequence Number})&"-"&{Course Name},CONCATENATE(LEFT({Course Level},1),{Course Type...

Sean_Lake1 · May 02, 2023

Hey all!I've got a long formula, that currently has just one IF statement, however, I need to update to add another alternate IF.Here is the existing formula, that works:IF({Course Status}='Retired',"RET-"&CONCATENATE(LEFT({Course Level},1),{Course T...

Sean_Lake1 · Oct 19, 2023

I too just recently received this error and the field has a proper email in the text, so conversion makes no sense."To" could not be converted to a string.

Sean_Lake1 · May 22, 2023

Hey there MLO!Ok, I've already made another junction table:and manually placed two "attendee's" info into them to get an idea of how I want to the data to appear:So this table will store/track the attendee to the class. So that we can see a one to o...

Sean_Lake1 · May 17, 2023

Yes, does seem to be a simple question, but I'm not seeing what I'd think would be right for my case, either:For my issue, I have #invited, #who showed up, and calculation of %showed up. Simple math but apparently, not the case LOL.

Sean_Lake1 · May 16, 2023

I finally got it. AT support(Sean K), and I worked on it, but when we logged off, I hadn't noticed that the FULL field was opened and it'd duplicated the course id 2x. EEK!No worries, I worked it out:SWITCH({Course Status},"Retired","RET-"&CONCATENA...

Sean_Lake1 · May 16, 2023

Hum, Kuovonne, that didn't work for me, and since it's not a lookup field, rollups won't workI have a text field, with pasted in emails, all separated by a comma, the field is "Who Showed up?" The formula field is "#Who Showed Up:COUNTALL(ARRAYUNIQUE...

User Statistics

User Activity

Creating several elements - Instructors that can teach that course, are only avail for that course

Received invalid input

Extract values from field [Array,Array,Array]

If and If nested statements

Updating formula - Nested IF statements

Re: "Message" could not be converted to a string.

Re: Extract values from field [Array,Array,Array]

Re: Calculate Percentage using Total From Column

Re: If and If nested statements

Re: Count unique text (names) separated by commas in another formula field (arrayunique)