I’m using a formula to populate a listbox on a web app. Its a @DbColumn formula. Whenever I select one of the options and save, I go back into it, the options is no longer saved. All of the other data on the document is saving, so I know it must have to do with getting a handle on it when selected, but I’m not sure how to accomplish this. Help? Here is my formula.
res := @DbColumn(“” : “NoCache”;“”;“Goal Definitions”;3);
def:=“–Select–”;
@If(@IsError(res);def;def:@Sort(res))
Subject: Listbox choice not saving
You imply that it is not being saved. Have you checked to see what value is saved in the field? Use the properties box in the client. I am betting that the save succeeds. tell us more.
Subject: RE: Listbox choice not saving
Interestingly enough, if you do the save through the Notes client, it works as expected. Through the web, its not saving the selection, though.
Subject: RE: Listbox choice not saving
Check to see if your Form property “Generate HTML for all fields” checked?
Subject: RE: Listbox choice not saving
Yes, when I check the document properties, it shows the field value as null.
Subject: RE: Listbox choice not saving
I should have stated for you to check the properties from the view (checking properties from an open doc can show a totally different value).
From what I have read, this should work.
Is there any JavaScript on the form referencing this field? What is in the QuerySave and WebQuerySave events? Are other fields or form events referring to this field. Is the field computed? computed-when-composed? computed-for-display?
Subject: RE: Listbox choice not saving
Ok, I was mistaken, and the value is being stored in the field, but not being displayed when opened from the web, but is being displayed when opened from the client. So, its a matter of actually not displaying vs not saving.
Subject: RE: Listbox choice not saving
If you put the document in Edit mode, does it show the correct selected value?
Are there any pipes in the values?
The pipe character - ‘|’ - tells notes to render anything before the pipe as the value, and anything after the pipe as the options displayed label.
So, if you were to have an option of “Test|”, the value would be “Test”, but the label (and Read-Only display) will be a null string.
Subject: RE: Listbox choice not saving
Maybe a Silly Idea,
but what about setting the default value equal to the field name ?
ian
Subject: Listbox choice not displaying on web
I wish that was the issue, but its not. I’ve tried making a duplicate field that shows when editable, and hiding the other field when read. Still does not display the choice from the web, even though it save sit in the document.
Subject: Listbox choice not saving
I doubt there is something written in the input translation event of the field which is forcing the the field to be null while saving.
Subject: RE: Listbox choice not saving
Correct, there is nothing in the input translation of the field. What am I doing wrong?
Subject: Listbox choice not saving
Ok, I’ve had to get creative to make this work with some hide-when formulas, but its now working. Geez, I had to go back to my App Dev 1 classes from 10 years ago to make something so simple work. Why I had to have multiple fields to do this on the web, I don’t know. thanks to all who provided input.