AI Productivity Helpers - Revision history

Dgreenwood at 20:39, 1 July 2025

2025-07-01T20:39:57Z

← Older revision		Revision as of 15:39, 1 July 2025
Line 15:		Line 15:

	'''List of AI productivity tools:'''		'''List of AI productivity tools:'''
	* AI Generated Schema Importer		* AI Generated (Schema Importer)
	* AI Query Helper		* AI Query Helper
	* AI Expression Helper		* AI Expression Helper

Dgreenwood at 20:39, 1 July 2025

2025-07-01T20:39:24Z

← Older revision		Revision as of 15:39, 1 July 2025
Line 10:		Line 10:
	\|		\|
	You may download the ZIP(s) below and upload it into your own Grooper environment (version 2025). The first contains one or more '''Batches''' of sample documents. The second contains one or more '''Projects''' with resources used in examples throughout this article.		You may download the ZIP(s) below and upload it into your own Grooper environment (version 2025). The first contains one or more '''Batches''' of sample documents. The second contains one or more '''Projects''' with resources used in examples throughout this article.
	* [[Media:2025 Wiki - AI Productivity ~~Helper~~ Batches.zip]]		* [[Media:2025 Wiki - AI Productivity Helpers Batches.zip]]
	* [[Media:2025 Wiki - AI Productivity ~~Helper~~ Projects.zip]]		* [[Media:2025 Wiki - AI Productivity Helpers Projects.zip]]
	\|}		\|}

Dgreenwood at 20:38, 1 July 2025

2025-07-01T20:38:25Z

← Older revision		Revision as of 15:38, 1 July 2025
Line 4:		Line 4:
	There are several productivity features in Grooper that use large language models (LLMs) to simplify a users work in Grooper. LLMs (such as OpenAI's GPT models) allow users to tell Grooper what to do using a natural language text prompt. There are currently six (6) of these features in Grooper version 2025.		There are several productivity features in Grooper that use large language models (LLMs) to simplify a users work in Grooper. LLMs (such as OpenAI's GPT models) allow users to tell Grooper what to do using a natural language text prompt. There are currently six (6) of these features in Grooper version 2025.
	*<li class="attn-bullet"> '''''BE AWARE!''''' For each of these features to work, users must first have an '''''[[LLM Connector]]''''' configured at the Grooper Root node and a "Tools Chat Model" configured.		*<li class="attn-bullet"> '''''BE AWARE!''''' For each of these features to work, users must first have an '''''[[LLM Connector]]''''' configured at the Grooper Root node and a "Tools Chat Model" configured.

			{\|class="download-box"
			\|
			[[File:Asset 22@4x.png]]
			\|
			You may download the ZIP(s) below and upload it into your own Grooper environment (version 2025). The first contains one or more '''Batches''' of sample documents. The second contains one or more '''Projects''' with resources used in examples throughout this article.
			* [[Media:2025 Wiki - AI Productivity Helper Batches.zip]]
			* [[Media:2025 Wiki - AI Productivity Helper Projects.zip]]
			\|}

	'''List of AI productivity tools:'''		'''List of AI productivity tools:'''
Line 9:		Line 18:
	* AI Query Helper		* AI Query Helper
	* AI Expression Helper		* AI Expression Helper
	* Db Lookup Helper		* AI Database Lookup Helper
	* ~~XSLT~~ Helper		* AI XML Transform Helper
	* AI Helper		* AI Helper

Dgreenwood: /* AI Helper: Get help all over the place in Grooper */

2025-07-01T20:23:22Z

AI Helper: Get help all over the place in Grooper

← Older revision		Revision as of 15:23, 1 July 2025
Line 177:		Line 177:
	[[File:AIHelper-prompt.png\|class=simpleshadow simpleborder\|right]]		[[File:AIHelper-prompt.png\|class=simpleshadow simpleborder\|right]]
	<div class="flowlist">		<div class="flowlist">
	The "AI Helper" is a general purpose helper available to many editors in Grooper. You can access the AI Helper in any of Grooper's "Code Editors". These editors show up when editing many different properties in Grooper. Just look for the "AI Helper" button at the top of the editor.		The "AI Helper" is a general purpose helper available to many editors in Grooper. You can access the AI Helper in any of Grooper's "Code Editors". These editors show up when editing many different properties in Grooper (and not just when you're editing code expressions!). Just look for the "AI Helper" button at the top of the editor.

	"AI Helper" uses include:		"AI Helper" uses include:

Dgreenwood: /* AI Helper: Get help all over the place in Grooper */

2025-07-01T20:22:47Z

AI Helper: Get help all over the place in Grooper

← Older revision		Revision as of 15:22, 1 July 2025
Line 177:		Line 177:
	[[File:AIHelper-prompt.png\|class=simpleshadow simpleborder\|right]]		[[File:AIHelper-prompt.png\|class=simpleshadow simpleborder\|right]]
	<div class="flowlist">		<div class="flowlist">
	The "AI Helper" is a general purpose helper available to many editors in Grooper. ~~Its~~ uses include:		The "AI Helper" is a general purpose helper available to many editors in Grooper. You can access the AI Helper in any of Grooper's "Code Editors". These editors show up when editing many different properties in Grooper. Just look for the "AI Helper" button at the top of the editor.

			"AI Helper" uses include:
	* Get help creating list entries for List Match.		* Get help creating list entries for List Match.
	* Get help with Grooper code expressions (Default Value, Calculated Value etc).		* Get help with Grooper code expressions (Default Value, Calculated Value etc).

Dgreenwood: /* AI Helper: Get help all over the place in Grooper */

2025-07-01T20:21:09Z

AI Helper: Get help all over the place in Grooper

← Older revision		Revision as of 15:21, 1 July 2025
Line 174:		Line 174:

	=== AI Helper: Get help all over the place in Grooper ===		=== AI Helper: Get help all over the place in Grooper ===
			[[File:AIHelper-icon-big.png\|frame\|left\|Just look for the "AI Helper" button.]]
			[[File:AIHelper-prompt.png\|class=simpleshadow simpleborder\|right]]
			<div class="flowlist">
	The "AI Helper" is a general purpose helper available to many editors in Grooper. Its uses include:		The "AI Helper" is a general purpose helper available to many editors in Grooper. Its uses include:
	* Get help creating list entries for List Match.		* Get help creating list entries for List Match.
Line 183:		Line 185:
	* Get help making instructions for AI Extract.		* Get help making instructions for AI Extract.
	* Get help making a Description for a Grooper node.		* Get help making a Description for a Grooper node.
			</div>

Dgreenwood: /* AI DB Lookup Helper: Get help writing SQL queries for Database Lookup */

2025-07-01T20:01:19Z

AI DB Lookup Helper: Get help writing SQL queries for Database Lookup

← Older revision		Revision as of 15:01, 1 July 2025
Line 132:		Line 132:
	# Press the "OK" button in the Lookups editor when finished.		# Press the "OK" button in the Lookups editor when finished.
	# Press the Save button ({{SaveIcon}}) when to save changes to the Data Element.		# Press the Save button ({{SaveIcon}}) when to save changes to the Data Element.
			<div style="position: relative; box-sizing: content-box; max-height: 80vh; max-height: 80svh; width: 100%; aspect-ratio: 1.7777777777777777; padding: 40px 0 40px 0;"><iframe src="https://app.supademo.com/embed/cmcklm9x00437xt0irm64p9ih?embed_v=2" loading="lazy" title="New Demo" allow="clipboard-write" frameborder="0" webkitallowfullscreen="true" mozallowfullscreen="true" allowfullscreen style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;"></iframe></div>

	=== AI XML Transform Helper: Get help making XSLT transforms ===		=== AI XML Transform Helper: Get help making XSLT transforms ===

Dgreenwood: /* AI DB Lookup Helper: Get help writing SQL queries for Database Lookup */

2025-07-01T19:23:28Z

AI DB Lookup Helper: Get help writing SQL queries for Database Lookup

← Older revision		Revision as of 14:23, 1 July 2025
Line 119:		Line 119:
	#:*<li class="fyi-bullet"> Database Lookups can be added to {{DataModelIcon}} Data Models, {{DataSectionIcon}} Data Sections, or {{DataTableIcon}} Data Tables.		#:*<li class="fyi-bullet"> Database Lookups can be added to {{DataModelIcon}} Data Models, {{DataSectionIcon}} Data Sections, or {{DataTableIcon}} Data Tables.
	# Under the "Behavior" properties, open the "Lookups" editor (Press the "..." button).		# Under the "Behavior" properties, open the "Lookups" editor (Press the "..." button).
	# If not done so already, add a Database Lookup specification.		# If not done so already, add a Database Lookup specification. Otherwise, select a Database Lookup specification from the list.
	# If not done so already, configure the "Database Connection" property by selecting the {{DataConnectionIcon}} Data Connection in your {{ProjectIcon}} Project.		# If not done so already, configure the "Database Connection" property by selecting the {{DataConnectionIcon}} Data Connection in your {{ProjectIcon}} Project.
	# Open the "SQL Query" editor (Press the "..." button).		# Open the "SQL Query" editor (Press the "..." button).

Dgreenwood: /* AI DB Lookup Helper: Get help writing SQL queries for Database Lookup */

2025-07-01T16:14:42Z

AI DB Lookup Helper: Get help writing SQL queries for Database Lookup

← Older revision		Revision as of 11:14, 1 July 2025
Line 104:		Line 104:
	=== AI DB Lookup Helper: Get help writing SQL queries for Database Lookup ===		=== AI DB Lookup Helper: Get help writing SQL queries for Database Lookup ===
	[[File:AIDBLookupHelper-prompt.png\|frame\|left\|This query was generated by AI DB Lookup Helper.]]		[[File:AIDBLookupHelper-prompt.png\|frame\|left\|This query was generated by AI DB Lookup Helper.]]
			<div class="flowlist">
	"Lookup Specifications" (or "lookups") are used in Grooper to take data extracted in a document and use it to find data in external sources like in databases, XML files, or web services. This can help validate document data and populate additional data not present on the document.		"Lookup Specifications" (or "lookups") are used in Grooper to take data extracted in a document and use it to find data in external sources like in databases, XML files, or web services. This can help validate document data and populate additional data not present on the document.

Line 111:		Line 111:
	What if you don't know how to write a SQL query? "AI DB Lookup Helper" is here for you!		What if you don't know how to write a SQL query? "AI DB Lookup Helper" is here for you!
	*<li class="attn-bullet"> Be aware! You should always verify the query is correct and does not unintentionally alter your database before putting it in production. It is possible for an AI to generate queries with statements that make changes to a table (UPDATE, INSERT, DELETE). If the Data Connection user has rights to alter the database, the Database Lookup will alter your database.		*<li class="attn-bullet"> Be aware! You should always verify the query is correct and does not unintentionally alter your database before putting it in production. It is possible for an AI to generate queries with statements that make changes to a table (UPDATE, INSERT, DELETE). If the Data Connection user has rights to alter the database, the Database Lookup will alter your database.
			</div>
	<br clear=all>		<br clear=all>

Dgreenwood: /* AI Helper: Get help all over the place in Grooper */

2025-07-01T16:13:08Z

AI Helper: Get help all over the place in Grooper

← Older revision		Revision as of 11:13, 1 July 2025
Line 178:		Line 178:
	** Calculated Value Example: ''Make an expression to calculate the total amount due from the all rows in the Invoice Line Items table.''		** Calculated Value Example: ''Make an expression to calculate the total amount due from the all rows in the Invoice Line Items table.''
	** Calculated Value Example: ''Make sure this number is what it's supposed to be.''		** Calculated Value Example: ''Make sure this number is what it's supposed to be.''
	**: '''Author's note:''' I asked the AI to see if it would make the right expression to ensure a ~~"Total Price"~~ value in an invoice line items table equaled the unit price multiplied by the quantity. Even with that little context, the AI came up with the right expression (However, I'm unsure how an AI would respond to that prompt in all cases).		**: '''Author's note:''' I asked the AI to see if it would make the right expression to ensure a line total value in an invoice line items table equaled the unit price multiplied by the quantity. Even with that little context, the AI came up with the right expression (However, I'm unsure how an AI would respond to that prompt in all cases).
	* Get help making instructions for AI Extract.		* Get help making instructions for AI Extract.
	* Get help making a Description for a Grooper node.		* Get help making a Description for a Grooper node.