I am making my first attempt to use the smart assistant. The data is simple - one table with US Cities and their populations. I enable smart assistant and make a simple request “Show me the city with the largest population”. At one point, while trying to get this to work, my voice request would be transcribed into the search field… for some reason that isn’t working anymore - but even when it was, nothing would happen. Now the search field just contains the placeholder text. “View a table of USCities rows”. I am subscribed to the Pro version. At first I wasn’t and that was throwing me for a loop. I then updated to PRO and still nothing happens. Any help would be greatly appreciated.
Hi @TM_Vis , can you let me know the name of your app and account number? I can take a look. Also, please go to https://www.appsheet.com/account/account#_tab_acctConfig and check the option that enables support access.
Hope you are well.
Actually this behaivor seems to be there since the smar assistance was given a birth by you, a few years ago… when the app is just a bit complex, then it dose not work. so I never use it.
The name of the app is USCities. I may have stumbled upon what killing this whole thing.
Right now, you cannot filter by Text-type columns. You can overcome this limitation by converting your Text columns to Enum. For example, if you want to filter your data by State, make sure that your State column is an Enum with a list of states as its Enum Values.
I’m sure my attempts to search with the assistant was done without having the text declared as enums.
This is a huge limitation if it’s saying what it appears to be saying. For this particular app it isn’t a big deal but this is just a test app. The real app will be one that searches resumés which will contain a lot of text that cannot be expressed as an enum. The resumés will have been parsed and saved in excel sheets which will be the source data for the app.
The goal will to be able to ask something like “Show me the candidates who have worked at XYZ Company within the last 5 years” and to get the results in a list of the matching resumés.
Is this doable?
Hi @TM_Vis, that makes sense - the assistant doesn’t provide interpretations for text columns. It does work with one-to-many relationships. For example, if every Order has a Customer, you can say something like “Show me Bob’s orders”.
It sounds like your use case is more complex, though. You have a many-to-many relationship between Candidates and Companies, since a Candidate can work at many Companies and a Company can employ many Candidates. This is unfortunately not supported by the assistant feature right now, but it is an interesting use case that I will track. Do you mind if I move this thread to feature requests?
Thanks for the assessment of the situation. And yes I"m fine with move the thread to feature requests.
One more question. When the limitation states " Right now, you cannot filter by Text-type columns." . does it mean only “text” columns or does it take in columns of type “Address”, “Name”, “Email”, “Date” etc.?
That’s correct - those count as text.