Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rockxyzzy

  • Rank
  1. Aha! I see what you mean now. I was fixated on some sort of external text file solution and didn't even think of this approach. Thank you.
  2. Uh, log table? Didn't know there was such a beast. Poking around the FMP Help doesn't reveal much about creating a log table. How would I go about that?
  3. For debugging purposes I need to create some sort of logging capability that I can deploy at a client site to catch an intermittent problem that I can't track down. I've created a variable that concatenates the suspect variables, date, time, record number, and script step. I've successfully used the Export Field Contents to export this concatenated string to a text file. The problem is, I need to export this string hundreds of times during a session to catch the anomalous values and see what's going on and the way I have it done now, each export overwrites the external text file exported by the previous execution of the command. Is there an elegant way to make this Export command export to a single, ever growing text file, or capture a large quantity of this concatenated string internally for my analysis later? I'd like to do something that would be little or no effort for the non-technical client to email back to me for analysis.
  4. Worked like a charm! Thank you very much! This is great!
  5. Fantastic. Thank you. I'll give this a shot and see how it goes. Thanks again.
  6. One question about custom functions: does a custom function reside at the application level or at the document level? That is, if I install a custom function into a specific file and then give that document to someone else running the same version of FMP, will the custom function be available to them when they open my file in their copy of FMP?
  7. This is cool. Thank you. I'll have to figure out how to install and use a custom function; I've never done so before. Thanks!
  8. I have a user who continues to use the "Return" key instead of the "Enter" key after populating a field with a PO Number. The result of this is that subsequent searches fail to see a match between the fields containing "PO123" and "PO123" because of the hard return character in the field. How can I set up FMP 8.5 Advanced to ignore trailing hard returns in a field for the purposes of content comparison? (I can't merely compare the values of the first X characters because the field must be very dynamic, as the PO Numbers being entered are from a variety of external customers and have no set format, structure, etc.)
  9. Ok, I've sorta got this working with the Value List/ValueListItems combination. The only remaining issue is that the list that's returned by the ValueListItems contains every invoice number in the system, not just the invoice numbers in the subset of records that I produced by searching for a specific Purchase Order number. I think the problem is that there's no relationship involved: the invoice number and the po number are in the same table, the timesheet entry table. You see, this system is for keeping track of a variety of temp employees, placed at various client sites at various bill rates, etc. The PO number support is at the request of a few clients who pay temps against POs that the client has generated internally. So, the user of this datbase is the company that provides the temp employees to clients. The user receives timecard data (which may include a PO number provided by the client) and they enter the employee id, the client id, week ending, hours worked, po number, etc. and the system builds invoices, based upon these timecard entries/invoice line items. All of this brings me back to the problem: I now have a return-separated list of every invoice number in the system, not just the ones in the subset created by searching for a specific PO number. I feel like I'm close to having this, but I'm baffled as to how to take it the rest of the way.
  10. Many invoices can be billed against a single PO during the life of the PO, however, a single invoice never reflects more than one PO. Yes, you are correct. The invoices are built from invoice items (timecard entries, actually) that are parsed and sorted to build the invoice (obviously, all transparent to the user). And what I'm obtaining is an invoice ID list (with duplicates) as you describe. I'll take a look at this custom function. Thank you very much! The problem I'm still having, though, is that my List function isn't returning a group of invoice numbers, it's returning a single invoice number entry that's identical to the single record above it. I guess I'm not using the List function properly.
  11. Hello! I have a db in which a invoice numbers and PO numbers are tracked. The relationship is such that multiple invoices can be created against a given PO number. I'm trying to use the List function to build a list of unique Invoice Numbers when the user queries for a single PO number. In other words, the user would like to enter a single PO number a see a list of all unique invoice numbers associated with that PO number. I have the search working: it successfully pulls up a list with an invoice number entry for every time each invoice is billed to a given PO, with repetitions. When I try to use the List function to produce a listing of unique invoice numbers from this found set I'm getting only a single value, not a listing as I would expect. Somehow, I need to make the List function operate over the entire found set and not on a per-record basis. Does this make sense? (8.5 Advanced, Mac OX 10.4)
  12. Thanks for clearing it up. It makes sense the each script would have a unique identifier to prevent problems.
  13. I think I found a workaround by opening each script in the source file, copying all the steps, opening the same script in the destination file, deleting all the script steps, and finally, pasting the script steps from the source file into the destination file. This seems to be the only way to replace a script without breaking links. Please tell me there's an easier way.
  14. Hi! I've just made a ton of changes to the scripts in a development version of my file (one with test records that I've entered) and I'm ready to import the modified scripts into the live version of the file (the version without any test/debug records inserted). When I import a script, every button object in the entire database loses its connection to the imported script. Is this a limitation on importing scripts?!?!?!? If so, that's a pretty significant failure, if you ask me. It seems amazingly bad for FMP to be unable to retain a link to a button object for a script that's replaced with an imported one. If I'm missing something here, please tell me how to replace an existing script with an imported one and not break links to any button objects that link to the replaced script. (For some reason, my signature is showing old data. I'm running 8.5 Advanced under Mac OSX 10.4.10)
  • Create New...

Important Information

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