Records Tutorial how to insert values into the table?

Question

Hi,
according to this tutorial i created custom data type and data store https://docs.appian.com/suite/help/18.1/Records_Tutorial.html
but i don't know how to:

5. Insert the following values into the table:

rohitr303 · Accepted Answer

Hi piotrb0002 , 
 
After you publish the data-store successfully with the appropriate data store entities in it , the respective tables will be created the database . 
 
Then you can insert records into table in following possible ways. 
 
1) Manually , by directly navigating to database i,e envts-url/.../index.php . Once you go here click on Appian database on the left hand side , inside it click on the tables and then select the table you want to insert record into . Then select the insert option and start adding the records to the table manually . 
 
2) Using a process model - This is a long procedure 
 - Create an interface which will capture all the fields that you want to enter into the database 
 - Create a process model which will call this interface in User input task . 
 - Use Write to datastore entity smart service to push the data captured from the user into the desired tables 
 
3) Like mentioned below by bhanuprakashm You can paste this data into excel and use excel to cdt plugin then insert into table using a!writetodatastoreentity funtion or use write to data store plugin from process model.

Hopefully this will help . 
 
Thanks, 
Rohit Ouhal

Brazil Vibanco · Answer

Hi piotrb002, 
 
You can go directly to the table and insert values manually, or using sql statements. Also you can create a process to insert values using the write to data store smart service - docs.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html - (also within an interface). 
 
Thanks

santoshd378 · Answer

Hi pitorb, 
 
Follow the simple steps. 
 
1.First you need to create a CDT(With Id as a primary key and auto generated) and then publish it as a data table in your DB through Data Store. 
2.Create an interface with some components(like text field or other components) and create a rule input with the CDT type you have created. 
3.Create a process model and configure the process start form, use the write to data store entity smart service to enter the values in DB. 
4.Publish the process model. Now you can debug your process model or you can publish the application and use it in the actions tab to enter the values in the fields of the interface and submit the form. Now the values will be entered into DB if there are no errors.

Records Tutorial how to insert values into the table?

Top Replies