topic Re: vbscript for NOT displaying zero's in attribute field for labels in ArcGIS Enterprise Portal Questions

vbscript for NOT displaying zero's in attribute field for labels

nimitz — Tue, 23 Oct 2012 14:53:27 GMT

Hey all,
I'm trying to label some wells with their ID and analyte value, but if the well has a zero I don't need it labeled. Could anyone take a look at what I've got so far? I keep getting an error, but I can't seem to figure it out.
The function is calling our 'Silica', and I"m wondering if this field needs to be all uppercase?

Function AnValue ( [LOCID] , [Silica] )   if ( [Silica] > 0 then   AnValue = [Silica]   end if  End Function

Any help is appreciated,

Randy

Re: vbscript for NOT displaying zero's in attribute field for labels

nimitz — Tue, 23 Oct 2012 15:09:53 GMT

I'm wondering if the SILICA field needs to be a certain type? I have it has a short integer now with 4 as precision.

Re: vbscript for NOT displaying zero's in attribute field for labels

KenBuja — Sat, 11 Dec 2021 12:03:14 GMT

You code was missing a parenthesis. This code works with a numeric field with decimals


Function FindLabel ( [LOCID] , [Silica]  )
  if ( [Silica] > 0) then
    FindLabel =[Silica]
  end if
End Function

Re: vbscript for NOT displaying zero's in attribute field for labels

nimitz — Tue, 23 Oct 2012 16:43:33 GMT

yeah, I found that. still no go.

Re: vbscript for NOT displaying zero's in attribute field for labels

KenBuja — Tue, 23 Oct 2012 17:05:23 GMT

This is how it works for me

[ATTACH=CONFIG]18659[/ATTACH]

Re: vbscript for NOT displaying zero's in attribute field for labels

nimitz — Tue, 23 Oct 2012 17:11:51 GMT

yeah, that's what I got.
[ATTACH=CONFIG]18662[/ATTACH]

thanks,

Re: vbscript for NOT displaying zero's in attribute field for labels

KenBuja — Tue, 23 Oct 2012 17:22:47 GMT

Why do you have two SILICA fields? Could that be an issue?

Re: vbscript for NOT displaying zero's in attribute field for labels

nimitz — Tue, 23 Oct 2012 17:31:33 GMT

ha ha! good catch ken. I THINK what happened is when I was experimenting with adding different fields, the SILICA field was entered in a couple of times. Well, when I deleted the fields, I didn't "refresh" the label expression dialog box. So, I removed the shape file and added it back in, and VOILA!

However, the function is not labeling the other well sites that have a zero. hmmm

Re: vbscript for NOT displaying zero's in attribute field for labels

KenBuja — Tue, 23 Oct 2012 17:37:34 GMT

However, the function is not labeling the other well sites that have a zero. hmmm

Now I'm not sure what your objective is. I thought you didn't want the well sites with a zero to be labeled.

Re: vbscript for NOT displaying zero's in attribute field for labels

KenBuja — Tue, 23 Oct 2012 17:49:01 GMT

From your other thread, are you looking for something like this?

Function FindLabel ( [LOCID] , [Silica]  )   if ( [Silica] > 0) then      FindLabel = [LOCID] & vbNewLine & [Silica]    else     FindLabel = [LOCID]   end if  End Function

Re: vbscript for NOT displaying zero's in attribute field for labels

nimitz — Tue, 23 Oct 2012 18:33:10 GMT

absolutely perfect!

Bravo, and many thanks Ken!

Re: vbscript for NOT displaying zero's in attribute field for labels

KenBuja — Tue, 23 Oct 2012 19:46:44 GMT

Glad to help. Don't forget to click on the check mark in the post that answered your question.