JMyers | Posts: 6

Calculated Fields

0 votes

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?


Duo_Liang | Posts: 3776

Reply to: Calculated Fields

0 votes

Hi JMyers,

 

Unfortunately, current OneSpan Sign doesn't support native excel files, the available types are:

  • Adobe's Portable Document Format (*.pdf)
  • Microsoft Word (*.doc or *.docx)
  • Open Office (*.odt)
  • Text (.txt)
  • Rich Text Format (.rtf)

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


Duo_Liang | Posts: 3776

Reply to:

0 votes

Hi 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


Attachments
JMyers | Posts: 6

Reply to:

1 votes

To 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


Duo_Liang | Posts: 3776

Reply to:

0 votes

Hi 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


david.walker | Posts: 33

Reply to: Calculated Fields

1 votes

Hi, has there been any progress on getting calculated fields into the system? This is a much-needed feature.


mstreadwick | Posts: 2

Reply to: Calculated Fields

0 votes

Has there been any progress or updates on this functionality? This is something that comes up often and is available from other esign providers. 

 


mstreadwick | Posts: 2

Reply to: Calculated Fields

1 votes

Has 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. 


Hello! Looks like you're enjoying the discussion, but haven't signed up for an account.

When you create an account, we remember exactly what you've read, so you always come right back where you left off