1 Column Showing Values from 2 Different Fields from same Form

HCL Domino Domino Forum
1

I have a colmun that needs to show the value of two different fields. How can I accomplish this in formula language?

2

Subject: 1 Column Showing Values from 2 Different Fields from same Form

how about:@if(requesttype = “order”; OrderAmount;

requesttype = “repair”; RepairAmount;

“”)

That will display the Order amount if it’s an order, the repair amount if it’s a repair and nothing if the RequestType field hasn’t been filled in.

3

Subject: RE: 1 Column Showing Values from 2 Different Fields from same Form

No, this is what I am talking about. I have one field named LicNum and the other field is named LicNumOth. I need the 1 column to show both values. For example if LicNum has a value in one form and LicNumOth has a value on a different form, the 1 column will show the value for each.

4

Subject: RE: 1 Column Showing Values from 2 Different Fields from same Form

@trim(LicNum : LicNumOth)

or

@If(form=“formName”;LicNum;form=“OtherFormName”;LicNumOth;“”)

5

Subject: RE: 1 Column Showing Values from 2 Different Fields from same Form

So - is the view displaying data from 2 different forms, and if the document is one form display one field, if the other display the other? Your post isn’t that clear, but if that’s the case, then just check for the form name:

@if(form=“A”;LicNum;form=“B”;LicNumOth;“”)

6

Subject: RE: 1 Column Showing Values from 2 Different Fields from same Form

If you need a clearer explanation here goes. 1 form has two different fields. 1 field is named LicNum the other field is named LicNumOth. The column in the view needs to show the values for those two fields. Rene Scheening gave the solution though. it is @trim(field1 : field2)

7

Subject: RE: 1 Column Showing Values from 2 Different Fields from same Form

The reason for confusion is you are using the word “form” where you mean “document”. Form is a design thing. The document contains data, and you can have different forms with different fields displaying that document.

8

Subject: RE: 1 Column Showing Values from 2 Different Fields from same Form

Well thank you for explaining the difference.