Hello guys,
There is custom budget table which gets data through record producers.
Record producer has two fields budget amount and approver.
after submitting the record.
Depending upon the approvers, there are 4-5 fields like rtb/prj, budget code, budget des, project ID, project des, and portfolio will show different dropdowns.
For different approvers, we have different portfolios
For different portfolios we have either RTB or PRJ.
When RTB is selected, budget code, budget des fields get visible showing dropdown values for particular approvers and portfolios
similarly for when PRJ is selected, project ID, project des gets visible
These fields need to reference data from custom table (budget tracking data)
when I select rohit kallo, I get duplicate values in my portfolio fields (for eg SOCE 6 times), I only need unique values.
and in RTB/PRJ drop down, I get portfolio values instead of RTB PRJ, similarly in budget code, I am getting portfolio values instead of cyber security, Dcc etc.
I know it's happening because I have table display value to portfolio, but for different fields, I need different values, I tried attributes but it doesn't work ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=u_rtb_project
This is script include that is setting values to different fields, I have created different function for different fields
this is for the field
Please tell me how to get Budget code dropdown values and not portfolio values
Help me guysssss!!!
