Skip to main content

AI Formula Generator

Learn, how to use "artificial intelligence" to generate own data fields

The AI formula generator is still in the beta phase, but already delivers great results and is constantly being improved. However, if something does not work on the first attempt, try again immediately or later.

You are here: Start -> Settings -> Your data fields

With the AI formula generator, you can generate a formula from natural language - without any programming knowledge. Simply describe the functions that your data field should fulfill in the form of a prompt, and our AI will generate the appropriate formula for you.

Create a data field with AI

  1. Click on "Apply custom data field".

  2. Choose "AI formula generator".

  3. Click "Choose data field" to select a data field, that will be used in the prompt. You can choose as many data fields as you need.

  4. Now two different fields will pop-up, where you need to enter the name and type of the source data field:

    1. Name: The name is an alias that you can use in your description (prompt) if you are referring to the source data field.

    2. Data type: Use the data type to determine whether the parameter data in the formula is treated as text or number.

  5. In the "Prompt" field, enter as precise a description (prompt) as possible of what you expect from your data field or its formula. You can find examples below.

  6. Click "Generate formula". After a short moment, you will see the result for a randomly selected item in the preview area on the right.

  7. Check the function of the data field with a "Test in full".

  8. If everything is correct, save your entries via "Save settings"

Edit formula

You can update the formula at any time using a new, customized prompt and clicking on "Generate formula". This will overwrite the previous formula. For correction, reference can be made in the new prompt to the last formula created in the data field.

It is also possible to adjust the formula manually.

  1. Click on "Show formula". This will unfold a field in which you can view and check the formula.

  2. You can switch to manual editing mode by clicking in the field. Confirm this in the pop-up that appears.

The change from "AI mode" to "manual editing mode" is irreversible after confirmation. However, the prompt originally used is saved commented out under the formula.

To get AI support again, a new data field must be created with the AI formula generator. You can then use the saved prompt again.

Prompt-Examples

Example 1

Source data fields: Title, description, price

Prompt: "String together title, description and price, separated by commas. Shorten the string to 50 characters if necessary."

Example 2

Source data field: Price

Prompt: "Reduce my prices by 10% every Saturday and write 'Saturday offer on' with the respective date behind it."

Example 3

Source data fields: Name, color, size, price

Prompt: "Build a product name from name, color and size. Then add a currency symbol and round the price to two decimal places."

Example 4

Source data field: category-tree

Prompt: "Replace | with > from my category-tree"

Did this answer your question?