- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 07:39 AM
Hi,
How can I make one Reference Field depending on the value of another (Reference) field in record producer form?
Can anyone help me it will help!
Thanks in Advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 08:48 AM
Yes so in the reference qualifier what you need to do is use the below code
javascript:'tablefieldname='+current.varibales.firstvariablename
Now in the above line you need to replace the tablefieldname with the fieldname which contains the account value in the site table.
And firstvariablename should replace the variable name of account variable
Please paste a screenshot of what you have written so it is easier to guide you.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 08:19 AM
hello,
In the second reference field which has to be dependant please add the below code in the reference qualifier field
javascript:'tablefieldname='+current.varibales.firstvariablename
Please replace the field and variable name correctly.
Please mark my answer as correct based on Impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 08:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 08:48 AM
Yes so in the reference qualifier what you need to do is use the below code
javascript:'tablefieldname='+current.varibales.firstvariablename
Now in the above line you need to replace the tablefieldname with the fieldname which contains the account value in the site table.
And firstvariablename should replace the variable name of account variable
Please paste a screenshot of what you have written so it is easier to guide you.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 08:55 AM