How can I make one Reference Field depending on the value of another (Reference) field in record pro

mania
Tera Contributor

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!

mania_0-1695739074016.png

Thanks in Advance!

 

1 ACCEPTED SOLUTION

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.

View solution in original post

8 REPLIES 8

Saurav11
Kilo Patron
Kilo Patron

hello,

 

In the second reference field which has to be dependant please add the below code in the reference qualifier field

Saurav11_0-1695741590973.png

 

 

javascript:'tablefieldname='+current.varibales.firstvariablename

 

Please replace the field and variable name correctly.

 

Please mark my answer as correct based on Impact.

mania
Tera Contributor

@Saurav11 

 

That is not working for me can you please explain with exact steps clearly.

 

Thanks!

Mania

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.

mania
Tera Contributor

@Saurav11 

 

Can you please guide me.

mania_1-1695743728074.png

 

Thanks!

Mania