Español
English
Forum
Calc Builder Support
Calc Builder supportForums
Public write access is disabled. Please login
Error: Some values are incorrect + Email template 11.01.2019 12:14
Hello
1st thanks for this great component. I needed to build calculator by mimicking simple Excel spreadsheet
and this component was big relief after time spent by fiddling with other form creators for Joomla.
I created one calculator where user needs to fill some numbers and form shows results in inline fields
There are also three text fields and one Checkbox on the bottom where users needs to fill their personal details before sending email.
I've set Name field and Checkbox to be required.
Also:
- Throws calculate on init page > Yes
- Hide Calculate button > Yes
- On three text fields on the bottom > Reload Inline events > No
Questions:
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?
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?
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?
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
5. Is it possible to have Print button at bottom, like PDF and Excel buttons?
Thanks
Regards
1st thanks for this great component. I needed to build calculator by mimicking simple Excel spreadsheet
and this component was big relief after time spent by fiddling with other form creators for Joomla.
I created one calculator where user needs to fill some numbers and form shows results in inline fields
There are also three text fields and one Checkbox on the bottom where users needs to fill their personal details before sending email.
I've set Name field and Checkbox to be required.
Also:
- Throws calculate on init page > Yes
- Hide Calculate button > Yes
- On three text fields on the bottom > Reload Inline events > No
Questions:
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?
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?
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?
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
5. Is it possible to have Print button at bottom, like PDF and Excel buttons?
Thanks
Regards
Re: Error: Some values are incorrect + Email template 11.01.2019 20:27
Hello,
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('[fldname=myfield1]').change();
This should calculate inline fields bypassing validation, please let us know if you need further help.
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.
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.
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.
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,
Moonsoft Team
www.moonsoft.es
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('[fldname=myfield1]').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,
Moonsoft Team
www.moonsoft.es
Re: Error: Some values are incorrect + Email template 12.01.2019 16:32
Hello
> 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.
- But it's happening. I have field variable: b3. I added it in the form layout like this: ##b3##
If I fill it with number I get that number in the email. If I don't fill that field I get this in email: ##b3##
This happens with all fields. Try this demo link and you'll see: https://www.znaor.com/calctest
I used this html table code as form layout
- Also when email is sent all editable fields resets, they gets empty. Except inline calculation fields.
Is it possible to reset those as well? Is it possible to display some message after form is sent or to completely refresh form page?
> CB('[fldname=myfield1]').change();
- This doesnt work. I changed it into CB('[fldname=b11]').change(); in place you told me and when page initialised that field doesn't calculate that inline field.
- Also it would be nice if we could somehow exclude only few fields from first initialisation when page loads.
beause its easier to exclude only few wields compared to adding CB('[fldname=b11]').change(); rules for many more fields.
Thanks for your inputs
Regards
Edited by Krx - 12.01.2019 16:33
> 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.
- But it's happening. I have field variable: b3. I added it in the form layout like this: ##b3##
If I fill it with number I get that number in the email. If I don't fill that field I get this in email: ##b3##
This happens with all fields. Try this demo link and you'll see: https://www.znaor.com/calctest
I used this html table code as form layout
- Also when email is sent all editable fields resets, they gets empty. Except inline calculation fields.
Is it possible to reset those as well? Is it possible to display some message after form is sent or to completely refresh form page?
> CB('[fldname=myfield1]').change();
- This doesnt work. I changed it into CB('[fldname=b11]').change(); in place you told me and when page initialised that field doesn't calculate that inline field.
- Also it would be nice if we could somehow exclude only few fields from first initialisation when page loads.
beause its easier to exclude only few wields compared to adding CB('[fldname=b11]').change(); rules for many more fields.
Thanks for your inputs
Regards
Edited by Krx - 12.01.2019 16:33
Re: Error: Some values are incorrect + Email template 14.01.2019 09:47
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("[fldname=a_b3]").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("[fldname=a_b3]").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
Moonsoft Team
www.moonsoft.es
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("[fldname=a_b3]").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("[fldname=a_b3]").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
Moonsoft Team
www.moonsoft.es