rt916

I want to update this thread for other users that experience a similar issue. For the problem users I ended up disabling the start-up scripts, then the users were able to login to the database but not get the main landing page layout. I spend several days debugging and re-writing the landing page scripts and I was able to solve the problem.

This is a strange issue that happened only after we upgraded from FMP11 to FMP16.0.3. We also migrated the FMS to a new windows 2012 virtual server, with a updated version of SQL 2012 (previously 2008). Most users (125+) can connect with no issues. But we have a handful of users (5-10) that cannot open the database at all. They either run the launcher and never get a login screen, or after they login the initial scripts start to search for the users data and it never finishes. The FMP software eventually hangs up and they have to end task in windows. Of the users with problems, 1 can login to database with administrative privileges but not without. Several other users get stuck at the searching script and never make it past that. Things we have tried so far: - Reloading the users operating system, no change - Adding the user to administrative group in Active Directory, no change - Removing FMP16 and loading FMP15, then FMP14, no change - Rebooting the server, no change - Removing the startup scripts completely from the problem users, no change I have found some articles about creating a new active directory organizational unit (OU) and adding the users to that group. Problem is we don't have direct server access so that process will take us several days to get the IT folks to test it with our network. Has anyone else ran into this issue upgrading to FMP16? Anyone have any ideas? Any help is much appreciated! Thank you

I wanted to update this thread in case someone finds it and runs into a similar problem. It ended up being a problem with my relationship graph, where I was matching the wrong field to the related table, thus the search was not performing a query on the correct field. If you run into this, check your relationship diagram and verify you have the correct related field tied together. Hope that helps!

I am having the same issue on FMP 11, did you ever figure out what was causing this?

I assist with a FMP 11 database that manages projects and related data, about 10,000 projects currently. I setup a new tool that tracks a ADL requirement with a simple YES/NO drop down value list. Users choose if the project requires ADL tracking by selecting YES/NO, and we have a layout that lists all 10,000 projects with the ADL requirement that shows YES, NO or empty value. This layout also shows lots of other project records that are searchable without error. I am trying to perform a Find on this layout to display all values with YES selected, or NO selected. The appropriate relationship is setup on the graph so my list shows all 10,000 projects, and other records that are searchable, but my YES/NO value list gives me a "No records match the find criteria." Before I write a script with a button I am testing the find function steps first, and I keep getting the same error. I open the layout, click show all (10,000) records. I click Find then click the ADL Requirement and click either YES or NO. I click Perform Find and get the No records match this criteria error. This seems to be a very simple operation, to search records in the database, and for the life of me I cannot find why it isn't working!! Any help is much appreciated, thanks in advance!

you are correct, I was overthinking it. the TO with the related field works just fine. Less work and cleaner workflow! thanks "comment"!

I got it working!! I used your recommendation for entering the district numbers and addresses then created the address block as a portal, sorted by district_number, and it worked! Your help and input is much appreciated, thank you guys! I'm so happy this forum is here!

I have one in the ADL_Tool table, which grabs the district number from the CentralENV (varchar) table and saves it as a numerical value. I added a 2nd field with the address text and connected them in the relationship graph via the district number. Now I need to populate the district_address_label with the corresponding address text from the related district_number, of which there are 13. I apologize for the confusion! I have been learning this db that 10-15 people setup over the course of 12+ years that nobody cared to ever document! Now everyone is gone and I'm trying to implement new workflows and make the system better, and it's a rats nest to say the least.

Well your right, I keep running into problems hardcoding data in the schema and it's probably considered best practice to separate the data from the schema. So I setup a related TO& Layout with the address field as text (varchar) and district numbers (numerical) and added the data in there. Now I have a district number field (1-12) and address block with the text I want inserted in my template, sounds good so far. So to make the relationship work I need to add another (numerical) field to the CentralENV table for the district number and connect them in the graph?

I manage this database for a gov agency and there is a very real fear that if the public knew that the db existed they would overwhelm the agency with public information requests. Plus I would have to get authorization from my superiors to upload/share it, and I know the answer to that would be a resounding no! I'm not trying to be difficult, it's just the reality in gov info sharing :/

I don't think so, the file is massive and has literally over 10,000 active projects with tons of PII data. I'd probably get in a lot of trouble if someone found out I shared it!

CentralENV and ADL_Tool are related TO's, and all the other fields that I reference populate fine. Maybe I need to populate the district_address_block in the ADL_Tool TO first in the script step, then open the layout ADL_Print_Template later in the script?

I like the idea of setting this up as a Set Field step in a script, but how would the calculation look for that? I specified the target field (adl_tool::district_address_label) and set the target field with the "text address I want to insert" in the calculation, but the ayout page with the _district_address_label is still coming out blank. I attached the screenshot with only the 1st district changed. Please see attached and let me know what I'm doing wrong.

Ok got it, thank you for the help! I will make the changes and test doing it that way. Unfortunately I only work on this job Tues-Thurs so if I am not finished today I may ask for more advice next Tues. But the help is much appreciated, have a great weekend!

I apologize for the typo! I looked in SQL and the district_number field is a variable character field. All of the other script functions work and it finishes my new layout with the other fields populated, but the district_address_label is blank. To run this as a lookup, I would setup a new table with 1-12 numeric values? and another address field/column with the actual text to insert?

Hey folks, I am working on a layout that auto-populates a bunch of data from related fields. One of the fields is called district_number which has the numerical 1-12 value, depending on the district. I am trying to get a script to read the district number, then based on the value have it populate data in another field. I started by setting the district_number as a variable, $DistrictNumber Then I have the If statement: If[$DistrictAddress = "01"] Insert Text [Select;xxx::district_address_label; "District 1 P.O. Box 3700 blah blah blah"] Else If [$DistrictAddress = "02"] Insert Text [Select;xxx::district_address_label; "District 2 P.O. Box 3700 blah blah blah"] Else If [$DistrictAddress = "03"] Insert Text [Select;xxx::district_address_label; "District 3 P.O. Box 3700 blah blah blah"] ... etc... End If But ti doesn't work. Any help on what I am doing wrong is much appreciated!! Thank in advance, RT here is an image of how it looks

FYI the suggestion Fitch had did the trick! Conditional formatting was a nice work around and the simplest to setup. Thank you guys for the help, cheers!

That's my fault, not yours It's difficult to explain some of these workflows over threads. But your advice is helping me figure it out! I won't be switching layouts on a record-by-records basis. Only 1-2 records are affected by this issue and I think your suggestion to make them numbers will work. But, to make this even more confusing, the back end is on SQL server. So I would create/update the record in SQL as a number field right? and lose the text field. then change the field in FMP to a value list, and perform the calculation based off that. yeah?

we are browsing records in Form view, and want the layout to change according to the loaded record's status. the collected data gets formatted and inserted into a layout that's setup for printing and pdf export. I thought about doing a portal but the end-result document is size 12 font, and I don't think I can fit the portal into a box that small!? I'll try the 1/empty suggestion, that seems more like a logical expression that won't break as easily. thank you!!

Hey Fitch do you have an example I can look at possibly? Not sure if I would have to change the YES/NO field to a value list, and return a 1 value with a checked box to base that calculation off. Seems like all these FMP 11 work-arounds get very... creative! Maybe I should push for the new features to be available on FMP 14 and try building them in there?

Hello, I am working on an older FMP 11 database and trying to create some new features while we wait to migrate to FMP 14. I setup a layout with some basic data collection, where some of the fields are simple YES/NO drop down selections. The data gets populated into another layout for printing and exporting, and I have a few fields where the visibility needs to be based on the result of the YES/NO response. That seems to be available with the inspector in FMP 14, but all of the users are on FMP 11 for a unknown amount of time. I assume this needs to be created using a script trigger on the layout, to run at OnRecordLoad. Something like If table::record = YES, display this text result. But I am new to FMP and learning the functions. Any help would be very much appreciated!! Thank you in advance!