You are viewing limited content. For full access, please sign in.

Question

Question

Value changing on table insert in Forms in Cloud

Forms Laserfiche Cloud Business Processes
Updated January 8
asked on October 17, 2024

 

I am having an issue with a checkbox on a form.  When the form is submitted, the value of the checkboxes chosen are correctly stored in the add_school_groups variable as shown below.   [Screenshot 2024-10-17 at 11.57.40 AM.png]

When that value is used during a table insert, the underscore is removed from the value during the table insert process.  When inserted into the table, the value becomes Student Records-SpeEd Teacher as shown below. [Screenshot 2024-10-17 at 12.00.51 PM.png]

This causes a major hiccup in my routing because the system is looking for the underscore. Why is this underscore being dropped during the table insert?  The other values that I insert with underscores are not affected, but they are also not checkboxes.  They are dropdowns in the form. This is in Cloud. 

0 0

Replies

replied on October 17, 2024

Just want to clarify a few things before I look into this further/create a bug.

  1. Which form designer are you using to capture the checkbox fields?
    1. This shouldn't matter but helps us track the issue down and reproduce it
  2. Are you are adding this to a cloud lookup table?
1 0
View 1 previous reply
replied on October 18, 2024

I'm using the new form designer and adding the data to a cloud lookup table in my Global scope.  (everything is in Global for this project).

0 0
replied on October 24, 2024 • Show version history

Is this still an issue for you? We just made some changes to checkbox label vs value in business processes. I also wanted to confirm that you are using a checkbox and not another field type like radio button for example.

What I'm seeing:
1. Both Forms Rules and WF Rules are using non-spaced (label) for insert

2. The variables tab is also showing non-spaced (label) for the field value

1 0
replied on December 6, 2024

I am only seeing this issue on checkboxes.  I double checked and it looks like the issue is still there.  The display value and the value of the checkboxes are coming from a lookup.  Both the display value and the value are the exact same (ie. with the underscores).  When I see the checkbox display value on the form, the underscores are showing.  When I submit the form, the underscores are missing from the value inserted into the table.  I hope this helps.

0 0
replied on January 8

Hey Zachary I just wanted to check in on this one and see if there was an update.  Thanks. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...