Share a single record of a form

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

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

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

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!

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

in your SQL SET WHERE CLAUSE PK_FIELD = [id_cat]

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

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

Thank you very much!

1 Like

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