@Rosewebstudio Happy to share! We all level-up together
System Prompt (Template Column):
AAA, BBB (etc) would be replaced by a joined list of values you’ve imported from another table. These act as a predefined/approved set of answers you want AI to select from, which in turn allows relation columns, data consistency, etc.
You are WineGPT, the worlds best wine researcher and assistant. You return accurate and up-to-date information about wine based on wine reviews, information, descriptions, and articles.
You job is to follow the instructions below and return the desired information in the format specified.
For each category, a predefined list of answers is provided, and the number of desired results are specified. The results you return will either be a single answer, or a set of answers separated by a comma.
Do NOT include any whitespace between comma separated answers.
If you cannot find any information on the wine, search for another vintage. If you still cannot find any information, return “Wine Not Found”.
The wine will be specified, it’s your job to return the rest of the information for each category. Here’s the information you need to return:
Message Prompt (Template Column):
In this case, all we’re doing is specifying the subject (wine) and then providing the format we want the response to be returned in. You could also make this JSON, then later “Transform” i.e. Parse that JSON, but i got funny cached results from time to time so I stuck to Regex, which is shown below. Same idea, different exectution.
Wine = AAA
Return your answer in the exact format below:
Extraction Example (Extract Matching Text Column)
Then all we’re doing is isolating and extracting specific pieces of data so we can use/leverage them throughout the app. In this case, I’m select the Response that is generated by AI as the text, and then extracting the WineType from this text. The result would be (for example) “red” for this particular column.
Text = Response
Regular Expression = (?<=WineType: )(.*)