I could you some assistance with Automation - Tasks to CC a user’s Supervisor when a report is triggered. I have a simple app for completing Juvenile Detention Screens and the app is shared by 9 counties. Each county may have many users, but each cou...

I’m having trouble with my SELECT() expression and would appreciate any assistance. I have a table, “4thCircuitOffense_Tbl” which contain a list of Charges, this table has 4 columns: Offenses, Score, Code, and ILCS Statue. Within the 4thCircuitDetent...

Hello, I could use some advice with how to share/structure my app with another department agency where we would share only one table, the ClientTbl, which is the parent to all other tables. I’ve built a very simple app for my department for completin...

Hello, Sorry to bother the experts with my remedial questions, but I’m struggling with what I think is a simple issue. I have a column, WarrantOtherJurisdiction that is a simple Enum field type with “YES” or “NO” possible responses. I have set the in...

Hello, I could use some assistance with developing an IF() statement to calculate the values entered in a different column within the same table. Basically, I have column, AggravatingFactors which is a EnumList type and the following options are avai...