About ZOCO_Unlimited

ZOCO_Unlimited · 05-22-2025

I have security filters throughout many apps that are all of a sudden not working with IN() Statements. I am receiving the warning : IN() does not accept arguments of type List, List

ZOCO_Unlimited · 08-20-2024

I need to be able to order the dropdown as well as have the option to add a new record. Is there a work around for this or another area that I can order it by? Valid If ORDERBY(Customer Contacts[Name],[Active],true,[Last Used],true,[Name],false)Once ...

ZOCO_Unlimited · 01-14-2024

My automations emails are showing a link instead of an image. How can I make them show the image?Jobs : Job Imagetype: ImageEmail Body: <<[Job Image]>>Results in email body received: https://www.appsheet.com/image/getimageurl?AppName=AppName12345&tab...

ZOCO_Unlimited · 12-31-2023

I need to retrieve a decimal or a percent of a job complete. Every way I've written this, I keep ending up with 0. Any ideas?Jobs Table, Job Status Percent Column: SUM([Related Stops][Complete Counter])/COUNT([Related Stops])I also tried it directly ...

ZOCO_Unlimited · 12-10-2023

I'm looking how to change the delimiter from a comma to a forward slash to be able to create a link in google maps with multiple lat long values. Between every lat long set of coordinates needs to be a / in order to create the link. As you can see in...

ZOCO_Unlimited · 08-26-2024

This worked perfectly! Thank you so much!

ZOCO_Unlimited · 01-14-2024

THANK YOU! I saw another post that said it had to be in HTML but I didn't know how to do it. This worked perfectly

ZOCO_Unlimited · 01-01-2024

Well, that did it.. I swear I tried that at one point but it was probably before your first suggestion.. Thank you so much @AleksiAlkio !! For anyone else who runs into this, it was a combination of these two changes:@AleksiAlkio wrote:It sounds your...

ZOCO_Unlimited · 01-01-2024

Here's more of what's happening:When I select the jobs and update them, it will reflect the percent complete. Then if I open a job and complete a stop, it sets the percent complete to 0 in my sheet for anything that is not 100%. I highlighted the job...

ZOCO_Unlimited · 01-01-2024

That worked, thank you. About 5 seconds after it syncs, it goes back to 0. Any idea what's happening?

My Stats

jggj's Bio

Badges ZOCO_Unlimited Earned

Recent Activity

IN() does not accept arguments of type List<Ref<User_Roles>>, List<Text>

Orderby in Valid If removes option to add new, is there another way?

Show images in email instead of a link

Percent Calculation not calculating, returning 0

Change delimiter from comma to list multiple latlong values separated by "/"

Re: Orderby in Valid If removes option to add new, is there another way?

Re: Show images in email instead of a link

Re: Percent Calculation not calculating, returning 0

Re: Percent Calculation not calculating, returning 0

Re: Percent Calculation not calculating, returning 0