Form Builder

When creating a template using Form Builder, an Internet Explorer Window is opened within MS Office and the login value is retrieved.

This means the login information has expired, so please try logging in again.

To execute (preview) the content of a sheet, OZ in Excel pre-inspects the used range during the conversion process. If a cell or row is arbitrarily adjusted, then it may take a long time to convert the entire adjusted area to be recognized as the used area. In this case, you can reduce the conversion time by following the below instructions.

1. Selects the entire first empty row after the created document area.
2. Drag the vertical bar on the right with the mouse and drag it until the bottom of the screen. Then, press the Shift key and then select the last row.
3. Right-click on the row and select Delete in the pop-up menu displayed to delete the entire  row.
4. Delete columns in the same way.
5. Save the document and execute again.

Follow the steps below to enable to disabled OZ in Office ribbon menu.

1. Go to File > Options
2. Click Add-ins and select Disabled items in the drop-down menu next to the Manage item. Then, click the Go… button.
3. Click OZ in Office in the list of Disabled Items and then click the Enable button.
4. Close all MS Office files and open an MS Office program to see if the menu is now shown.

If the above does not work, then manually change the registry as follows.

1. Close all Excel, PowerPoint, and Word programs and open Task Manager by pressing Ctrl+Alt+Delete. Then, check whether any of the Excel.exe, POWERPNT.exe, and WINWORD.exe processes are running.
2. Press the Windows key + r to open Run, and then enter regedit to open the registry editor.
3. Enter the below path in the Registry Editor window and then delete folders such as FORCS.OZinExcel (this step is for deleting OZ in Office registered in MS office).
   Excel: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\FORCS.OZinExcel
   Word: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\FORCS.OZinWord
   PowerPoint: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\FORCS.OZinPPT
4. Enter the below path in the Registry Editor window and then double-click the Loadbehavior file of each folder and change the value to ‘3’ (always running OZ in Office registered in MS Office).
   Excel: HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins\FORCS.OZinExcel
   Word: HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins\FORCS.OZinWord
   PowerPoint: HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins\FORCS.OZinPPT
5. Open Excel, PowerPoint, or Word and check to see whether OZ in Office is shown. If not shown, then close all Registry Editors and enter %systemroot%\syswow64\regedit instead of regedit in Step 2. Then, retry steps 3 and 4 (change 64bit registry).

Each component is a unique key value that is recognized in eformsign. Therefore, if there are duplicate IDs, a calculation error will occur when referring to the value.

Hence, cells containing different values must have different IDs.

Moreover, a cell from which the final value of a formula is derived does not require an input component.

if a text component is added, it is recognized as a space entered by the user and no calculation value is entered. Therefore, you need to delete all the components in the cell and specify only the ID.

Yes. There are two ways you can create a template from a Microsoft Office file.

Click Manage templates in the eformsign sidebar menu and upload the Microsoft Office file you want to create a template out of.

Another way is to install Form Builder provided by eformsign and add components to a Microsoft Office file and upload it to eformsign.

Form Builder can be installed in Microsoft Office 2010 or later in Windows PC, and you can download it by clicking Download eformsign form builder.

eformsign Form Builder is only available on Windows PC. You need Windows 7 or higher operating system and MS Office 2010 or higher to use Form Builder without problems. However, once you have created and uploaded an e-form, you can use this form regardless of your device or operating system, including PC, tablet, and smartphone.

eformsign is a service that allows anyone to easily convert paper documents into electronic documents without coding skills. Anyone who can use Excel, Word, and PowerPoint can create e-documents with eformsign.

Yes. If you use the attachment component in the form builder, you can attach a file when creating a document.

You can attach image files and PDF files, and the attached files are appended at the last page of the document.

Form Builder, which is provided as an MS Office add-in, is a tool for creating electronic forms to be used in eformsign. It is used to transform existing forms such as application forms, contracts, and agreements into electronic forms that can be filled in and signed in PCs, tablets, and smartphones. Form Builder can be installed in MS Office 2010 and later in Windows. You can download it here.

OZ in Excel pre-checks “Used Range” during conversion to execute the contents of a spreadsheet. If you arbitrarily resize rows or columns, it may take quite some time to recognize the entire resized area as a used area for conversion. In such a case, you can decrease the conversion time using the following method.

1. Select all the empty cells of the first row in the created document.
2. Drag the vertical scroll bar on the right with a mouse until it is at the bottom and then select the last row while pressing on the shift key (select range).
3. Right-click on the row and select the delete menu to delete the entire selected rows.
4. Delete the columns using the same method.
5. Save the document and execute it again.

When the form builder is used in Excel, the preview screen that appears when clicking “Execute” in the form builder is generated based on the print area set in the “Print Area” menu under “PAGE LAYOUT”.

If the page count is different than what you expected when executing the builder, then please change the print area.

You can see the shapes you added to your Word or PowerPoint document in eformsign. However, this is not the case in Excel as it does not support shape conversion.

If you need to use shapes, please use Word or PowerPoint.

The “check” component is used for selecting one or more items among multiple items to choose from while the “radio” component is used for only one item among multiple items to choose from.

When using the “radio” component, you must have the same component ID for all items to be able to select just one item.

> Read more

A document created on a Microsoft Office program may appear differently when executed on the form builder. This is because of the differences in the composition and method in which documents and electronic documents are displayed on the screen.

For example, there may be instances where after executing the builder, the font looks the same but the text width looks different, resulting in different line breaks.

Therefore, it is recommended to frequently check the execution screen when creating a document using the form builder.

If you upload a document on eformsign in the Manage templates page, the uploaded document may look differently due to reasons such as font issue.

Therefore, we recommend you to upload PDF files for the best experience.

The following is the list of supported Excel functions.

• Arithmetic
• Operator precedence
• Sign
• Cell reference

The following is the list of supported Excel formulas.

• Logical functions: IF, AND, OR, IFS
• Math/trigonometric functions: ABS, MOD, PI, RADIANS, ROUND, ROUNDDOWN, ROUNDUP, SUM, TRUNC, SIN, COS, TAN
• Statistical functions: AVERAGE, COUNT, COUNTA, MAX, MIN
• String manipulation functions: LEFT, MID, RIGHT, LEN, LOWER, UPPER, SEARCH
• Search/Matrix Functions:: MATCH, HLOOKUP, VLOOKUP

It is a unique identifier used to identify each component.

You can use the component ID to specify the characteristics of each component such as edit restrictions and required fields.

Additionally, after creating a document, if you extract the input data and download it as a CSV file, the data list is displayed as component ID.

The form builder is a PC program and therefore cannot be used on mobile. To use the form builder on Windows PC, make sure that you have Microsoft Office version 2010 or later.

The form builder can only be used in Microsoft Office 2010 and later versions in the Windows environment. Older versions are not supported.