June 30, 200916 yr Well, in Browse mode a User can omit a field if they wish (vs. 10 table view). I thought (silly me) ... how wonderful because I could use the same layout and add or remove fields (via script) for Save As Excel!! Sometimes Users want a field and sometimes they don't. Firstly, are we not given the ability (in Browse mode AS DEVELOPERS in a script) to show or not show fields? That would be cool because I wouldn't have to create several layouts (each with different fields on it) just for Save As Excel. Secondly, dang if FileMaker doesn't mess up the data when a field has been 'removed'. Create two fields (Field1 a number and Field2 text) and place them both on table [color:green]layout. Make sure both fields contain data. Select 'Modify' and omit Field1 from the table view. Now Save As Excel ... Both LABELS appear in the Excel document. The data in number doesn't appear. But worse ... the data in the Field2 moves to the column of Field1 (under the number label). Good grief. There goes wonderful possibilities of functionality out the window and here comes another gotcha which will make it DANGEROUS to use. I just want everyone to be aware of it. Please FileMaker, THINK THROUGH things you do for us. Anyone playing with this 'functionality' could have figured out in 10 minutes that it was (greatly lacking) in ability and that it breaks. Edited June 30, 200916 yr by Guest Changed subject to include word BUG
June 30, 200916 yr Author I just had a vision of a financial spreadsheet (all numbers) and a User omitting one field and ... all numbers shifting one left in Excel. That sends shivers through me - no using table view with vs. 10 ever (or omit the Status Toolbar). Great options.
July 14, 200916 yr Author in Browse mode a User can omit a field if they wish (vs. 10 table view). Yep!
July 14, 200916 yr Thanks for pointing out this bug.... and what a bug... I am terrified my users will do this. Some are getting braver.... I wonder what would happen if I removed all of the labels from browse view? Unfortunately I have many users that insist on using table view... can't get them away from it.
Create an account or sign in to comment