Multiple Query Prompts In Bartender 关注

0
Avatar
Legacy Poster

Hi  there, 

 

I am having problem using query prompts to let the users search from excel database.

 

I would like to let the users enter multiple part number and it would return the records of it. If the textbox is left blank, it would show whole record instead. But i keep getting error from Bartender as i attached.

 

Any help would be appreciated.

3 评论

0
Avatar
Shotaro Ito
版主
评论操作 固定链接

You can specify minimum input character on query prompt, from More Options > Number of characters. Enable [Require minimum number of characters] and disable [Warn when minimum not met].

 

If you want to show all records when no data entered, you can use "start from" condition in one of queries.

0
Avatar
Legacy Poster
评论操作 固定链接

Hi Shotaro,

 

Thanks for the prompt reply.

 

How can i use "start from" condition in one of queries?

 

As you can see, i have created 4 query prompts. If all are left blank, then it will proceed to the whole record list.

If the users enter data on any textbox and left 3 others textbox blank., it will proceed to record list showing the only record they enter.

If they enter 2 textbox, will show record contain data from 2 textbox.

 

Can it be done? Thanks 

0
Avatar
Shotaro Ito
版主
评论操作 固定链接

It is "Begins with" operator. In query tab, change "=" to "Begins with". Assuming the code is treated as text data type - not integer etc.

请先登录再写评论。