Good morning @ddsgad,
However, the app builder will not look up the field in the database when you pass a different parameter, other than the Row ID. Is this a current limitation?
In a “single row” data source, yes this is correct. You can either:
- Add a page parameter which resolves to the row ID, or
- Set a static integer yourself, so you always fetch a specific row ID, or
- Leave the field blank, and we’ll choose the first row in the table for you (which is useful if you’ve sorted the table a specific way).
However, instead of a Row ID, we wanted to pass another parameter in the URL that is in the database table (we have a unique key in a separate column).
Could you make use of our filters for this? Perhaps a combination of:
- Leaving the “Row ID” blank, so we choose the “first” row and
- Adding a filter on that unique key, and passing in the page parameter for that key as a filter value, like so:
So long as 1+2 resolve to a single row, this should work for you.
I hope this helps, have a great day!
Cheers,
Peter Evans