Use Workflow SQL Query Unsafe in Form Runtime Modifications?

Permanently deleted user

June 20, 2018 17:02

I'm developing a workflow that takes text input to get geometry. I'd like to provide suggestions as the user types, but the non-spatial database that has the project list has no services I can tap into. I have all the configuration info I need for the SQL Query Unsafe, but I don't see a way to give real time feedback to the user, so a project can be picked from a list.

 

Might anyone be able to outline an approach for me? This would be much better than searching for something that might have been mistyped after form submission.

 

Thanks,

 

Martha

0

• 

  Nico Burgerhart

  June 20, 2018 20:48

  You can define a search table and use it as the source for an AutoComplete box.

   

  See here https://support.geocortex.com/essentialsGSCkba?sub-nav=kba&main-nav=essentials&#!/feedtype=SINGLE_ARTICLE_DETAIL&criteria=BESTANSWERS&id=kA3600000008QTXCA2

  0
• 

  Permanently deleted user

  June 21, 2018 22:04

  Thank you so much, Nicole,

   

  I shall give that a go and report back next week.

   

  Thanks,

   

  Martha

  0
• 

  Permanently deleted user

  June 21, 2018 22:05

  So sorry, Nico,

   

   

  My fingers got carried away.

   

  Martha

  0
• 

  Permanently deleted user

  June 26, 2018 19:05

  Thank you, Nico,

   

  t took me a while to understand that I needed to assign a field to the QueryDisplayOutputField, but I now have hints that appear after the 4th character has been typed.

   

  Martha

  0

Please sign in to leave a comment.