A
|
acpan 8/25/2021 |
if you want to use edit2, you need to set the field also as key column in the select field page. then your can refer to it as But i am not sure if user enters without the edit2 value, will it still display other data. If it works, you are done. Else you can also restrict the access at View Page's Process Record Values event : $code = isset($_REQUEST["code"]) ? $_REQUEST["code"] : -1 ; Then give the URL with the "code" param to external party: https://a.b.com/a4a_draw_view.php?editid1=2&code=random_code |
S
|
SteveDickson author 8/25/2021 |
Thanks for your reply. I modified it a bit to suit and all seems ok, however it still leaves me with the second stage of the problem (I thought fixing stage 1 would help me fix stage 2). so the url looks something like this, a4a_draw_view.php?editid1=100&code=stuvwxyz, which presents a page which needs to have a link to a4a_trans_add.php?mastertable=a4a_draw&masterkey1=100&code=stuvwxyz I have set the hyprerlink in View As" in the field options as "./a4a_trans_add.php?mastertable=a4a_draw&code=". How do I get the masterkey1 value in there as well or just disregard the masterkey altogether? |
A
|
acpan 8/25/2021 |
so the url looks something like this, a4a_draw_view.php?editid1=100&code=stuvwxyz, which presents a page which needs to have a link to a4a_trans_add.php?mastertable=a4a_draw&masterkey1=100&code=stuvwxyz In View Page, for "View As", don't use hyprerlink, use custom code, you can ontain the master key this way: // assume master key of a4a_draw is id remove the target='_BLANK' to open in the same browser window. Unless you programatically add the master key in the event code, disregard masterkey will add the data withinout linking to any particular draw, and becomes a mess later. |
S
|
SteveDickson author 8/25/2021 |
A little bit more changing of quotes, etc and it worked a treat! Thank you so much. Would love to have someone like you around for when I struggle with these little (amd not so little) things. Happy to pay also. Please send me your details if you're keen. steve@coastalscales.com.au |
A
|
acpan 8/25/2021 |
Glad it helps, no worries :) and good luck to your project ! |