Could an AI field do this?

Bitstreams · October 13, 2025, 8:58am

I am having a play with a potential workflow in softr databases and I’m wondering if an AI field could help.

I have a table containing containing known products - for the sake of argument assume Make, Line, Model

Make	Line	Model
Century	Toolpro	7
Century	MasterTool	76a
Washington	FixMaster	Professional 5

Then I get a submission from a client (as an import) with the same columns, but crucially they don’t have sight of the data in our products table.

Make	Line	Model	Suspected product (AI result)	Linked record
Century	Toolpro	7	Found	Century Toolpro 7
Century	Master Tool	76a	Close match	Century Mastertool 76a
Washington	Fixmaster	Pro 5	Close match	Washington Fixmaster Professional 5
Washington	Fixmaster	Elite	Not found

At present, we are manually checking for data matches between the submissions and our data stores. We are also working at guiding the submissions so that they are choosing from pre-defined options based on our data, but that’s not always possible.

I am hoping that an AI field could assist with this process, allowing the operator to approve close matches? Obviously, we’re not talking about products as I’d just publish a product list. This is just an example.

sveta.ohanyan · October 16, 2025, 10:41am

Hi @Bitstreams.

Yes, you can indeed do it with our AI fields. The prompt, for the scenario you described will look something like this.

For each value in the Link field, compare it to all options in the Line field and assign one of the following labels:

- “Found”: Assign if there is an exact match between Link and any Line option, or if the Line option is fully contained within the Link value (e.g., Line = “Toolpro”, Link = “Century Toolpro 7”).

- “Close Match”: Assign if there is a partial match or high similarity (such as minor spelling differences or similar wording) between Link and any Line option.

- “Not found”: Assign if there is no sufficiently similar Line option, or if the Link value is empty.

We have also Improve my prompt option for the AI fields and you can use it to optimize and customise the prompt according your needs.