Workspace - field mappings

[pallavigaik]

Hi All,

I have configured 3 page variants in workspace. On pageA, I'm inserting a record in Table1. passing created record's sys id in page properties to PageB. Let's say parentRecSysId to that sys id. From PageB, passing that parentRecSysId to PageC in URL parameter. On PageB, I'm inserting a record into Table2. In that record, I need to insert parentRecSysId in one of its fields. How can I insert it. In Table2, a reference type field is there where I need to insert parentRecSysId. But on pageB in workspace form that refernce type field is not there. 

Hence please let me know what configurations do I need to implement to insert received parentRecSysId in the Table2.

Thanks in advance. Appreciating your time to support .

[Mark Manders]

Can you share your actual business case? What is the requirement you are working on? 

You are providing a non working solution to it, but it could very well be that a different solution is better for the requirement to work.

[pallavigaik]

Hi Mark,

Thank you for reverting.

My requirement is to set value of rate schedule group field while inserting a record in table. Rate schedule group field is of reference type field in that table. Rate schedule group field is not present on UI so, I cannot directly enter value in that field. 

Hence I want to know that how can I insert a value in Rate schedule group field in workspace.

Note: The value which need to be inserted in Rate schedule group field, is present in Page URL.

[pallavigaik · Accepted solution]

Have configured an onLoad client script (UI type is all) on table. Since parentRecSysId is present in the URL, have fetched the URL in client script. splitted that URL, fetched parentRecSysId from it and then mapped it to field using g_form.setValue(fieldName, value). This solution fulfilled my requirement.