Topic Options
#60969 - 05/30/19 06:24 AM Pop-up prompt for text in GridView
Warren Offline
Softrak Training

Registered: 12/19/01
Posts: 4
Loc: Vancouver, BC Canada
(172.110.76.38)
What is the formula in GridView to give a pop-up prompt to enter text?

Top
#60970 - 05/30/19 06:44 AM Re: Pop-up prompt for text in GridView [Re: Warren]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4543
Loc: Wynnewood, PA
(172.110.76.38)
QueryString

An example - QUERYSTRING("Enter the Customer Number")

Top
#60971 - 05/30/19 06:53 AM Re: Pop-up prompt for text in GridView [Re: Steve Schwartz]
Warren Offline
Softrak Training

Registered: 12/19/01
Posts: 4
Loc: Vancouver, BC Canada
(172.110.76.38)
Thank you Steve!

Top
#60977 - 06/02/19 01:04 AM Re: Pop-up prompt for text in GridView [Re: Warren]
chinmook Offline
Edward Chris Chin-Mook

Registered: 09/29/09
Posts: 401
Loc: Jamaica
(216.10.217.78)
Dear Warren,

<<What is the formula in GridView to give a pop-up prompt to enter text?>>

As an addition to Steve's post, watch out for the need to also TRIM the field you want to pass the query to, else you will do the function called QUERYSTRING and your report returns empty.

My advice is to always TRIM the target FIELD.

See examples below...
>>>>>>
Example #1 - Trim

TRIM({Posting Seq}) = QUERYSTRING("ENTER Post Seq number","12345")


>>>>>>
Example #2 - Use of AND function


AND(
{Trx Date} >= Querydate("Enter Start Date YYYYMMDD", DATE(2010,01,01))
,
{Trx Date} <= Querydate("Enter End Date YYYYMMDD", DATE(2010,12,31))
,
TRIM({LCUST})= QUERYSTRING("ENTER PATIENT ID","MOOK")
)



....

>>>>>>
Explanation:
The target Field in example 1 is {Posting Seq}

Had to TRIM Field so that the data entered via QUERYSTRING("ENTER Post Seq number","12345") would be recognized by Gridview...

Use AND function to extend your pop-up prompt to enter multiple text or dates
>>>>
_________________________
Edward C Chin-Mook
10 Waterloo Ave, Kingston 10, Jamaica
876-754-7444
876-754-5513

Top
#60988 - 06/03/19 09:41 AM Re: Pop-up prompt for text in GridView [Re: chinmook]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11640
Loc: Vancouver, BC Canada
(207.35.234.226)
Thank you Edward!
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 117 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14553 Topics
71030 Posts

Max Online: 432 @ 01/20/25 10:17 PM
October
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31