Skip to main content
August 5, 2022
Question

Want to Store 3 grid column values into 1 rule input

  • August 5, 2022
  • 4 replies
  • 0 views

In this grid i have first name ,middle name, last name, these three variables while submitting i want to store it in one rule input.

Example :John jackie smith  (it should display like this)

can anybody help me on this

    4 replies

    mikes0011
    Brainy
    August 5, 2022

    This is pretty much the most basic example for when to use a CDT.  That is to say, in your case, you'd have a CDT called "Person" or similar, it would have fields including "firstName", "middleName", and "lastName", and your rule input would be an array of that CDT (and individual rows of the editable grid would address their specific row member).

    The Expression Guru
    August 5, 2022

    In cdt i have only one column called as "Name"(first name, middle name, last name) All 3 first name, middle name, last name should save under CDT person column name "Name"

    mikes0011
    Brainy
    August 5, 2022

    IMHO the only really good way of dealing with this, then, would be to have just one text field for "name".

    Even if you can concat the 3 pieces together into the "name" CDT parameter upon entering them into the Editable Grid fields, you're going to have an extremely difficult time separating them back out to populate the individual values for those fields.

    What is your use case for having 3 separate entry fields but not storing the values separately?

    The Expression Guru