Thanks LJ,
I will try this.
-Manoj
On Tue, Jan 17, 2012 at 9:20 PM, LJ LongWing wrote:
> Manoj,
> When faced with the exact same problem (dynamic form AND dynamic field) I
> was forced to create a bit of workflow. The first workflow is to look in
> the 'field' table to determine the 'type' of field I was planning on
> getting was. Then use a series of workflow that is specific to that type
> of field and use direct sql to set it into the appropriate tmp field type
> appropriate, then, once in that field, use standard setfield processes to
> get it into the field you actually want it inyou may find the below
> special run-process usefull
>
> Application-Copy-Field-Value targetFieldID sourceFieldID
> Copies a field on the current form to another field on the current form.
> Returns one
> of the following integers:
> ?? 1—The assignment failed.
> ?? 0—The assignment occurred.
> To get the return value, use this command in a Set Fields action with
> $PROCESS$.
> This command cannot be used in a Run Process action.
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Manoj Patil
> Sent: Tuesday, January 17, 2012 8:03 AM
> To: arslist@ARSLIST.ORG
> Subject: Technicall Challenge in pulling data dynamically
>
> Hello List,
>
> We are having below technical difficulty in one of the requirement.
> What we want do is to set a field dynamically. We have two fields on the
> form (Form Name and Field Id).
>
> Now we want a workflow/Run Process that would do dynamic set field.Like it
> should pick value of the Form Name field (Let’s assume, it would pick
> formname as a TEST:MP) as source form andvalue of the Field Id as source
> field id (The field idis of the field on form TEST:MP).
> In set field action, Form name can be picked by using Sample Data in Set
> fieldbut we cannot map field dynamically.
> **we have static set field qualification.
>
> I did it using SQL query but the result I get for character field is fine
> but if it is date field or selection field, it would set the time is
> seconds or the selection value and not the label. So using an sql query it
> will be difficult to determine what type of field is being pulled and hence
> there would be trouble to convert the value to a readable format.
>
> Let me know if anyone have solution for this.
>
> Environment details:-
> · AR Server 7.5 patch 3
> · Sun Solaris 9
> · Oracle 10g
>
>
> Thanks in advance.
>
> Regards,
> Manoj.
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
