johnnyrocknyc

Hi there. This is an old post, but maybe someone's listening? I've set up a script trigger to switch to layout based on user - as discussed here, and it works fine - but the default layout flashes on the screen for a moment before switching to the scripted layout. Does anyone have a tip for hiding that behavior? Will I need to make the default layout a blank screen? Side note: I've deselected the file option for default layout and this is still happening. Thanks!

Thank you for your reply. The example in this post isn't pulling directly from my database. I will post an example as soon as I can. Cheers, John

Hello, I've done my best to browse/search for this solution, so forgive me if it's been covered. I'm trying to export data that exists in multiple tables to a spreadsheet/csv. When I do this, and there are multiple values, the export jumbles (seemingly randomly) the data that comes out if that data is in a different table. For example. In my database, say I have a Project table, a Company table and a Contact table. The projects, companies and contacts are linked via a key, but the data I'm exporting exists in their separate tables. When I export Project, I will often get Contact A showing with Company B and vice versa. It seems that the export is ignoring the relationships between them. So if I export from the Projects table a list of "Projects I'm working on", I might get results like: Export line 1 - Project: iPhone : Microsoft :: Steve Jobs Export line 2 - Project: Zune :: Apple :: Bill Gates When I go to the Project Detail page, all of the data is correct. (iPhone:: Apple:: Jobs, etc.) The export is grabbing all the right data, it's just outputting it incorrectly. (The Contact data for first name and last name (which are seperate fields, but the same table) is always matched correctly, which makes me believe that it's the seperate tables of the other data that is causing the mix up. ) I'd be greatful for any recommendations on how to get the data to export properly. Thanks, John

Comment, Thanks very much for the join demo. I've been looking at my DB from every angle trying to figure out why the logic wasn't working. I couldn't add data to my portal fields. It turns out that the field settings were fine, but the Portal settings were overriding them. Thanks to your demo, I'm back in business. Many Thanks, John

I have an update for anyone who has experienced this problem. The problem is a includes confusing specs on Filemaker's site and a width limitation to the Table Layout view. The confusing part is that their spec (see Answer ID: 5400) for FMPro 8 states: Number of fields/columns per record: 256 million total fields over life time of file. At the same time, they state: Number of columns across the page: Up to 99 columns. The default field width in Filemaker in Table View is 120 pixels. When you create a table view with 99 fields, only 66 will display. Thus, the table view cuts off at 7,920 pixels wide. It woulds seem that the limit is somewhere between 7,920 and 8,040. I was able to display 100 columns despite Filemaker's claim of a limit of 99. I set 99 of them to 80 pixels long, but 1 of them stopped resizing at 79 pixels. Thus the pixel width limitation in Filemaker is 7,999 pixels for Table View. For those who have encountered this problem, I hope this helps. I have notified Filemaker of this limitation and hope that they might address it in future revisions. Cheers, John Connell johnnyrock@gmail.com

Hello all. I'm trying to create a table view of a flat Filemaker DB that includes all 89 fields in my DB. I go through the "Create New Layout" steps and select "Move all fields" but when I view the table, it cuts off the last few fields (stops at about 80). According to Filemaker, the column limit for a table view is 4000+. There is no logical reason for the fields to be left out. They're all simple text fields. There are a few that have repeating values, but they show up fine. I'm using FMPro 8 and tried fixing this in 7 on both Mac and PC, but nothing seems to work. The view keeps dropping fields. Any help would be greatly appreciated! Thanks so much, John

I have been so busy using this new technique - I forgot to respond with my most sincere thanks. It works like a charm. It has saved so much time. Thanks again. -John

Thanks so much. I'm going to try the relationship approach. I'll let you know how it goes. I really appreciate all of your posts. -John

Thanks so much for the posts. I think I should clarify, though. Consider a DB with 100,000 dog names in it. The names are stored in a field called NAME. I have a list of 500 names that I want to find in the database to create a subset. So, I can go to find mode, click in the NAME field and type "Fido", then perform a new find request and type "Rex", etc. I do this 500 times with the 500 names, and I'll get my subset which I can then flag. Is there a way that I can submit all of my requests at once? I'm not sure if there's a separator that I can use like a comma or 'AND', but I'd like to be able to find Fido and Rex and Tiger and Astro and Dino, etc... -Thanks again, and pardon me if this is a stupid question.

Hello All. Does anyone know an easy way to find a large number of records? I would like to copy and paste about 500 values from an Excel/Text file and search one field in my DB. To do this individually would take hours. I'm not so adept in Scriptmaker, and imagine this would be one way of doing it. If anyone has suggestions, it would be greatly appreciated. For clarification I'd like to search one field for something like A11, and C22, and F51, and...etc. Thanks, John

Hello. I am working with Filemaker 6 and I'm constantly exporting the same fields from different found sets. Is there way to save my export description so that I'm not always scrolling through 100 fields to select the 8 that I want to export? I'd ideally like to create a script that exports the desired fields from a particular found set with the click of a button. thanks for any help!