Question

set business process variables taking negative away from numeric value

Workflow Forms Laserfiche

Updated December 19, 2018

asked on July 27, 2018

Hi Everyone

I have a strange one, passing a negative value like -99,66.33 via Workflow to Forms.

In using invoke a business process, the value is passed negativly, but in using Set Bussiness processs vairibles the value is turned into positive 99,66.33.

Runing a Table with a numeric field no currency format notthing strange.

Running Avante Forms latest version.

Let me know if anyone has notice this

0 0

Answer

APPROVED ANSWER

replied on December 19, 2018

Hi everyone,

The related bug(Reference ID #102439) is fixed in Forms 10.3.1 Update 2. The update is now available at https://support.laserfiche.com/kb/1014017/list-of-changes-for-laserfiche-forms-10-3-1-update-2.

Please try applying the update if you encounter same issue.

Thanks,

0 0

Replies

replied on July 27, 2018

This looks to be a bug on the Forms side. Reference ID #102439.

Could you look at the instance details on the Parameters tab and confirm that the value in the $deltavars output parameter correctly contains the negative sign?

1 0

View 1 previous reply

replied on July 27, 2018 • Show version history

Miruna,

It would be nice if there was a place listing currently known bugs, and what their status is. Telling us the reference ID isn't much use without a link to a page that shows us the technical details of the bug, the current status of the fix, and a link to download the patch when it becomes available.

It would also be a huge help when working with customers if I can search a list of known open issues, so I don't have to call your IT support team when I run into something odd that may or may not be a bug.

0 0

replied on July 27, 2018

That's a fair point. We don't currently keep the known issues lists updated past the initial release. I'll see what we can do to change that.

1 0

replied on July 28, 2018

Thanks, Everyone, I am back at it and no luck so far. Any workaround ideas?

Let me know.

Thanks

0 0

replied on August 2, 2018

We have fixed this issue for the latest version of Forms 10.3.1. Please open a support case to receive a patch for the bug. (Reference ID #102439)

0 0

replied on July 27, 2018

I have not run into this but there is something you could try. In workflow every token is declared as a string, the problem might be with converting the string to a number in forms (maybe it drops all non-numeric characters).

In workflow you can change the declaration of the token to be an actual number, int, etc. It is called Token Tags, just change the tag.

0 0

replied on July 28, 2018

HI Chad

I have tried all my options in the token Tags, none of them seems to allow me to pass a negative value into forms, Only Invoke business process.

Thanks for the reply

Regards

0 0

replied on July 31, 2018 • Show version history

A workaround I have found for this is to pass the negative number into a hidden text (Single Line) field. Then, your Number field could have the calculation:

=IF(EQ(TextStoresNumber,""),"",VALUE(TextStoresNumber))

This will work if and only if the number field is shown to the user for the first time after your hidden single line field has been set - otherwise, it defaults to 0.000 and the calculation will not overwrite it. You can also handle this with JavaScript if you wish, but this is the quickest out-of-the box solution I could come up with.

0 0

replied on August 2, 2018

Hi, the bug that not allow to pass a negative value into forms when using Set Bussiness processs variables has been fixed now, can you open a support case so that i can provide a hotfix for you ?

0 0

View 1 previous reply

replied on August 6, 2018

Hi Wenjuan

I have received the KB1013963 to fix the bug, but I am still having this problem after KB installed? I have an Avante System with Forms Professional now on Professional Version 10.3.1.635

Did anyone test this, I cannot pass a static negative in a token value to Forms. takes away the Negative (-).

I have SQL & lookups as a work around but my poor resources are crumbling

Thanks for help guys.

Regards C2

0 0

replied on August 7, 2018

Did you first install 10.3.1 Update 1 from KB1013963, then replace the problem file with the one from support? We need you on the latest 10.3.1 update to apply the patched file.

Please follow up on the support case with the issues you are now facing. The support team will ensure everything was installed correctly and can help investigate any new potential issues.

0 0

replied on August 7, 2018

KB1013963 is what was given to me as the fix? I was on the latest version of Forms before the install.

0 0

replied on August 8, 2018

Check back in with the support case. I believe you should have been given the KB to update to 10.3.1 update 1 AND a file that has to be replaced to fix this issue. The file only works for 10.3.1 update 1 so you had to upgrade to that first, before replacing the file.

0 0

You are not allowed to follow up in this post.

Question

Question

set business process variables taking negative away from numeric value

Answer

Replies

Sign in to reply to this post.