Jump to content

rt916

Members
  • Content count

    19
  • Joined

  • Last visited

Community Reputation

0 Neutral

About rt916

  • Rank
    member

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    11 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 7 & 10
  1. 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!
  2. I am having the same issue on FMP 11, did you ever figure out what was causing this?
  3. 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!
  4. you are correct, I was overthinking it. the TO with the related field works just fine. Less work and cleaner workflow! thanks "comment"!
  5. 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!
  6. 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.
  7. 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?
  8. 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 :/
  9. 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!
  10. 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?
  11. 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.
  12. 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!
  13. 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?
  14. 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
  15. 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!
×

Important Information

By using this site, you agree to our Terms of Use.