Jump to content


  • Posts

  • Joined

  • Last visited

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

2,392 profile views

shredded's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I am looking to eliminate the scroll bar being shown and add a visual identifier that more data is available. The scroll function still works and will show up once the mouse scrolls, of course. Example. Portal number of rows = 25 Number of records = 50 Visual cue to scroll down, or up, or both. Any point in the right direction would be great.
  2. While on the layout (Master), I'd like to have a field like Master::EmptyDataIDs, which is an sql that shows all __DataIDs related to Master, but with empty Notes field.
  3. Trying to pull data (list of DataIDs) where they have null Notes, see image. I want to see the ids from the related layout table Master. Any help in the right direction will be great. thanks.
  4. It didn't work for me, I ended up doing this: Let ( [ Num = TABLE::FIELD / .1 ; Integ = Int ( Num ) ; Frac = Num - Integ ] ; ( Integ + Ceiling ( Frac ) ) * .1 ) Got me close enough
  5. I'd like to bump up some decimal places, not sure how to do this? Basically want .00, .10, .20, .30, .40, .50, .60 etc and .05, .15, .25, .35, .45 etc. 0.01 to 0.04 = 0.5 0.05 to 0.09 = 0.10 19.50 to 19.50 (no change) 19.25 to 19.30 19.26 to 19.30 19.01 to 19.05 19.02 to 19.05
  6. I am still learning SQL and I was hoping for some help to add another relationship to my equation. I would like the SQL to show me all the ItemsIDs that are assigned to selected years (via key) that are originated from Details table layout. This is working good, but it's showing my ALL ItemsID meeting that year criteria, but I would like to only see __ItemsID based off the layout I am on, which is Details. I think I need to add FROM "\Details\" and WHERE _fkDetailsID = ? ; Details::__DetailsID, but I am struggling to add in another table!! Any help would be greatly appreciated to get where I am going or simplify!! Details::__DetailsID <-> Items::_fkDetailsID Items::__ItemsID <-> AssignedYears::_fkItemID AssignedYears::_fkYearID <-> Years::__YearsID Let ( [ Key = 8 // YearsID from Dropdown ] ; ExecuteSQL( " SELECT \"_fkItemsID\" FROM \”AssignedYears\” INNER JOIN \”Years\" ON \”AssignedYears\ . \"_fkYearsID\" = \"Years\" . \”__YearsID\" WHERE \”AssignedYears\ . \"_fkYearsID\" = ? ORDER BY \"_fkYearsID\" ASC " ; " " ; "" ; Key ) )
  7. This is what I did that seems to work fine. The only thing is that Im listing a lot of values, even though the relationship filters the correct ProductIDs. Would there be a performance increase if the calculation also determined the relationship, rather than through a table connection? If so, how can I also include Products::_fkParentID to Parent::__ParentID Let( [ KeyA = SettingsGlobal::gSelect_Season; KeyB = GetValue( Products::gSeasonSelectKey; 3 ); KeyC = GetValue( Products::gSeasonSelectKey; 4 ) ]; If( not IsEmpty( SettingsGlobal::gSelect_ShowCurrentChoice ); Case( not PatternCount( SettingsGlobal::gSelect_Season; "Collection" ); ExecuteSQL( "SELECT \"__ProductID\" FROM Products WHERE cSeasonStart = ? OR cSeasonStart IS NULL"; ""; ""; KeyA ); PatternCount( SettingsGlobal::gSelect_Season; "Collection" ); ExecuteSQL( "SELECT \"__ProductID\" FROM Products WHERE cSeasonStart = ? OR cSeasonStart = ? OR cSeasonStart IS NULL"; ""; ""; KeyC; KeyB ); ); ExecuteSQL( "SELECT \"__ProductID\" FROM Products "; ""; "" ) ) )
  8. I have a relationship calc for a portal that will show either all products, or all products pertaining to another drop down of the season I am viewing. Case ( not IsEmpty ( Settings::gCheckBox ) ; Project::cProductID_ListSeason //occurrence filtered by season selector ; Project::cProductID_ListLocal //all products occurrence ) This all works fine, but I'd like to update the Project::cProductID_ListSeason to also show products that have 0 seasons assigned to them. My entities are: Projects <- Products <-> AssignedSeasons <- Seasons What would be a good approach to gather ProductIDs that contain no SeasonIDs and combine them into the list of products that do have SeasonIDs? I want to add new products with no season while I'm filtered, then apply the season to them, without have to show all...assign, then filter by season again. Hope that makes sense
  9. Thanks for the reply... Any suggestions on something similar? I was really hoping for a portal of parents, that could open related children, similar to file system. Parent1 ----Child 1 Parent2 ----Child 2 ----Child 3 ----Child 4 Parent 3 ----Child 5 ----Child 6
  10. Reviving this old thread! I am struggling to understand how I can implement this in a two table format, whereas the parent table holds the country and childs table holds the states. Any ideas, am I just missing something simple?
  11. Yes this works If I add "/ to the values. Thank you so much! Can you explain how I could add dash space at beginning and enter at end? - ASTM: 123 - ASTM: 456
  12. comment, Can you check this demo file? I think I blew it and forgot to mention there was a join table. THANKS!!!!!! Test.fmp12
  13. I have a similar calc that pulls data from 2 tables, but in this situation its both from the same table. I tried just changing the values, but I am pretty noob on SQL. ExecuteSQL ( " SELECT \"Standard\", M.\"Type\" FROM Standards C JOIN \"Standards\" M ON M.\"__StandardID\" = C.\"__ComplianceID\" WHERE \"_fkParentID\" = ? ORDER BY \"Value\" DESC " ; "% " ; ", " ; __ChassisID )
  14. The portal is for data entry, the output to a text field would be for a detailed description with other information that can be viewed on another layout.
  • Create New...

Important Information

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