Spidey

Thanks so much for your reply. It is the <refined material> in the line item which is related to the refined material table. I need to link the UUID of both the line item table and the UUID in the refined material table, and together I can only put the refined material name on the line item from the refined material table. I could use the popup menu for the UUID drop list for the refined material, but I like to know how anyone would approach this problem.

I want to use UUID for all my tables and also for linking them together, but I don't want to show the long id. Yet I need them to pull up information from another table. How I can solve this dilemma? Thanks. KC Production.fmp12

Thanks!

Dear All, Thank you for all your suggestions. I found a solution but it's not very professional. I still use UUID to retrieve information and use serial display ID. I have the Display ID overlap the UUID drop-down menu. I have the Customer ID clear when the user clicks the down arrow in the drop-down menu to select customer. If there is another way to do it use the drop-down menu. Please let me know. Thanks. 1ToManyRelationship_2nd.fmp12

The scenario is for the files to be in two iPads and need to be imported to the main file in the server. And also for displaying a readable id for layout. Thanks so much for your reply. KC

Hi, I am new to UUID in FileMaker. In the past, I used serial numbers as my primary key, but now I want to use UUID as my primary key. However, in the layout I want to create a display ID and retrieve other information because UUID is too long and unusable. How can I use UUID in the relationship, and use display id to retrieve the information from another table. Thanks. KC 1ToManyRelationship.fmp12

Hi, I have Filemaker 19 and have a calendar on the layout. My question is I don't want to have events on the calendar. Instead, I want to display orders and some of the information. Is there a way to do it? Thanks. calender.fmp12

Hi, I am new to FileMaker. Let's say I write an app and upload to the iOS appstore. And later I make lots of changes like adding new functions and new layout in the app and I want to do update of the app which is already in the iOS store and in the users' ipad and iphone. 1) How is it going to be done? 2) Is the user data going to be safe after the update? 3) Is the procedures going to be the same as the desktop app (Any alternative other than doing "Import")? Thanks KC

Thanks. I finally know how it should be used. KC

How to use "allow creation of records"...and "delete related records in this table"...in the edit relationship. I have attached a file, and I know how to use the "allow creation" and "Delete related records" on the right side(Invoicelineitem). When I delete the records, I know it would delete the line items when I check "delete related records" in the invoice lineline items. I don't know how to use the allow creation of records and delete related records on the left side(Invoice) in the edit relationship. Thanks for your help Regards, KC TestRelationship.fmp12

I created a demo file. My question is how to create customer sales total without using ExecuteSQL. Go to the report and click customer report. And you would see my sql statement. Is there a way to do the same thing not using sql? If I export it to iPhone ExecuteSQL may not work....Thanks. KC Customer Sales Report.fmp12

Hi, I created a form which has two different ports. My question is how to print a report data coming from two ports, since they are different. I can only print report from one portals... Many thanks. KC

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

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

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

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

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:template match="/"> <cityforcast> <xsl:for-each select="fm:FMPDSORESULT/fm:ROW"> <forcast> <id><xsl:value-of select="./fm:ID” /></id> <city><xsl:value-of select="./fm:City” /></city> <temperature><xsl:value-of select="./fm:Temperature” /></temperature> <humidity><xsl:value-of select="./fm:Humidity” /></humidity> <windspeed><xsl:value-of select="./fm:Wind Speed” /></windspeed> <winddirection><xsl:value-of select="./fm:Wind Direction” /></winddirection> <clouds><xsl:value-of select="./fm:Clouds” /></clouds> </forcast> </xsl:for-each> </cityforcast> </xsl:template> </xsl:stylesheet> Weather.fmp12

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

Hi, Do I need to pay more to FileMaker for producing runtime solution in Filemaker Advanced 16? Thanks. KC

I use filemaker 11. I like to take each picture file and match it to the filename and insert the picture in a folder. My logic should be as followed: Loop for each picture in a folder, set the variable x as a picture filename. Search x(picture filename) Insert the picture file to the container End I have problem look to set variable and set it as a picture filename from a folder. Can anyone help me to look for the right function or command from filemaker 11. Thanks. KC

Thank you for your reply. I am looking to integrate filemaker and prestashop so I can add, delete, or change items in filemaker to control prestashop. The following link say it can be done. https://www.prestashop.com/forums/topic/32573-managing-prestashop-via-filemaker-pro/ Does anyone know the details of how they integrate together? Thanks. KC

Can all PHP functions and libraries works in Webdirect in filemaker server 11? KC

I was pulling data from the wrong table. It should be ps_product_shop instead of ps_product if I want to search for price. Thanks.

Hi, I have FileMaker 11 and I created a interface to pull data from my website's sql. I am able to change the name of a product, but I cannot change the price of the mysql table through the FM 11 interface. Is there something I miss doing? I am using odbc to connect. Thanks.

Thank you for your reply. Yes. Server file is in the fm server. And don't worry the local server in product master. It was for testing locally.