Thanks LJ, I will try this. -Manoj On Tue, Jan 17, 2012 at 9:20 PM, LJ LongWing <lj.longw...@gmail.com> 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 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"