Optimal Database Structure for Automatic Categorization Using Keywords and Synonyms

Need help Database
1

I’m uncertain about how to best structure my database to accommodate the new workload metric.

Users input text that needs to be matched against keywords and synonyms for automatic categorization into a category and optionally a subcategory. The text should then be stored in the database along with its respective category and subcategory.

Currently, all categories and subcategories are set up as Option Sets, which is working well. My questions are:

  1. Are Option Sets the right choice for this scenario?
  2. How do I write expressions to match user input against keywords and synonyms within both categories?
  3. How do I maintain keywords and their synonyms within Option Sets?

Thanks for your help!

2

You should use dataset and then add them as a list of the thing to the user input. Males keywords and synonyms much easier and allows you to dynamically create sub categories

3

Unfortuanatly no succsess with the following steps (blue expessions)

  • Created a data type “Category” with fields “Name” (text) and “Keywords” (text list).
  • Then, added categories as new entries using app data, listing keywords individually.
  • Saved the Input Text via a button in the workflow to save under a data type “Requests”.
  • Used “Makes changes to a thing (Step of result 1)” where Category = Do search for Categorys:first item + constraint “keywords contains input texts value”