Hi,
One approach is to loop through all fields and do a number of:
$PROCESS$ Application-Copy-Field-Value <tmp-field-id> <from-field-id>
The field ids can be found in the the database. You can create a view-form
against the and then display the field ids in a table-field. The schemaid
must be retrieved from the database table and then used in the
qualification in your table.
SQL tables in the database:
- arschema (important columns are schemaid and name)
- field (important columns are schemaid, fieldid, fieldtype=1)
Create a table-loop-guid that checks each field in turn.
I do not know how important speed is to you. There may be some things that
can be done depending on your requirements.
Best Regards - Misi, RRR AB, http://rrr.se
> hi, can anyone help me?
>
> i need to check all the fields in a form whether the field has a value
> or not, and if it's not empty, grab the name of that field and its
> value and concatenate them all together and push the string value to a
> field in another form.
>
> i know i can do this by creating a series of active links to test the
> field and push the data but i was hoping there is a more optimized way
> of doing it (like a foreach statement)
>
> any other ideas how i can do this?
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"