Jump to content

Spidey

Members
  • Content Count

    102
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Spidey

  • Rank
    novice

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    OS 10.11

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi, I have two table: Invoice and Customer. I like to have the total of all the invoice for a customer between certain date in the Customer portal that show all the customers, but I got a error when I try to debug.. ExecuteSQL("SELECT SUM(I.TotalAmount) FROM Invoice I JOIN Customer C ON I._kf_CustomerID = C.__kp_CustomerID WHERE date(I.InvoiceDate) between date(C.SearchFromDate ) and date(C.SearchToDate )" ; "" ; "" ) I have an error and couldn't figure it out. Thanks... KC
  2. Hi, I am trying to get the cost from a matrix table. My question is that is it ok to use combine ID using other table ID and use it as a link to connect to other table and get the cost from the matrix, instead of using primary key? Like using a combination of foreign id key to make one unique key to connect to other table with the same key to get the data. Is that ok? If it is not conventional, what is a better proposal? Many Thanks. Text Matrix.fmp12
  3. Hi, I have a field to count the number of records between certain date in calculation: ExecuteSQL ( "Select Count(*) FROM Order2 WHERE DueDate BETWEEN WeekStartDate AND WeekEndDate AND Decoration = 'Digital'"; ""; "") It works the first time but it cannot refresh in the field when there are changes. Is there anything I can do to refresh it? Thanks. KC
  4. Hi, I am new to filemaker. I have created a crosstab table and I like to retrieve data from it in another table. For example, in the layout, "RetrieveData", I like to retrieve the activity name "Apple" in March, I like to get the value "24". How I should approach it in the relationship. Many Thanks. Kent CrossTabInputExample.fmp12
  5. Hi, I am totally new in xslt. I have the following xslt and I tried to export as xml. I got an error. "SAXParseException: invalid document structure". Is there a problem in my structure? What's the proper structure? <?xml version='1.0' encoding='UTF-8' ?> <xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform' xmlns:fm="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fm"> <xsl:output version='1.0' encoding='UTF-8' indent='yes' method='xml' /> <xsl:te
  6. Hi, I have a line inside my tab control in filemaker 16. Do you know what it is for? I have trouble figuring it out... Thanks. Kent
×
×
  • Create New...

Important Information

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