topic VBScript Labels- Multiple field values in Data Management Questions

VBScript Labels- Multiple field values

ChanceWitt — Mon, 28 Aug 2017 16:27:22 GMT

I am currently working on a label in which I am grabbing the data from one field (Element Name), then using data from an equipment field related to phasing. I want to return the data in A phase (Device Equipment A), unless empty, then B unless empty, then C. My vb skills are extremely rusty and I do not remember how to do this for more than two possible outcomes.

Can someone help me with the structure of this statement in order to get the results I seek? Thanks for any time spent helping.

I just drew a blank after the following:

[ElementName] & vbnewline & (...

Re: VBScript Labels- Multiple field values

KenBuja — Sat, 11 Dec 2021 14:10:49 GMT

It would be something like

Function FindLabel ([ElementName], [DEVICEA], [DEVICEB], [DEVICEC] )
  If IsNull( [DEVICEA] ) then
    If IsNull( [DEVICEB] ) then
      Findlabel =  [ElementName] & vbnewline & [DEVICEC]
    Else
      Findlabel =  [ElementName] & vbnewline & [DEVICEB]
    End if
  Else
    FindLabel = [ElementName] & vbnewline & [DEVICEA]
  End if
End Function  ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: VBScript Labels- Multiple field values

ChanceWitt — Mon, 28 Aug 2017 20:32:11 GMT

After tweaking the fields to match the data, this returned my labels as I wanted them perfectly. Thank you for the help!

Re: VBScript Labels- Multiple field values

KenBuja — Mon, 28 Aug 2017 20:48:19 GMT

Glad to help. Please remember to mark the question as answered.