Calculated Fields
Wednesday, March 31, 2021 at 07:55amI have been asked to explore automation of a form that is currently hosted in Excel. It includes some simple calculations (sums mainly). Does Sign support calculated fields?
I have been asked to explore automation of a form that is currently hosted in Excel. It includes some simple calculations (sums mainly). Does Sign support calculated fields?
Reply to: Calculated Fields
Wednesday, March 31, 2021 at 09:06amHi JMyers,
Unfortunately, current OneSpan Sign doesn't support native excel files, the available types are:
That's to say, you may have to convert the excel to a support type (e.g. .pdf) upfront uploading to OneSpan Sign, and the save as PDF conversion does have the ability to keep the calculated fields.
Duo
Reply to: Hi JMyers, Unfortunately…
Wednesday, June 9, 2021 at 09:13amCan you expand on this? We are new to OneSpan and I'm curious how to put a calculation into a field in a pdf.
Reply to: Can you expand on this? We…
Wednesday, June 9, 2021 at 09:33amHi kkiblinger,
Thanks for your post! I actually didn't mean to put a calculation into a pdf form, but to flatten the excel cells while saving all data sheets as a PDF. Take the attached sample excel for example, (1)define print area (2)File > Save as > Browse (3)save as PDF from the dropdown (4)Options > Publish the entire workbook
Duo
Reply to: Hi JMyers, Unfortunately…
Monday, June 21, 2021 at 02:07pmTo clarify, I am not looking to upload an Excel document to OneSpan, I am looking to include Excel-like functionality in OneSpan. For example, on the form I have the following values:
Collateral 1 Value
Collateral 2 Value
Collateral 3 Value
Total Collateral value.
I want the recipient to enter the 3 individual collateral value fields and have OneSpan do the calculation Total Collateral Value = Collateral Value 1 + Collateral Value 2 + Collateral Value 3
Reply to: To clarify, I am not looking…
Monday, June 21, 2021 at 02:36pmHi JMyers,
I see what you meant. Unfortunately "Formula/Calculated/Dependent field" is not currently supported. There are already existing Enhancement Requests asking for this feature, hence if you preferred, I can vote on behalf of your organization in our roadmap system.
Duo
Reply to: Calculated Fields
Friday, December 22, 2023 at 08:20amHi, has there been any progress on getting calculated fields into the system? This is a much-needed feature.
Reply to: Calculated Fields
Monday, September 23, 2024 at 10:29amHas there been any progress or updates on this functionality? This is something that comes up often and is available from other esign providers.
Reply to: Calculated Fields
Monday, September 23, 2024 at 10:56amHas there been any progress or decisions made in regards to offering this type of functionality. This comes up very often and is offered by some of your biggest competitors.