The ability to create Adaptive Forms based on JSON schema was introduced with AEM Forms 6.3 release. The details on creating Adaptive Forms with JSON schema are explained in detail in this article.
Once you create Adaptive Form based on JSON schema, the next step is to store the submitted data in database. For this purpose we will use the new JSON data type introduced by various database vendors. For the purpose of this article we will use MySql 8 database to store the submitted data.
The ability to create an Adaptive Form based on JSON schema was introduced with AEM Forms 6.3 This article explains authoring of JSON schemas and using them as the basis for creating Adaptive Forms.
Once you author the Adaptive Form based on JSON schema, the next step is to store the submitted data in the database of your choice.
For the purpose of this article, we will be using MySql 8 database. MySQL introduced a new data type called JSON. This makes it easier to store and query JSON objects. We will be storing the submitted data in a column of type JSON in our database.
The following screen shot shows the submitted form data stored in JSON data type . The column "formdata" is of type JSON. We also stored the name of the form associated with the data in the column formname
Please make sure your json schema file is named appropriately. For example it needs to be named in the following format <name>schema.json. So your schema file can be mortgage.schema.json or credit.schema.json.