Skip to main content
R
ritvikrajp0001
August 30, 2021
Question

How we can perform CRUD operations on data in interface

  • August 30, 2021
  • 5 replies
  • 0 views

Hi folks ,

I have a look up  table named "gender" , I want to develop a interface using which i can see,  add add, update , delete values in table without going in the appian cloud directly instead we want to perform this from the interface .

For example i have genderId and gender column in lookup table , where there are two entries male with id 1 and female with id 2 , how can we add another gender in the table  directly or delete male row  from the table or update it.

I hope you guys understood my query .

Thanks in advance. 

    5 replies

    daisym0004
    daisym0004
    August 30, 2021

    make use of entity backed record 

    N
    nitesht9652
    August 31, 2021

    Try using record action on the UI - docs.appian.com/.../Record_Action_Component.html

    harshas2775
    harshas2775
    August 31, 2021

    You can create an editable grid where data from lookup table can be rendered. In your case two columns for gender id & gender value. 

    Then you can give button on click of which you can call a!writeToDataStoreEntity() and insert/update the data. If you are not already familiar how to user this, you can find the documentation here. Similarly for deletion also you can user Delete from data store entities smart service within the interface itself. 

    Take a look at this recipe as well, as I think its suites exactly to your requirement. You just need to handle writing into and deletion from the data store entity!

    scottf0004
    scottf0004
    June 3, 2024

    Probably because this post is > 3yrs old, none of the links in your answer work anymore. This is not helpful.

    peter.lewis
    peter.lewis
    Employee
    June 3, 2024

    Usually if you change the version number in any links you find to the current version, it will still work! For instance, all of the links above are for 21.3 - if you change the number in the URL to 24.2 instead, you should see the new version of those pages [emoticon:c4563cd7d5574777a71c318021cbbcc8]

    Terms & ConditionsAccessibility statement