Method Community

Hi Michael, Sounds good to me. Character function does not work in my case, since I do not know how many other symbol it might occured. Pound is not the only possbility. Ian

Hi Victor, I just re-read the error message that I got in the email. It appears the error was that the required Name field was left blank, which would make sense because without the checkbox checked, the formula wasn't entering a value for it. I was mistakenly thinking it was because the checkbox wasn't checked.  So, yes I can keep ...

 Ian, I would recommend holding off on customizing at the moment until I get back to you -Michael

Hi Matt, There are few things there I would like to point out: Great with coming up with formula "if(Contains('Service1_Step3','True')='true','Estimate for: service1','')". If you want, you can even write something like "if(Service1_Step3=='True','Estimate for: ...

Hi, If you get an error "The URL from which web form was submitted is not within a selected refferer list." it usually means that someone downloaded your web form and tries to submit faulty values to your web form. Since our assumption is that values are faulty, since they came from an untrusted source, we don't submit them to ...

Ian, I will have to look into this. Customizing is an option and would mean getting the amount into an action result and using the Character Function action to replace the pound symbol with $ and placing that value onto a field on the screen. -Michael

Sorry for the wait. I've investigated the issue. The problem was that once you've added the proper email settings to the account, your request would have been fulfilled if you would have been creating a new Web Form, but with existing Web Form, it remembered old value and refused to change. We had applied a fix, and now you should be ...

Matt, There are 2 main options for this, using scripts or using Formatting Rules. Scripts can be accesed by selecting a field in Report Designer and going to Scripts in the Property Grid (Located at bottom right of the designer by default). Using scripts can get difficult and is a bit advanced but that's where Formatting Rules comes into ...

Hi Michael, Thanks for reply, I got it. Basically it will depends on the computer regional setting, but the issue now is we have customer in some other country, so they will see different symbols, is there anyway to just disable the symbols and just show the numbers or do I need to create exactly same field with customization? Ian

Thanks Paul, that did the trick. Onother question if you don't mind. When the estimate report is generated with customer data, the report inserts the number "1" in the qty column and "$0.00" in the amount column for rows without item or description data. Is there a way to disable this, so that empty rows are blank?