The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Export Module question - HTML and Excel view omit 0 or no values - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Modules / Other (https://forums.formtools.org/forumdisplay.php?fid=8)
+--- Forum: Modules (https://forums.formtools.org/forumdisplay.php?fid=16)
+--- Thread: Export Module question - HTML and Excel view omit 0 or no values (/showthread.php?tid=2944)



Export Module question - HTML and Excel view omit 0 or no values - alexnotbrad - Mar 10th, 2014

Hi there,

Firstly, I'd just like to say how awesome I think Form Tools is. It's given me a superb solution for a client whom I've developed an online order form for and it really is an excellent application!

I am having a slight issue though, in that I'd like my clients to be able to log in and view their orders via the HTML / Print view and also via Exporting for Excel. How would one go about setting this so that it's the same as the email template whereby it's possible to omit inputs with '0' or no values?

I'm using Form Tools 2.2.7.

Many thanks in advance!

Alex


RE: Export Module question - HTML and Excel view omit 0 or no values - Joe - Mar 10th, 2014

Hey Alex,

You can just create a client account for your client and then map the submissions to the client ID. What you'll need to do is:

- Setup a view for each client
- Add a default value to the client ID field (View / General tab / Default Values for New Submissions)
- The default ID needs to be set to the client that you are setting up the view for
- Add client filter based on client ID field

Omitting a single field can be done through filters in the View however omitting multiple fields with no values will need to be done through code.

Also we had an issue with 2.2.7 and it had to be rolled back to 2.2.6. Please revert the version you are using.

Cheers,

Joe


RE: Export Module question - HTML and Excel view omit 0 or no values - alexnotbrad - Mar 10th, 2014

Joe, thanks so much, that does make sense, I have to admit, I hadn't explored editing the views for clients. I'll look into it and report back any issues, however it should be fairly straightforward.

I'll sort out rolling back the installation to 2.2.6 asap.

Thanks again,

Alex