Action Button to Open a Reference Subtable

1

Hi Everyone,

Can I use the Open URL Action Button to open a reference subtable?

I have experienced a lot of latency from showing a reference subtable in the main sheet because we have more than 1000 rows related to one record.

Is there a way to add the action button that opens up a listing view of all linked entries?

For example,
Sheet A:

Job# Job Name
a transmission
b distribution

Sheet B:

Unit Job# (linked field)
1 a
2 a
3 a
4 a
5 a
6 b
5 b

When I open the Job A record from Sheet A, I want to be able to click a button to open a listing view of Sheet B that contains only units that are related to Job A.
So this is what we expected to see:

Unit Job #
1 a
2 a
3 a
4 a
5 a

Thank you

2

It’s possible to add filter attributes to the URL.
pql for fuzzy search
pqv for exact match

You might be able to generate a URL with you as attribute for Filtering the results.
if Job# field ID is 1234567
then you can use:
[url for Sheet B]?pql1234567=a
to open entries of Sheet B that matches Job# = a

As described in this post.

3

Hi Jeremy,

Thank you for helping me out. I’m still struggling to make this work since my Job# is not fixed to ‘a’ value. How can make it dynamic?

Something like:
[Url for Sheet B]?pql1234567=‘Sheet A Job Field Value’

4

I think you can insert a “field value” into the URL, so it will get the field value by “field ID”.
as described in this Ragic document.
https://www.ragic.com/intl/en/doc-kb/238/Open-different-page-with-action-button>

image
image1079×755 132 KB

5

Thank you. I will try this tomorrow!

6

It works! Thank you so much!

Here for others that need the same solution:

[Url for Sheet B]?pql[Sheet B Field ID]=[{Sheet A Field ID}]

for example,
https://xx.ragic.com/xx/xx/x?pql123456={678901}

123456 = Job Field ID from Sheet B
678901 = Job Field ID from Sheet A

The URL above will bring you to the Sheet B listing view with the dynamic filter on the field values that match the corresponding fields in Sheet A.