I have a database search, in a Text element, to return a single value to display. But I also would like to use that returned value in another calculation on the same page (in another Text element). Is this possible? Is there a better way to do this? Would be great to have the search result (a single value being returned, as it will only find a single record) saved as basically a variable that I could reuse in other calculations or display elsewhere on the page, without reissuing the search. Thanks for any help.
Played around and saw two ways to handle. Not sure which is best:
- Do lookup in database with Repeating Group and assign each value to a Workflow STATE and then use that workflow state in other calculations/places on the page.
- Do lookup in database with Repeating Group and build the reference to the fields on the page or in calculations, when I need them.
Referencing the values I need is easier using method 1, but requires more initial setup (creating Workflow States). And, I am concerned that the workflow (and therefore values I need) are populated timely. From what I’ve read, this could be (I think) a possible area for potential problems?
Method 2 doesn’t require workflow setups, but takes a little more clicking around (building the reference to the field) each time you use it:slight_smile:
From those more experienced, is either of these ways the right way to go?
**UPDATE **I used method 2, as it seemed more realtime and less reliant on a workflow being kicked off.
This topic was automatically closed after 70 days. New replies are no longer allowed.