• State Suggested Answer
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 2405 views
  • Users 0 members are here
Related Discussions
Home » Discussions » New to Appian

Auto filled data in the form is not saving to DB

Madhu Tiwari

Use Case: A form as 10 fields out of which 4 are auto filled when a user lands on the page (auto filled fields are: 1. create date , 2. modified date, 3.created by and 4.modified by), rest 6 fields requires users input. When user saves the form by clicking on save button the system is giving the message as it is saved. However, it doesn't save the data to the DB.

While manual debugging when the user modifies the auto-filled fields and then clicks on save button then all the data in 10 fields are saving to DB. I am not sure what is missing.

I followed this tutorial to create this form -https://docs.appian.com/suite/help/21.3/Records_Tutorial.html

For autofill of 4 fields I have used following functions:

1. create date: local!storedValue:now()

2. modified date: local!storedValue:now()

3.created by: loggedInUser()

4.modified by: loggedInUser()

Can someone help in fixing this issue? Thanks!

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Associate Developer

    Are you saving the data from the local variables to the CDT fields using a!save function? Because before you submit the form you need to save it in the CDT fields.

  • 0 in reply to leonclintonc

    yes i did save in the CDT field.

    my code is:

    a!localVariables(

                  local!storedValue:now(),

                  a!dateTimeField(

                    label: "Created Date and Time",

                    value: if(ri!ED__DT_iwmsReferences.referenceId,   ri!ED__DT_iwmsReferences.createddate,  local!storedValue),

                    saveInto: ri!ED__DT_iwmsReferences.createddate

                  )

                ),

  • 0
    Certified Associate Developer
     in reply to Madhu Tiwari

    You have an IF condition in the "value" parameter. I suppose it works fine for the first condition but doesn't save the data for the second condition. So in that case, check out this code snippet:

    a!localVariables(
    a!formLayout(
        contents:
        {
            local!storedValue: now(),
            a!dateTimeField(
            label: "Created Date and Time",
            value: if(ri!ED__DT_iwmsReferences.referenceId, ri!ED__DT_iwmsReferences.createddate, local!storedValue),
            saveInto: ri!ED__DT_iwmsReferences.createddate
            ),
        },
        buttons:
        a!buttonLayout(
            primaryButtons: 
            a!buttonWidget(
                label: "Submit",
                value: true,
                saveInto: 
                {
                    if(
                        ri!ED__DT_iwmsReferences.referenceId, {},
                        a!save(ri!ED__DT_iwmsReferences.createddate, local!storedValue)
                    )
                }
            )
        )    
    )
),

Reply
  • 0
    Certified Associate Developer
     in reply to Madhu Tiwari

    You have an IF condition in the "value" parameter. I suppose it works fine for the first condition but doesn't save the data for the second condition. So in that case, check out this code snippet:

    a!localVariables(
    a!formLayout(
        contents:
        {
            local!storedValue: now(),
            a!dateTimeField(
            label: "Created Date and Time",
            value: if(ri!ED__DT_iwmsReferences.referenceId, ri!ED__DT_iwmsReferences.createddate, local!storedValue),
            saveInto: ri!ED__DT_iwmsReferences.createddate
            ),
        },
        buttons:
        a!buttonLayout(
            primaryButtons: 
            a!buttonWidget(
                label: "Submit",
                value: true,
                saveInto: 
                {
                    if(
                        ri!ED__DT_iwmsReferences.referenceId, {},
                        a!save(ri!ED__DT_iwmsReferences.createddate, local!storedValue)
                    )
                }
            )
        )    
    )
),

Children

© 2024 Appian. All rights reserved.