How do I generate and append JSON from a submitted form

Hi ​@Callan.Applebee 

Can you provide a bit more info on the use case for the JSON?  There are ways to get the JSON for a start event but generally if you need to use the form data for something you’d want to just leverage the workflow to perform whatever process you’re looking at instead.

Hi there ​@brent_read. The use case is:

> User (clinic reception/staff) completes a form that has several questions like, attending physician, location this is being requested from, contact name + email and address in the form of (drop downs, text fields, choice selection where applicable) and some repeat sections requesting detailed information (patient names, procedure, site, dates etc. Being a repeat section enables the user to add multiple patients onto the 1 form for submission.

The Output is in the form of an action which provides a summary of the questions and answers submitted. The summary can be saved in the form (natively) as a PDF or as a JSON file.

This particular process saves it as a JSON and sends it via email to a nominated inbox.

The recipients of said email then use the JSON file to be consumed by a medical application which uses that data and adds to patient files (or create them) and then does what it needs to do via it’s connections to other systems.

Essentially, once a form has been submitted with whatever content, i would like the Nintex form to either have an action that can summarise and create the JSON -irrespective of the project and not require (if possible) building strings etc… 

If you want something to compare it to - this form is from SmartComms using SmartIQ and can perform things like this without coding.

Hi ​@Callan.Applebee,

Suggested solution:
Feed all your form variables to the AI Action Summarize text.
Give it instructions like:
Create a JSON String and output an encoded string that can be decoded to a file called object.json
https://help.nintex.com/en-US/nwc/Content/Designer/Actions/AIActions-SummarizeText.htm

Grab the encoded string from the output and pass it through the Decode a Base64 String action, which you can find in the Nintex Gallery. https://gallery.nintex.app/gallery/t/toolkit-for-nwc

The output will be a .JSOn file that you can attach to an email.

thank you for that. Unfortunately we are on an older skew and do not have the AI Action / functions. Any other suggestions? 

Hi ​@Callan.Applebee 

Just enable them in the tenant settings.

 

As I mentioned, we do not have it applicable.