Vladi Gubler
Vladi Gubler
May 15, 2024

Hi,

As we continue our integration of OpenAI compabilities in Ultimate Forms, we are now adding a new function $Rewrite. Similar to the rewrite functionality in multiple lines of text column I introduced in my previous blog, it leverages the power of OpenAI to modify input text, be it rewriting in a different writing style or translating into a different language. As a function, it can be used in a variety of places within Ultimate Forms, for instance:

  • In dynamic rules on forms, to copy modified value into a different column in real time.
  • In Actions, to rewrite and/or translate text and then update the item (or create a brand new item).
  • In Import, to ensure imported text is always in the same language, regardless of how it was in the source.
  • In Alerts, to translate text into the preferred language of the recipient.

As always with our functions, it's simple and easy to use. The function receives three parameters, separated by the | sign:

  1. Text - input text, a combination of static text, column values and functions.
  2. Style - (optional) the writing style to rewrite the text in, such as "formal", "business" or "technical". You can enter any style here, in English only, and the AI engine will attempt to accomodate your request. When left empty, the original text style is preserved.
  3. Language - (optional) locale ID of the language to translate to. You can find the list of most common locales here.

For example, $Rewrite([Body]||es-ES) will take the text from the column Body and translate it into Spanish (Spain), while preserving the original style. Another option: $Rewrite([Body]|formal|) - will rewrite the text from the column Body and rewrite it in the formal style, without translating.

You'll be happy to know that if the input is rich text (includes formatting), the engine will do its best to preserve the same formatting, whenever possible. So for example, originally bold text will remain bold in the Spanish translation as well.

Let's see how we can implement it on a form.

  • Create a list with two multiple lines of text columns: Body and Spanish (you can of course use any names).
  • Click on Design -> Form Designer and generate a form for the list.
  • On the design canvas, click to select Spanish column, then in the right pane find the Rules section and click to add a new rule.
  • Configure your rule as following:
  • It will now translate the text from the column Body into Spanish (Spain) and place it in the column Spanish. You can of course further enhance the rule with conditions if desired.
  • Publish your form.

If you now open New form to create an item and start entering text into Body, the Spanish translation will appear in the column Spanish after a short delay:

And of course functions are not limited just to forms, we can easily implement them in very much the same way in other components as well, such as Actions:

As you see, this Update list item action does pretty much the same thing - translates and save the text from the column Body in the column Spanish.

Feel free to implement this powerful tool in your own solutions!

Loading...

Add your comment

Comments are not meant for support. If you experiencing an issue, please open a support request.
Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution
It’s never been easier to create, innovate, and share. All you need is your web browser!
Cost-Effective
Address business process pain points immediately. Save time and money.
Fantastic Support Team
In addition to our responsive support team, a wide variety of resources, documentations, tutorials, blogs and webinars is available to you
WELCOME TO THE FUTURE
New faster ways for creating business solutions
ULTIMATEforms is a platform that enables everyone to easily create and maintain Microsoft SharePoint-based business solutions without a single line of code
Simple and Intuitive
Streamline form creation with smart, user-friendly tools
Deploy smart dynamic forms that adapt to your business needs
Utilize a drag-and-drop interface for effortless form design
Experience rapid form customization with intuitive editing tools
Accelerate project timelines with user-friendly, immediate solutions
Powerful Automation
Enhance operational efficiency and compliance
Streamline complex workflows into straightforward actions
Quickly establish compliant business processes
Seamlessly integrate data from diverse applications
Access and combine information easily for better decision-making
Comprehensive Reporting
Transform data into actionable insights
Generate detailed reports and dashboards for informed decision-making
Customize alerts and notifications to stay updated
Print and export data to PDF, Excel, or Word for easy sharing
Visualize data with color-coded calendars and intuitive dashboards
100’s of Templates
Streamline form creation with smart, user-friendly tools
Access hundreds of customizable templates for every business function
Install easily with one-time set-up; free for ULTIMATEFORMS customers
Replicate entire sites with settings between site collections and tenants using Template Manager
Jumpstart projects with pre-built solutions from our growing catalog, applied with a click
Dive deeper
Watch a short introductory video showcasing the different unique capabilities of UltimateForms.
Ready to get started?
Hands-on training is the best way to get proficient. That's why we've created three unique training offerings which will help you master ULTIMATEFORMS. Our interactive sessions are delivered via web meetings and conducted within personal virtual workspaces.
100% No-Code Solution
It’s never been easier to create, innovate, and share. All you need is your web browser!
Cost-Effective
Address business process pain points immediately. Save time and money.
Fantastic Support Team
In addition to our responsive support team, a wide variety of resources, documentations, tutorials, blogs and webinars is available to you
Microsoft partner logo GSA Schedule
© 2005-2024 Infowise Solutions Ltd. All rights reserved.
Privacy | Accessibility | Cloud SLA