filemakerdeveloper40

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

That is EXACTLY what I'm looking for.. Thanks mattowlby!

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?

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.

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?

OK.. I figured it out. It had to do with a portal filter.

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

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!

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

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

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