Jump to content

djeans

Members
  • Content Count

    76
  • 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.12.6

FileMaker Partner

  • Certification
    Not Certified
  1. 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.
  2. 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.
  3. 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.
  4. 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 ]
  5. 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
  6. 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.
  7. 1 more question. How would I constrain the found set of the sub-summary records? I'm not sure that made sense, but basically, I don't need to generate 1099s for anyone I paid less than $600 to. So, My script currently creates all 4 versions of 1099s for everyone I paid out to, regardless of amount. I'd like it to exclude anyone under $600. I tried adding a constrain found set line in the script, but it is looking at individual records, not the sum, which makes sense, but I'm sure there must be a work-around. Is this possible?
  8. Thanks again for all the help. It looks like it will work perfectly for my needs, and hopefully I'll be able to expand it when and if my needs expand. On a whim, I created a duplicate sub-summary report and placed a graphic in the body of a scan of a 1099 form and placed the appropriate fields where they would go. I also added more fields to the employee table (address, etc) and placed those fields on the form as well. This is probably a ghetto way of creating a 1099, but to my surprise, when I ran the report, it generated a 1099 for each band member. I have no idea if this is a "legit" way of creating 1099s that I can give the guys, but I still thought it was pretty cool!
  9. Correct. It's mostly the same 4 people, with the occasional sub musician if someone is sick or on vacation, etc. It's also, for the most part, the same venue week to week, with the occasional added show now and then. For my needs currently, this simple solution should work for keeping track of how much is paid to who for the purpose of then later creating 1099 forms. If FMP can do that too, that is pretty cool, but since I couldn't figure out how to create this simple report, I doubt I'll figure that one out either.
  10. When creating the subsummary report, I'm running into a couple of problems. I'm only getting the first 2 EmpNumbers on the report, and only the amount of the last payment allocation, not the sum of all of them. What I did: Create a new layout, with a header (for the labels) and a "Sub-summary when sorted by" part with PaymentAllocations::EmpID selected, with print below chosen. Then I placed the fields PaymentAllocations::EmpID, Employees::Name, and a new summary field that I created called PaymentAllocations::TotalPay that is a Total of cAmount, with running total and restart summary for each group sorted selected, and set to summarize repetitions all together. I also tried just placing PaymentAllocations::cAmount and PaymentAllocations::sTotalAmount as well, but neither of them worked.
  11. Thank You! It looks like that functions pretty much exactly as I was imagining. Now just have to figure out the final reporting to break down how much each was paid. That sounds amazing. Especially the calculating and printing the 1099s. I haven't played around with Filemaker in a few years (notice the old version lol) and I'm a little rusty on how to get things accomplished, but I'd love to try to implement some or all of your ideas.
  12. I'm confused now. Are these fields on the Allocation table or the payments table. (maybe we should rename that one to Gig table for clarity?) On the payment/gig table, the unique id would be an auto-generated serial #, yes? And there would be an auto generated Serial on the allocation table too? I guess I don't understand the allocation table concept. If you're willing, here is a link to the original file I started, and a new one I just tried to start based around what I thought You meant. Care to open it and make the links for me? I really appreciate the help. https://www.dropbox.com/s/cyxe47xmxez4x4t/FilemakerExamples.zip?dl=0
  13. Thank you for your response. I think I understand what you said, but just to clarify. . . I have created the PamentAllocations table with the fields: EmpNumber, Name, Date, and Payment. Do I relate this table to both of the other tables by EmpNumber? I assume I will need a few more fields on the BandPay table - one for each band member, and a corresponding pay field as well, yes? I like the script idea, I'll try to work out how to make that happen.
  14. I'm not sure i'm posting this in the right forum, but hopefully someone can help me out. Short description of what I'm trying to achieve: I'm in a band, the paychecks come to me, and I divide up the pay and give to each band member. It's on me to keep a record of the amounts so that I can 1099 them at the end of the year, and not be stuck with all the taxes. I'm trying to create a bare bones simple DB that I can enter each gig with a gross pay field, and then the name of each band member, and what they were paid. The goal is for speed and efficiency, so my idea was to manually enter the date, venue name, and gross pay, then use a repeating field to enter the rest with calculations filling in as many blanks as possible. I have a database with 2 related tables - Employees, and BandPay Each band member has an Employee Number (i'm 1, Bassist, 2, drummer 3, etc) as well as the occasional additional musician that gigs with us. Tables are related by the EmpNumber. My form is set up with repeating fields for EmpNumber, Name, and net pay - I enter a number in the # field, the corresponding name is looked up in the NAME field (that's working) and I would like the net pay to auto enter as a calculation of (gross pay / number of fields that are entered). (sometimes we play as a trio, sometimes quartet, etc . . ) - That is the part that is not working. Essentially, I'd like the Net Pay field to auto update every time another name is added to the list, for each instance of the repeating field. ie, if the gross pay was $300 and only one name was in the repeating field, they would show as a Net Pay of $300. As soon as a second name is entered, both would now show $150, and so on. Of course, after I figure that out, I'll try to create a report to show how much each person was paid over the year, but first I have to tackle this problem. Hopefully someone can help, or if you have a more elegant way of achieving this, I'm all ears. Thanks in advance. PS, I'm using an old version of Filemaker Pro (Version 10 Advanced) I tried to attach my file, but I am not allowed.
  15. Thanks!! I knew it has to be possible, just couldn't figure it out. Thanks again. Darron
×

Important Information

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