Big Data‎ > ‎BigData - Data‎ > ‎

BD - Finding Counties

<< back to BigData
Finding Counties - Look ups
Now that we have everything working, we want to make our program simpler to use, easier to understand and make the information more appealing. (It is hard to read such the table on a small screen like a cellphone)

This is what we have so far:

                                    

    Add a button "Find" and 4 text entry fields. 
    Name the first one "County" - it will be for the user to type in the name of the county to lookup
    Name the others "a", "b", and "c" - they will be to display the fields after the lookup
 
                                     

    Add label fields to identify the other fields:

                                    

    Put the following code on the "Find" button:

on mouseUp
   put field "County" into mycounty
   find mycounty in field "mydata"
   if it is not empty then
      put  the foundLine into theLine
      put word 2 of the foundLine into theNum
      put line z of field "x" into y
     
      put item 1 of y into field "a"
      put item 2 of y into field "b"
      put item 3 of y into field "c"
   end if
end mouseUp

      Size down the window and do not worry about the field "mydata" being cut off. It is still there and still works. All we did was size down the "visible" window that the user will see.


Next, uncheck the "visible" property of the field "mydata" in its Property Inspector

                                                




This is how the final looks:

Comments