URL to filter records

Hi,

Sometimes we have the needs to display a dynamic list of records according to the filtre.

We tried doing something like making a link like this:
https://www.ragic.com/org/admin/5?where=111111,eq,12345

Where we want to list records where fieldID 111111 is equal to 12345
The records we want to display have deep test fields which makes the form very long when we do a reference embed so this is an alternate solution.

Can this be done somehow?

Thanks as always

Hi,

You may try the link below:
https://www.ragic.com/org/admin/5?pqv111111=12345

https://www.ragic.com/org/admin/5 would be your sheet path.
?pqv is the parameter for exactly matching. You can replace it with ?pql for fuzzy search.
11111 would be your field ID.
12345 would be the value you would like to filter.

1 Like

:grin: Thank you I forgot about that.

1 Like

Taking this one more step…if we know that there is going to be only 1 record, is there a way to bypass the list view and just bring up the form view?

After clicking on the sheet name, you will be directed to the list view. If you prefer to access the entry form view directly, please try entering the entry URL, such as www.ragic.com/accountname/sheetname/entryid.