Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About WSaxton

  • Rank

Recent Profile Visitors

2,012 profile views
  1. So I'm confused on a calculation , I'm not sure if I should use a substitute calculation for what I'm trying to do or how to use that calculation by formatting a unformatted number; Example Unformatted Number 21100 Example Formatted Number 02-1100 So I need to add a "0" in front of the number and then always separate the first two numbers with a "-" the numbers be hide the "-" could be 1 or 20 numbers Ideas?
  2. Wim Decorte Thank you for the Help! ill start looking at that reference material.
  3. Ok Ladies and gentlemen, so I’ve dipped my toes into wanting to start using the ExcuteSQL Function, I have no idea what I’m doing with it. I downloaded Seed codes SQL Explore and I am more lost than ever. I don’t understand the function and I am hoping someone can break it down for me. So something simple to start with. If I wanted to get a total value of a field in a related recorded normally I would just use Sum(TestRecord::Field) This would give me a total How the calculation above gets broke down into ExecuteSQL ( sqlQuery ; fieldSeparator ; rowSeparator { ; arguments...
  4. Ok so I have I am having a problem with my Google maps multiple location map everything works perfectly if I have 10 locations or less, the map appears in my web viewer with the pins but any more then 10 locations and my map wont load, Ive tried multiple different locations and the magic number is 10. I do have a Google api and I am filling my Variable locations with a script all the works. but any more then 10 locations I get nothing any ideas? API Removed & Locations removed data:text/html,<!DOCTYPE html> <html><head><meta charset='utf-8'><title><
  5. Ok now really confused when I evaluate I get a one now but under watch I get a zero   Ok I just retyped the entire Let statement and boom it started working I have no idea how or why it was not working before but it is now So hopefully my final question , I really liked how that Let statement worked and how you were able to break it down which makes sense. So which is the better or more efficient calculation a Let or and If statement?  Just for further knowledge
  6. Ok I see Now Result equals the Value Where as Not isempty (What ever field you choose) will always equal a 1 or a 0 That's makes sense but I also see your using carriage returns in-between you values for ListB My Value list I am comparing against is a list that is being populated against a related table field , would this list contain the carriage return when evaluated or is it considering the entire value list as the number to compare against?
  7. Usually I do but since no combination I tried will give me any response it does not show me anything so I cant prove or disprove , for example I can see in my data viewer the variable Lat its exactly what its supposed to be , I can see my Lat list and it match's what its supposed to be why it does not work and always give me a zero hence the reason im am here to learn where my mistake is and how to remedy it.
  8. Based on the function help I would hazard a guess that it would return the values that match ListA - ListB So from the example above it would return 1234? otherwise it would return 0?
  9. Bruce - I did read the filemaker functions help for those to functions and thought I did understand it , which obviously I did not but you example you just gave does help clear it up I think I know understand the List a and be variables but I still do not understand the calculation end Result = FilterValues( ListA; ListB) So If List A has a value of 1234 And lat list has values of 1 12 123 1234 What does Result = FilterValues( ListA; ListB) Return and if not isEmpty( Result ) has the value returned it will show the value returned other wise it will show nothing?
  10. LaRetta not IsEmpty( FilterValues (ValueListItems( Get (FileName) ; "Lat_List" ;Lat)) Give me a too many parameters error So I tried not IsEmpty( FilterValues (ValueListItems( Get (FileName) ; "Lat_List") ;Lat)) And it returned all zeros even for the ones I could see matched an item in the value list
  11. LaRetta - Ill give that a try , Thank you for explaining deeper for me , I Was using -- IF ( FilterValues ( ValueListItems ( Get ( FileName ) ; "Lat" ; LAt_List )="" ) I guess I really didn't under stand the filtervalues combined with Valuelist. Ill give that a try right now , To answer your other questions I will be using the 1 inside a script to locate the records and make adjustments to them. I have been working on a Google cluster map which works brilliantly but when the map is zoomed all the way in the clusters stay clustered since they all have the close to exact sa
  12. Ok I thought this was simple and I might be making it harder then what it seems , I have searched the web and the forums and I guess I just don't get it So I have a value list driven by a related table I want to search against that value list and if the field matches anything in the value list I want it to give me a 1 if no match don't do anything I've tried the filter values , value lists etc functions but to no avail its always a 1 no matter if it matches or not So Field = LAt Value list = LAT_List I thought is would be as simple as If LAt = (Any Value inside the list L
  13. Thanks for the help it has taken me a couple of days to get back to working on this problem I was able to take your advice and changed my relationship to an x so all records are showing I was able to get the exact results I was looking for by modifying your calculation to the following If(Director_Board::Staff_Office_Selection="Combined Offices";Staff_Office_Selection ≠ Office ;Staff_Office_Selection=Office) So now my portals filter by any of the office locations and show all the records if selected that's working awesome! Now i'm stuck again. Previously in my portals I had a "
  14. Ok So I have multiple tables set up to filter out data and show specifically the data for each different office that we have across the state everything works perfect in the following relationship Table 1 Table 2 Administration Board ----------------------- Service Locations Office location = Office Location This works perfect so the Administrators at different offices only see the service locations related to their Office and not all the res
  • Create New...

Important Information

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