• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 14 replies
  • Answers 2 answers
  • Subscribers 19 subscribers
  • Views 7262 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Inserting data to table from an interface using process model

shyamil_iyyakandy

 Hi 

I'm new to Appian. I tried doing the following the steps to insert data to my table.

  1. Created a CDT with 3 elements
  2. Added the entity to the Appian datasource
  3. Created a form having 3 input text fields. Added 3 corresponding rule inputs and mapped them to 3 text fields by changing the "SaveTo" and "DisplayValue"  field for all 3 components . 
  4. Finally saved the interface as an action
  5. Added the form interface to my site.
  6. Edited the action created in step 3.(In Process modelling window ).
  7. Added a user input task in my process flow
  8. Added a write to datastore entity in my process flow
  9. saved and publish the process model.
  10. refreshed my site.

Whenever i enter any data in my text fields in the form, the data disappears when i click outside the text box (the screen reloads as well).

I want to insert data to DB on click of my submit button in the form. Am not sure if i have configured the data mappings properly in 'user input' and 'write to datastore entity'.

Can someone help me figuring out what the issue is?

Thanks,

Shyamil

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1

    Hi Shyamil,

    My guess is that you didn't select your variables to get saved within the form in the process model.

     

    Also i would suggest you to debug in the following way.

    1.- Check your interface in expression mode and change some values in the text fields then verify if your Rule inputs are getting values. ( If they do that means your interface is working fine).

    2.- Moving to the process model verify your interface node and check if you have the process variables (Those are used to pass data around the process model and that is how you can connect your data in the interface and the process model).

     

     

    3.- Run an instance of the process model so you can see realtime values of the variables. ( I believe you don't need any previous values  so control + D) will work on your process model so you can see what values are over there in the process model.

     

     

     

  • 0 in reply to Jose Cavazos
    Hello ,
    Follow the all Step that explain by and after that to insert that data into Appina Cloud database you have to use "Write to Data Store Entity" data service.
Reply Children
No Data

© 2024 Appian. All rights reserved.