The spreadbased is great functionality, which I have now successfully used to populate a large number of choices for the user of a Q&A.
As a basic follow-up question, I wonder whether a spreadbase can be used in a similar fashion to populate choices (as predefines or otherwise) into a document in assembly mode.
A couple of use cases:
- A list of the 50 US states (same as what I did in the Q&A). Could I use the same spreadbase in assembly?
- Somewhat related to the above, list with pieces of related text. E.g., a 50-state list where each state is associated with other information in successive columns, such as the title of the corporate formation in that state (certificate of formation, articles of formation). I want to then code a datafield such that the user (1) sees a choice af the 50 states and (2) the datafield will automatically insert data from x columns over in the row of the selected state, like the formation document title.
Is this possible and easy enough to do?