Inventory Management: Generate Link for Specific Row, Generate QR, Then Scan QR to Open Card

Ask for Help
1

I’m currently building an inventory system in Grist and I’m stuck.

What I’m trying to achieve:

For each asset:

  1. Generate a unique link based on a UUID column

  2. Convert that link into a QR code

  3. When the QR is scanned, it should open the Card view of that specific asset

  4. The asset manager can then edit and assign it easily

This is to avoid manually searching for the asset every time.

Current setup:

Table: Asset Masterlist
Column: UUID (Text, unique per row)

Generated link formula:
SELF_HYPERLINK(page=16, LinkKey_UUID=$UUID)

This creates links like:
…/p/16?LinkKey_UUID=

I then use that link to generate a QR code on another page.

The Assign Asset page contains only a Card widget connected to the same table.

The problem:

When I scan the QR code on my phone, it redirects correctly to the page with the LinkKey_UUID parameter in the URL.

However, it always shows row 1, regardless of which UUID is used.

So the link parameter is present, but the Card is not filtering to the correct record.

Am I missing a configuration step for LinkKey to work with a Card widget?
Does the destination page require a specific setup for LinkKey filtering?

Any guidance would be greatly appreciated.

1 Like
2

After a quick google, afaik the link key is used to control access rules, not allow you to jump to a specific record. I think that would be better suited to the 'copy anchor link" [Ctrl + Shift + A or right click on a record and “Copy anchor link”].

Solved here: From Custom Widget : anchor link ==> the row

1 Like
3

This worked. Thank you!