Share a single record of a form

Scriptcase 9 Discussion
#1

How can I share the URL that points to a single record in a form?
I’d like to point by something like http://path.to.app/ID=123

If I try something like this the form shows me all the record.

Any suggestion?

1 Like
#2

You need to use the ‘?’ character and the correct id field name.

It works for me as …path_to_app/?id_cat=1013

where “id_cat” is the name of the primary key field.

1 Like
#3

Hi Alessandro
Be aware of permissions if you share a link without going through authentication and have security activated

#4

My primary key is ID. When I try to call passing ?ID=3 the form shows me all the records, not only 3 …
ID is not a form parameter, just the PK of the underlying table.

Thank you!

#5

it’s and internal variable (GET) and must be defined in lowercase id=3

#6

in your SQL SET WHERE CLAUSE PK_FIELD = [id_cat]

#7

Actually it works for me and I didn’t add\change anything to the default app configuration to make it work, not even in the SQL settings.

Maybe the reason why it works for me is that all my single record form apps are really single record apps: I remove the navigation buttons from the toolbar.
My forms apps are always open from other apps with links to a specific single record so I don’t need/want the users to navigate to different records using the form apps.

1 Like
#8

Wow! I passed id=123 instead of ID=123 and it works fine!

Thank you very much!

1 Like
#9

You are welcome. I’m glad to have helped you.

#10

This lowercase primary key variable name issue should be shouted from the rooftops!
Thank you!!!