The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.33 (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.33 (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.33 (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.33 (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.33 (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.33 (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.33 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.33 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.33 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.33 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
> 256 fields and excel 2003 - 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: > 256 fields and excel 2003 (/showthread.php?tid=240)



> 256 fields and excel 2003 - Alexis - Aug 13th, 2009

Hello

My forms are getting quite complex, and one of them has 300+ fields.
i am using excel 2003 and it doesn't accept files with more than 256 colums, a workaround i found is opening the files in ooo or excel 2007 to break them. but it's not very convenient

can we imagine a way to select which fields are exported and make 2 export formats for that form one that exports the first 255 fields and another something like the 3 first fields (to id the entry) and the rest of the fields .?

thanks

alex


RE: > 256 fields and excel 2003 - Ben - Aug 26th, 2009

Hi Alex,

Yeah, the 256 column limit is a real pain. But sure - this can be done with Views.

Just create two Views on your form: one with the first 250 columns, and one with the remainder. You could include the submission ID in both so you could match the data in the rows up.

You can read more about Views here:
http://docs.formtools.org/userdoc/?page=views

Good luck! Smile

- Ben