CalcBuilder Forum

Hello,

1. Whenever page loads, it shows this prompt: "Some values are incorrect"
https://www.znaor.com/calctest
That's happens if I set "Your Name" or Checkbox I agree field to be required.
I need to have both them required and Id to keep "Throws calculate on init page" option activated
Is it possible to exclude these from initial page init on load?
Any suggestions how to fix this issue?

If you have any required field and launch the calculator, the validation will show. If you need to have your inline fields present when form loads, you can disable the option "Throws calculate on init page" and launch manually the first calculation. Choose one of your fields, for ex. myfield1 and enter this code at the first javascript tab (on loaded page):

CB('').change();

This should calculate inline fields bypassing validation, please let us know if you need further help.

2. Where can I edit email and PDF templates?
- I used bootstrap in Form layout but this doesnt work in email. I need to have three columns
Should I use tables instead of bootstrap template?

Yes, PDF and email should use an alternate layout instead of bootstrap. You can use tables or any other element, just go to 'Print preferences' tab and PDF or Email section. Disable the settings which include either input/output sections and place your new layout at any of the HTML sections.

3. How to prevent sending empty fields in email? (Or to be shown in PDF)
Currently if field is empty, user gets ##variablename## in email.
Maybe to set up some conditional rules? Examples?

This is not supposed to be happening. Empty fields should show as empty text. Please double check your variable namesthat should match exactly with your inputs or calculated outputs.

4. What would be the best way to replace default "Send by email to" field at bottom with Custom email field
And custom send email button which is shown next to reset button?
I would like to have all user fields in one area, like: Name, Email, Phone, etc.
And all needed buttons on the bottom

You can disable the send email option and create a new input field that you can place at your input section, then go to email settings tab and choose this field at the combobox next to 'send to' option.

5. Is it possible to have Print button at bottom, like PDF and Excel buttons?

There is no such option available, sorry, at the print is made directly on pdf or excel format.


Please try the suggestions above and let us know if you need further help.

Thank you very much for the feedback. We've realized there are a lot of spreadsheets that need to be converted to working webpages. In fact we also have a much more advanced tool able to do all the hard work (even the layouts). It's called XLSJuice (https://xlsjuice.com/). Just in case you want to take a look if at any time you have any other complex excel to transform.

Thanks. Regards,

Hello,

Empty fields should show as empty text: we have tried here with an example and we couldn't reproduce. Non-filled variables are shown empty as expected (at the exit layout, pdf and also email outputs). So we'd like to take a look at your specific configuration in order to check why is this happening on your site. Please place a ticket at the helpdesk, including an access to the configuration or if you prefer, export your calculator and attach it zipped to the ticket, we'll import here and debug in order to find out.

We have noticed you have a strange configuration at this time, with no calculation button, a reset button, and the default email input showing but with an email input as well, the right configuration would be:

- Disable the 'send email to' at preferences
- You can set again any field as required.
- Change your input field 'email' at the input form for the right one ( seems you have included again the previous field ##name##), so you're not showing it.
- Configure email tab to send email to this field.
- Include any message you want to show at the 'exit layout'.
- Don't hide/enable again the 'calculate' button. And set no automatic calculation launch.
- In order to launch the inline results, you don't need to enter each inline field, you only need to launch it once using any input field instead. This would be the only code needed for your case:

CB("").change();

It only mimics the first action of a user on one input field, that will be launching all inline calculations across the form.

When email is sent all editable fields resets: same as above, it doesn't happen here (as this function is not included). The reset must be done intentionally by the user, clicking the button 'reset'. Tried at your page and we couldn't see form being reset either, both inputs and inline results are ketp once the email is sent.

- For having a reset function, and also launch the inline calculations, you can show the reset button you already have, and try place the same inline calculation call:


CB("").change();

at the 'before reset' javascript tab.

We look forward the calculator configuration so we can debug the empty variables issue.

Thanks, regards

Edited by MSTeam - 14.01.2019 09:49