Using the Drop Down List object

Wondering how to do something in FormBoss? Check this forum for common solutions to design problems.

Using the Drop Down List object

Postby sixlead » Tue Jul 27, 2010 1:42 pm

I have a client that wants a drop down list to be integrated into the search page. ie: asset# field OR model field OR building Dropdown SQL driven list. Do I have to do this manually or is there a way to get FB to do it? Perhaps this should be done with a free form template rather than a builder template?

TIA

Bob
sixlead
 
Posts: 4
Joined: Thu Jul 15, 2010 5:01 pm

Re: Using the Drop Down List object

Postby sixlead » Tue Jul 27, 2010 2:28 pm

Wow isn't it amazing how RTDM works if you do it, well actually I read the manual I just didn't get it right away. So here is my solution
the normal search token is

#{*H_Search|BUILDING,=,OR,STR,textbox,15,5,,|}

to use a select drop down box edit the token as follows

#{*H_Search|BUILDING,=,OR,STR,select,15,5,,$get_buildingList|}

Then add a query object that will pull the list information you want from the database like SELECT building FROM buildings then change the query result var to something that makes sense or replace $get_buildingList with the fb default of $fb_query.

RTDM works every time, but not until you have first asked the question of a small audience like the internet. :D
sixlead
 
Posts: 4
Joined: Thu Jul 15, 2010 5:01 pm


Return to Hints and Tricks

Who is online

Users browsing this forum: No registered users and 1 guest