Hello,
I have a problem getting values from fields in Form1 and putting them in computed fields in Form2.
Firstly, I have created a view containing all the necessary documents and id:s (Form1). Then, in Form2, I am trying to get the titles of documents in that view and to set them as field values.
In Form2 I have a computed field called IDlist that collects all these id:s to a list using DBcolumn. This works ok both in notes and web. Also, the following formula works ok in Notes and it gets the Titles of documents and puts them in several fields in Form2.
@If((@Elements(IDlist) > 0) ; @GetDocField(@Text(IDlist[3]) ; “Title”);“”)
Problem is, that Form2 does not work in web (and the above code seems to be the reason). When trying to save or refresh fields, an internal server error occurs. Can anyone tell me why? There should not be any functions that are restricted in any way (at least according to Designer Help file).
Subject: Getting field values by ID not working in web
It could simply be because IDList is hidden. If you haven’t used “Generate HTML for all fields” (or used some other method to include the field on the web), then IDList will not have a value when submitted. If IDList is not persisted somehow (can be recalculated to the same value it had before, or is included as a submitted field), then any field/formula that depends on it can “blow up real good”.
An easy way to include the field is this in passthru:
Subject: Getting field values still not working in web
I tested the form without hiding the IDlist in the web and the list is actually visible in the browser. The problem comes when composing the title fields using these IDs.
I also tried the passthru you suggested and generating HTML for all fields -still no success. The only way I could work this out is by making the fields “computed when composed” and composing them in the Notes, but this causes me more problems…