Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About filemakerdeveloper40

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

1,547 profile views
  1. I feel like the answer is right in front of me, but I can't seem to nail it. I keep getting a syntax error. Here is my calc (testing in the data view for now): Let ([ theDate = Totals_Daily::Daily_Totals_From_Date ; ID = Totals_Daily::ID ; query = "SELECT SUM (Daily_Qty) FROM Totals_Daily WHERE Daily_Totals_From_Date=? AND ID=? GROUP BY Daily_Totals_From_Date,ID" ]; ExecuteSQL ( query ; "" ; "" ; theDate ; ID ) ) If I remove the second parameter (ID) and simply sum by the date, I
  2. I'm trying implement a feature on a list view using FileMaker Go that works similar to the iOS Mail app. When you swipe to the left, a Delete button shows. It's nothing super fancy, but what I've noticed is that when I swipe, the control slides for all records rather than just the one I want to see the delete button for. Is this normal behavior? A bug? Is there a way to force the slide control to only slide for the active record?
  3. I actually thought of that, but then wondered about whether or not the order can change which is why I was wanting to look for the 3-character designator rather than depending on the order as your expression suggests. I don't know if the order can change, but if it can, then your Let statement won't populate the correct values.
  4. I have a return separated list of values (from a drivers license) where each line has a 3-character designator such as: DACFrank DCSSample DAGSample Street DAK90210 What I need to be able to do is to identify the line I want using the designator and grabbing the values to the right of it. In other words, using the list above, I only want the street (DAG) returned. What's the best way to do this?
  5. OK.. I figured it out. It had to do with a portal filter.
  6. I have a layout that is rendered via IWP in FileMaker 12. On this layout I have a portal that displays related records (attachments). The process to add an attachment includes going to a new layout (which contains the SuperContainer web viewer) and creating a new record, adding the file, and then clicking a button which takes you back to the parent record. For some reason, when I navigate back to the parent record/layout, the portal doesn't show the record I just added. If I navigate to another layout and then back again, it shows fine. I also confirmed that it works as expected if I do the sa
  7. Brilliant.. I love it when I learn that I've been looking for a far more complex answer than is really needed. Your example solved it. Thanks so much!
  8. I am trying to write a recursive custom function which looks for any match between two lists and simply returns a 1 if there is a match or a 0 if no match exists. A list may contain 1 or more values. Here's what I have so far: Function: DivisionAccess ( rec_division ; my_division ) Let ([ thelist = my_division ; value = ValueCount ( thelist ) ; access = If ( rec_division = GetValue ( thelist ; value ) ; 1 ; DivisionAccess ( rec_division ; my_division - 1 ) ) /*access = Case ( rec_division = GetValue ( thelist ; value ) ; 1
  9. I didn't see a forum for security, which struck me as odd, but thought this might be the next best forum.. I have users logging into a solution where, once logged in, they have access only to specific records. More specifically, the can view records that belong to the same division as they user. I have the security working fine, but what I don't like is that users, upon logging in, will see a list of records which contain both records they can see and records marked with <No Access>. What's the best way to filter out the records they don't have access to? Since they don't need to kno
  10. I'm trying to get a value list formatted like the following: CALL Initial Inquiry Leadership Call EMAIL Initial Introduction Rep Check-in MEETING Client Sales Meeting Weekly Meeting NOTE Company Background I have attached an example file showing what I've done so far and where I was heading. The issue with my approach (thinking I could use a sorted relationship) is that a value list has a sort associated with it. I've left my example as is though so you can see what I was after. Here's a little more explanation: The header rows are hard coded a
  • Create New...

Important Information

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