Jump to content

djeans

Members
  • Content Count

    84
  • Joined

  • Last visited

Community Reputation

0 Neutral

About djeans

  • Rank
    member

Profile Information

  • Gender
    Male
  • Location
    Hawaii

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.14.2

FileMaker Partner

  • Certification
    Not Certified
  1. I've run into another snag. I need to do a calculation that includes the total amount arriving across all three weeks. For instance I need to add the value of my field "OnHand" to the total amount arriving. I tried OnHand + PendingOrders::sTotalQtyByWeekR but that did not work. I also tried: Sum ( cQtyToWeeksR [1];cQtyToWeeksR[2];cQtyToWeeksR[3] )+ OnHand but that stops at the first related record/repetition Any suggestions on how to make that work?
  2. It took me a little while, but I got it working!!! I can't say I understand what your calculation did, but I was able to extrapolate from your file the fields and calculations and add them to my database and get it working. For that I am very grateful!!
  3. Sorry if it was a little confusing. The c_weeknum field was added just so I would know what fiscal week product was arriving for, but I had been basing all my calculations on the projected arrival date (which is supposed to always land on a Thursday). Thank you you for the file. I will try it out when I get home later tonight. Thank you so much for the help.
  4. This report would typically only be ran on Monday, with my orders for "this week'' coming in that following Thursday. The weeknum column is the number of the week that the given item is projected to arrive (Monday to Sunday) I guess the "this week" calculation is always going to reference the next coming Thursday in my scenario.
  5. Yes, there is a quantity of purchases that would need to be totaled for each.
  6. Thank you for the reply. I actually am going to have to use them in further calculations. It's part of an inventory/order projection program I'm trying to make. I have a layout, that when in preview mode, shows a list of products and how much of each I have on hand, calculates my average usage per week, takes into account what I have on-hand, and then recommends how much to order for next week. That all works fine. For a few of the items that I have to have shipped to me (that takes 3 weeks to arrive) I'm trying to have it also keep track of what's on-order and arriving each week, and also be able to project what I need to order this week, in order to have the right amount on hand 3 weeks from now. Kinda complicated to explain, but this screen capture of the order layout may help to make sense of it.
  7. I have a problem trying to use a calculation to pull information from a related table that hopefully someone here can point me in the right direction to solving. I have two tables, related by a barcode field. On the first table (PendingOrders) I have a list of items that I have ordered, how many were purchased, and a projected arrival date. Any given item (same barcode #) may appear on the table multiple times with different projected arrival dates On a second table, I'm trying to add calculation fields that will tell me how much of each item I have projected to arrive this week, how much next week, and how much is expected to arrive in 3 weeks (as well as many other fields, but those aren't important for this question, I don't think). The problem I run into, is that only the First projected arrival date returns a useful number. For instance, if I have widget A expected to arrive all 3 weeks, the first calculation field returns a result, but the other two do not. Here are the calculations I'm using. For orders arriving this week Case ( PendingOrders::ProjectedArrival < Get ( CurrentDate ) + 7 ; PendingOrders::s_purchase ; "" ) For Orders arriving next week (week2) Case ( PendingOrders::ProjectedArrival < Get ( CurrentDate ) + 14 and PendingOrders::ProjectedArrival > Get ( CurrentDate ) + 7 ; PendingOrders::s_purchase ; "" ) and for the 3rd week: Case ( PendingOrders::ProjectedArrival < Get ( CurrentDate ) + 21 and PendingOrders::ProjectedArrival > Get ( CurrentDate ) + 14 ; PendingOrders::s_purchase ; "" ) Can anyone help me trouble shoot this.
  8. That seems to have done the trick!! thanks for the suggestion. Will not know for sure until this Sunday when I will be using the database again, but for now, it seems like it's working. Thanks again.
  9. Thanks for the suggestion. That seemed like it would work, but I'm having a hard time writing the if statement to check to see if there is an entry on the related table based on what was just entered into my field (a barcode number). Was trying If ( not IsEmpty ( BtlBarcode ) and LiquorCatalog::Barcode = "" but it launches the script whether there is a matching entry or not.
  10. I am updating an old database that I haven't used in awhile. I used to use EventScript plugin to launch a script from a calculation, but have lost it and it doesn't seem to be available anymore. Is there a built in way to accomplish this now? My calculation is just an if statement that checks if there is an entry in a related table, and if not, launches a script. Thanks
  11. That almost works. It doesn't fail on the export step anymore, but the import now seems to import blank data. That is, after performing the import step, nothing is there. It works on the mac still, but not on the ipad.
  12. The export and import are part of the same script. I tried copying and pasting the entire script here, but couldn't do it for some reason. Let me try again. Allow User Abort [ On ] Go to Layout [ “LiquorCatalog” (LiquorCatalog) ] Show All Records Constrain Found Set [ Specified Find Requests: Find Records; Criteria: LiquorCatalog::Par: “>0” ] [ Restore ] Go to Record/Request/Page [ First ] Set Variable [ $exportPath; Value:Get (DesktopPath) & "OrderExport" ] Export Records [ File Name: “file:$exportPath”; Character Set: “Macintosh”; Field Order: LiquorCatalog::Barcode LiquorCatalog::LiquorName LiquorCatalog::Volume LiquorCatalog::Par LiquorCatalog::Vendor ] [ No dialog ] Go to Layout [ “LiquorOrder” (LiquorOrder) ] Show All Records Delete All Records [ No dialog ] Import Records [ Source: “file:$exportPath”; Target: “LiquorOrder”; Method: Add; Character Set: “Mac Roman”; Field Mapping: Source field 1 import to LiquorOrder::Sku Source field 2 import to LiquorOrder::Item Source field 3 import to LiquorOrder::Size Source field 4 import to LiquorOrder::Par Source field 5 import to LiquorOrder::Vendor ] [ No dialog ] Sort Records [ Keep records in sorted order; Specified Sort Order: LiquorOrder::Vendor; ascending LiquorCatalog::BinNumber; ascending ] [ Restore; No dialog ] Constrain Found Set [ Specified Find Requests: Find Records; Criteria: LiquorOrder::Order: “>.5” ] [ Restore ] Go to Record/Request/Page [ First ]
  13. Thanks for the response. I wasn't able to figure out how to alter that to work for my. One of my current scripts has an export records step with file:$exportPath an tab separated text. and an import records step that is file:$exportPath It works on the mac, but I can't get it to work on the iPad. Originally the steps were file:ImportExport/orderexport.tab but I changed it because I couldn't create the ImportExport folder on an iPad
  14. I'm trying to move an old database over to iOS with Filemaker Go, but have run in to a couple of problems. Everything functions for the most part, except there are some scripts that export records to a tab delimited file, then later re-import that data. On the iPad the script always fails saying that the file could not be created. The files on my Mac were set to export to a folder conveniently labeled "Import/Export" but with iOS you don't get access to the file system. Is there a work-around for this? Thanks in advance for any help.
×
×
  • Create New...

Important Information

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