Skip to main content
S
shubhamy3376
January 30, 2024
Question

Save to DB

  • January 30, 2024
  • 6 replies
  • 0 views

Hi Everyone,

I need to store the values of lablels in col1, corresponding to col2 and col3 which are checkboxes into database and retrive it when the interface is loaded. Can anyone please help me out how to achieve this?

    6 replies

    harshitb6843
    harshitb6843
    January 30, 2024

    Do you just want to store if the lable1, col1 combination was checked or not? and similarly for all the combinations?

    S
    shubhamy3376Author
    January 30, 2024

    right, labels and their selection values whether checked or not.

    harshitb6843
    harshitb6843
    January 30, 2024

    If the columns are fixed and will never increase or decrease, then the easiest way will be to create a dedicated column for every property in table an and use it in your editable grid. 

    If the column count isn't fixed, then you can use the below structure. 

    Label Property IsActive
    Col1 Property1 TRUE
    Col1 Property2 FALSE
    Col2 Property1 TRUE
    Col2 Property2 TRUE
    abhayd3663
    abhayd3663
    February 2, 2024

    You need to have a CDT (with 3 fields -col1,col2,col3) which represents this tabular structure. Then you can use it in grid or any other layout.

    Terms & ConditionsAccessibility statement