Jump to content

shredded

Members
  • Content Count

    54
  • Joined

  • Last visited

Community Reputation

0 Neutral

About shredded

  • Rank
    member

FileMaker Experience

  • Skill Level
    Beginner
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

1,795 profile views
  1. shredded

    sql help

    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.
  2. shredded

    sql help

    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.
  3. shredded

    Rounding up

    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
  4. 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
  5. 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 ) )
  6. shredded

    Filtered Occurrence

    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 "; ""; "" ) ) )
  7. 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
  8. 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
  9. 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?
  10. 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
  11. Heres a screenshot of my relationships.
  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.
  15. Hi, I am trying to pull data from a portal, for example I have Standard and Type fields. I would like to pull that portal information into a text field that would show: STANDARDFIELD & ": " & TYPEFIELD STANDARDFIELD & ": " & TYPEFIELD STANDARDFIELD & ": " & TYPEFIELD ASTM: 12345 ASTM: 34556 ASTM: 85858 or ASTM: 12345, ASTM: 34556, ASTM: 85858 Any help would be greatttt! Thanks
×

Important Information

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