Trigger query by tab selection?

App Building
, ,
1

Hi

I only want the Get_subtasklog to run when user press the TAB 4 and not before.

Is there a way to trigger a query to get data when a TAB is selected?

I have "Run Query only when manually triggered" in Get_subtasklog

The issue that I have many query that start running before user has selected a row or TAB this means that the query is running with is missing Where clause.

I have a main table listing all Tasks. User can select a Row (Task)

User then have a tabbed container that shows different data based on the tab selected.
TAB 1: List my subtasks - Query: Get_subtasks
TAB 2: List all unassigned subtasks - Query: Get_subtasks
TAB 3: List all my closed subtasks - Query: Get_subtasks
TAB 4: Log / History - - Get_subtasklog

I hope there are any good solutions for a new beginner of ReTool.

2

This is pretty easy to achieve:

You can either set the queries to run automatically when input changes, and set them to be disabled when the selected tab is not the one you want.

image
image848×103 8.6 KB

Another option is to have a script with a switch that runs every time a tab is selected, in the event handler section

3

Hi @Backofficely

I can not find the disable query field in my ReTool. I'm using Self hosted v 3.33.14

Do you have a screen shot showing where it is?

Also if a Tabs is linked to a container then the event hendlers is not avaliable.

image
image706×720 41.6 KB

4

The event handler is still available, but it is moved to the tabbed container handler.

Regarding the disable query, it is in the Advanced tab, under the advanced options section

5

Thanks for the help.
I found it under Advance and using this.

1 Like