Community
Showing results for 
Search instead for 
Do you mean 
Reply

Presaved Query - Easy Query Selection for Users - joining Multipe Queries

Skilled Commentator
Posts: 71
Country: United Kingdom

Presaved Query - Easy Query Selection for Users - joining Multipe Queries

Hi

 

I would like our staff to have access to a range of advanced queries

 

So far:

Its easy to create them, and store them, and some users are happy to go Lookup/Advanced/Open

 

But:

Is there a way to have a dozen queries 'pegged' as Icons on the Act screen so they can simply select those

 

 

The Next Scenario

Is it possible to have Intersecting queries - That is Boolean Logic joining together multiple queries

 

So far; I have used groups to prestore the query look ups (as dynamic lookups) and used the addon GROUP-IT which can save schemas that allow boolean logic between groups - thus giving me a form of Boolean logic between the queries.

 

I'd like something simpler - that then allows a user to

Select a single Query, and then tick box style, select other queries that continue to narrow/widen the search

 

Would appreciate any comments feedback or suggestion of tools/addons.

 

 

Regards

Carl

 

Nickel Super Contributor
Posts: 341
Country: USA

Re: Presaved Query - Easy Query Selection for Users - joining Multipe Queries

Scenario 1 - An idea on video

 

https://youtu.be/2Mc_wsjzgfg

 

Additionally...

Do not forget to periodically back up your database - including attachments - in a folder created for this purpose. - Then copy this ZIP file to a USB stick or external drive for better security.

Keep in a safe place the Act! administrator password.

Good luck and best regards,

Juan Carlos Otero
juancarlostero@icloud.com
Skilled Commentator
Posts: 71
Country: United Kingdom

Re: Presaved Query - Easy Query Selection for Users - joining Multipe Queries

Juan

Thank you so much.

You video was perfect - thank you for creating it.

Regards