Is it possible to create a document in an existing database using DXL and create fields within that document that have computed formulas??
I have been successful in creating a document and creating a simple rich text field and setting the value of the rich text field to a text value… but I have not been successful in creating a field whose value is set based on a formula nor have I been successful in creating a hidden field whose formula upon execution would set/alter the value of another field.
Any examples or pointers would be much appreciated.
Subject: XML/DXL question for the experts
Computed fields, actions and events belong to the form. Unless you are willing to store the form, the best you can do is create a button in a rich text field and rely on the user clicking it.
Subject: RE: XML/DXL question for the experts
Thanks for the response… Is it possible to place LS script for example in the Initialize event of the field - or does that also belong at the Form level?
In short if a form exists in a database and the form contains computed fields… can XML be used t create a document based on that form and have XML updte/modify the formula or LS ??
Subject: RE: XML/DXL question for the experts
It all belongs to the form, I’m afraid. Documents don’t have Fields, they have Items, and items are data with no associated events. Fields are the UI widgets on the forms. The ONLY way you’re going to make this happen is with stored forms. There is no alternative.
Subject: ComputeWithForm?
Can you create the form with the fields and the necesary values, then after you have created the document from the DXl, call a compute with form.
Subject: RE: XML/DXL question for the experts
also has under it… does that mean I can use to create a “formula” type field that would execute ?? The Doc on Formula fields is not very clear
Subject: RE: XML/DXL question for the experts
Formula fields don’t execute, they store formulas. You still need something to run the formula.