Sean_Lake1 - profile

Sean_Lake1 · May 03, 2024

Hey All.Curious how I might set this up. Here's what I need.I have a form that interested parties need to fill out, an application.We review the potentials, and start the first pass of approvals/denials.The next stage is taking those that enter the ...

Sean_Lake1 · Apr 15, 2024

Good day.Looking to add to an existing form where we can rate each proficiency without having to create a field for every proficiency like this. Typically, yes, there'd be a field for each proficiency with a single select, but does anyone know if th...

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 03, 2024

A couple things. In order for the interface to be designed properly, I need to know how to setup the table or tables. The end result is an interface that whomever signs in, or at least that'd be more ideal, their name would be added to the linked f...

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...

User Statistics

User Activity

Create an interface, but how to setup table(s)

Forms -

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]

Re: Create an interface, but how to setup table(s)

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