Forum Discussion

LisaGilmore's avatar
LisaGilmore
Qrew Member
4 months ago

Auto suggested fields

How do I get certain fields to 'auto-suggest' information.  For example, I input many phone numbers, but I use certain ones more often than others.  How can I get my boxes to give me a drop down of frequently used information so I do not have to manually enter it everytime.



------------------------------
Lisa Gilmore
------------------------------

1 Reply

  • I think that the only way to do this would be to set up a table of commonly used phone numbers and then set up a relationship where one commonly use numbers has many of your main records.  Then you would also still need your existing data entry field.  Then you would need a formula field set to calculate the final phone number base on a formula that looks at both fields.  In view mode on the form you would only show the final field but an Edit or Add mode you would need to show the look up field as well as the data entry field.  And all your reports she would only use the final calculated field.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------