[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Multiple Fields in a select statement for a view

I have a view and the first column I want to use 5 differnt fields from the form.

I want to use

ProMono
ColorMono
LaserMFP
SS
Connect

Only one of the fields will be populated in each document

Can someone help me with the logic on setting this column in my view
0
Jaziar
Asked:
Jaziar
1 Solution
 
HemanthaKumarCommented:
You mean only one field will contain a value and others don't..then simply trim

eg;

@Trim(ProMono:ColorMono:LaserMFP:SS:Connect)

~Hemanth
0
 
Sjef BosmanGroupware ConsultantCommented:
Nothing wrong with that solution. If you want to improve performance, create an additional field in your document, Computed, multiple values, with the formula above as its value.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now