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 in....you 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"