Latest Contributions by JasonPevear

I am trying to create an address field that uses autocomplete appearance. My goal is for the end user to type a few characters of the beginning part of the address and choices will appear and they will choose the appropriate address I've been able to do this successfully with 10,000 records (addresses) when I use select_one as my type and fill out the choices tab. But when I add 30,000 records in my choices tab, the load time suffers tremendously as does the overall functionality. Is there anyway for these 30,000 records to reside in the external_choices tab or in a csv in the media folder and the Address will refer to either of those versus the choices tab? I've seen several examples of external_choices but when I try it on my end, I get an error saying the choices tab isn't filled out correctly.  I thought the whole idea of using external choices was to avoid using the choices tab?  I suppose I'm quite confused on how this works.  I've googled for months on how to do this but have found no examples of how this is done correctly.  Is this even possible?  ... View more

A while back I wanted to create an address field where the end user only inputs the first few numbers of the address and the choices show up underneath in a drop down box, and the user chooses the appropriate address versus typing it in completely. So, for example, if a user types in '123', the drop down box would reveal their options 123 Cedar Rd, 123 Main St, 123 Norfolk Ave, etc.  This would hone in on the address they were looking for and the user would select from the narrowed list. The project I was working on got corrupted some how and can;t figure out how I did it.  Not sure if I used the pull data function...   Can someone help me out here and point me in the right direction, perhaps with a sample sheet?  Thanks very much! ... View more