Re: PVA Bot Search Excel Sheet
There could be different approaches here, based on what you are trying to achieve. Are you trying to avoid having to manage long lists of values, like specialization, and instead rely on an external api/database?
If that is the case, have look at the discussion here, which demonstrates how to retrieve a list of values during runtime, and use that list as options for the user to choose from.
But if you are trying to avoid choosing out of a list altogether and would prefer having users type whatever specialization they need, you can consider setting up a custom entity.
If you build a custom entity based on a list of specializations, and your question node will expect that entity, users will be able to type "Pediatrics" or "Genetics" and their responses will be validated against that list and stored in a variable.
List based entities also support synonyms and "smart matching", which, in principle, would make your question node more flexible. I.e. it would recognize some misspellings and match them with the correct value, and also make sure that synonyms, if defined correctly, are normalized.
For instance, users will be able to type "GP" and have "General Practitioner" stored in the variable linked with the question node.
I hope this helps, feel free to comment here with some more details on what sort of experience you are hoping to achieve.
