Apologies if this has been answered. I searched but could not find anything.
My app database has a data type Location and a data type Nations. Nations has been populated with a list of the proper names of every nation in the world.
I have created a form so a user can add their location info, including the country. I use a SearchBox for this and it allows a user to easily add their country:
When a user clicks on the Save button, I want to create a new Location in the database. I have a Workflow for this that works for everything except adding the Country (which comes from the SearchBox). You will see that the SearchBox in question is greyed out and not selectable.
Does the searchbox nations type matches with your database location_country type?
If your database location_country is of type text or type nations? (Both can work)
If you need type geographic location, you will need to use google map api.
Sometimes I stumbled upon elements that are not available in certain expression fields but are available in others (e.g. the Searchbox Element being available in the Conditionals window, but not in the workflow of Create New). I reported the bug. Only solution at the moment seems to a) put the expression into a field where the element is available, for example in the Conditional Window of an element, or completely close your browser & reload, or clear browser History & Cache…
Thank you. That was the issue. For testing purposes, I had set the Country field to pull from an Option Set … then forgot I had done that. Later, when I added the full data of all nations, I forgot I needed to fix that field. I changed it to text and now it saves the Country as expected.
Thank you for suggesting this, as your idea led me to find my error.