Formula question

Fordraiders
Fordraiders used Ask the Experts™
on
I have a formula on  field on a form.

Can anyone tell me what this formula may mean ?

S1:= @If(@ClientType = "Web"; "--Select One --"; "");
X := @DbColumn("" : "NoCache" ; "" ; "Region Maintenance" ; 1);
S1 : X


Thanks
fordraiders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
The formula gets all values from the first column of view "Region Maintenance".
Then on top of that list adds value "--Select One --", but only when accessed by web browser (when accessed with Notes client it contains only the values from the view).
This looks like a picklist choice selection formula.  It provides the choices for a select-type field (combo-box, list-box, etc).

It looks up the choices for the field from the first column of the 'Region Maintenance' view in the current database.

Also, if the form is being used via a web browser, the choice ''--Select One --" is added to the front of the choice list.

Commented:
If the formula is specified as "Value" of the field then the field just displays those values.
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Author

Commented:
OK...I'm trying to find the values for this list..do I need to go to the Notes client form ?

Author

Commented:
I want to edit this list..so is it in lotus notes...or in domino  ?

Sorry for the extra questions.

Commented:
How do you mean "is it in lotus notes...or in domino"?

Commented:
To edit the list you have to edit formula of the field.
What do you want to do with the list?

Commented:
In Designer - open Form - locate field and click on it.
In the lower frame you'll see formula.

Is that what you want?
>> "I want to edit this list..so is it in lotus notes...or in domino  ?"

The list is stored in a collection of Notes Documents.  In order to add or remove a value from the list, you need to understand how the documents are created / maintained in that application.

The first place to start is by opening the 'Region Maintenance' view in your database.  Is there an action button in that view that allows you to add a new value?  Try opening an existing document to see if you can change the value.  When you're done updating the choices, you may need to close and re-open the database depending on how the choice lookup is performed.

Commented:
The lookup is performed with NoCache option, so no need for db close/open :)

Author

Commented:
Thanks.. I had to physically edit the list in a database created in LOTUS nOTES...
Thanks for the help !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial