Devin

You are correct. Should have said near the bottom. But to answer you question. No there will not be another ValueObject with these.

Interesting approach. I tested this and it works. Is their away to import this for every record? Found at the bottom of XML. <objectName>JobProject</objectName> <primaryKey>5915</primaryKey> The <objectName> is the Filed Name and the <primaryKey> is the Vaule

I'm trying to import an XML with the XSL, but it's not working. I'm not exactly sure what my issue is.. let alone if what I'm trying to do can even work with style of XML. Currently I've been using xpath to loop thru and get all the records but due to the large number of records this can take a very long time I've attached the example xml and xsl. Inventory.xsl Inventory.xml

Yes.. I did mean relationship..Sorry about that.

Sorting that Portal worked perfect.. Thanks

I've got 4 tables. Product, Vendor, VendorProducts and Product Price. A Product can have multiple Vendors. Each Vendor has their own price for a product. My issue is I want to also Track the Price changes a vendor makes but also show the latest pricing when looking at a product. When setting up the Portal to list the VendorProducts on Products is not an issue but returning the latest Product Price based on a timestamp is the issue. I could create a script to place the latest price in the VendorProduct but that seems like the wrong approach.. The other thought is maybe create a Calc Field in VendorProducts to return the price is thats possible? Or maybe there is even a better way.... Thanks

This worked perfect.. The use of Mod is something I would never have thought of. Thanks

Comment, Yes you are correct, it should have been AM for the 2nd example. After reviewing, it will be best to get the result as TimeStamp. I can easily extract Date from a timestamp if needed later for something. You are correct on your understanding of the result. But know that we are wanting to return a Timestamp, we will want to return not only the correct date but change the Time to 1 PM. Thanks

So I'm in need of calculating a Timestamp field that will give me the next Wednesday date. Here is the calc that I started using GetAsDate ( Date ) + Mod ( 4 - DayOfWeek ( GetAsDate ( Date ) It works, expect now I need worry about the time. If the time is after 12pm on a Wednesday I need to return the next Wednesday and not the current Wednesday. Examples 10/16/19 2:04:35 PM --> 10/23/19 10/16/19 8:23:55 AM --> 10/16/19 10/15/19 4:26:35 PM --> 10/16/19 10/18/19 6:14:17 PM --> 10/23/19

Comment, Thanks for the XSLT.. This worked. But it turned out that they system that was in-taking the XML could only handle single items at a time...Ugh.. So I ended up creating a script that would add the remainder to the largest value. Thanks for your help

So I knew I could do rounding in an XSLT but never tried. But the remainder part Interesting!!! When you say a simple correction of the last value would be trivial.. Could you give an example? Not seeing anything trivial from my thought process.

I'm exporting to another system via XML. and the filed will need to be x.xxxx but to keep it simple I just need to give x.xx (0.80).

I'm in need of some help in what might be the best way to go about solving my issue in how it relates to Filemaker. I've got a table that is using 3 fields "Sqin", "sqin.s" and "PercentUsage.c" Sqin = number filed sqin.s = Summary - Total of Sqin PercentUsage.c - Calculation (Sqin / sqin.s )= This give me the exact percentage of each record.. Issue is I now need to export the data to another system, but it only allows for 4 digits.. ( 0.1234). Due to simple rounding when you add up the values you may get less then 1.0 or more then 1.0. Doing some google searches I came across this site that I think explains the issue pretty good and how to go about resolving it. For this project the accuracy does not need to be perfect and if a few are off that is fine. https://stackoverflow.com/questions/13483430/how-to-make-rounded-percentages-add-up-to-100 So any ideas or ways that I should be thinking in how to solve this issue? Thanks

Did you install the the correct Java? https://support.filemaker.com/s/article/Changes-to-Java-in-FileMaker-Server-18-0-2-and-Later?language=en_US

So if no updates to the system have been done.. and Computer has been restarted and your still having an issue then either the custom or the XML it's self is bad.. Can you go back and parse an older XML that did work? We are kinda blind as we don't have the XML that our trying to parse.