Jump to content

Bridge

Members
  • Content Count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Bridge

  • Rank
    Bridge
  1. Hi, I have data that I want to import into the same field, where I currently have a calculation where the last name gets stripped out. (eg. Bill_Smith) so only Smith appears in the field (I use the "middle"/'position' with "_" to only have "Smith" appear in the field. The question is that some of the data that I am importing has the 1st and last name switched around (eg. Jones_Nancy). So I was wondering if there is a script solution to this problem. I have got the calculation to strip out the last name in the "Jones_Nancy" example. But through the script, is there a way to select which way I import into the same field? These old data files that I am importing, I now which name format each data file is, based on which company created the data files. Is there a script solution? I am not sure how to approach this problem. I am thinking I might be making it more complicated than it is. Any comments on this problem would be great, so I can get my head around it.
  2. Bridge

    Script question

    Hi, Thank you for your response. I do actually have that relationship set up already, so the field in the 2nd (sum) table fill out really well (but I have to type in the item and date manually, checking against the main database to see if I got all the right items for that date). In my scripting, I think I will 1st try in the main table to 'show only 1 record for each unique item" and then continue with the script to create a record per item / per date in the other table. I think it might be more simple than creating a loop that goes through the data in the main table searching for unique items that then triggers creating a new record in the (sum) table. I will write an update post on how it all turns out. Bridge
  3. Hi, I am half way there for a new script that I am doing. This part is where I am not figuring out how to do it. I have 2 tables that share a relationship 'by date". The main table has all the data in it and the other table I am needing to create a summary of all the data 'by date" and by item. The script for creating the new record and populating the data from one table to the other works well (with portals and such). However, in the main table, there are multiple records with the same item. What I was trying to figure out is how to automate is only create a record 'by date' and 'by item." That means if I have 25 pens, and 5 rulers, only 2 records would be created in the new table with the new date, one record saying 'pen' and the other saying 'pencil'. The summary table works really well once the word 'pen, and 'pencil' is typed in manually. I am wondering if I should first do a script to omit records that are in the same field "item' info, and then continue with the script to create new records in the other table, or if better to type incorporating the find unique item into a loop. And advance would be great. I am pretty excited since the data sums up really well and creating records for each item per day in a new table, allows me to manipulate the data in other ways. Any advance is greatly appreciated.
  4. Bridge

    Script - Accounts & privileges

    Hi, Thank you for your responses. I am in the freelance world, where my fellow co-workers are all freelance during a given period of months to a year (tv - film world) to a company. I have no problem passing on the database for the said project I am on, however my fellow freelances will most likely take a copy for themselves and pass it as their own for their next job. I don't mind that either, but I thought it would be nice to have a 'splash" of some sort that appears on launch saying that I creating the database. That way, if someone else (other freelancer) is using it, at least my name can appear on launch. That way they won't clam it as their own and it is advertising for me for anyone else who ends up using the database. That was really my reason for trying to create a non-modifiable script of sorts. But it looks like if I set a privilege set, it blocks the user from creating new databases and such. Does not seem that I can do that. Unless I am wrong? Thank you for your responses
  5. Hi, The database I am currently creating, I will have to pass onto the company that has employed me when my contract is up. I have to give them access to everything, but I have created a script that appears on startup (as a script) that says that says my name (Script = Show custom dialog). I was wondering if there is a way that one script can not be modified? Everyone at the company accesses the database via other account other than the me (administrator). I just hate to see all my work be given over ( I was not hired to create the database, just has become a minor part to this job)and not have a none-modifiable splash of sorts say that I at least created it. Any help on this one would make me totally happy. All the best, Bridge
  6. Bridge

    Tracking assetts

    Hi, I just worked out my own last question. Works really well. Just wondering about something else. Just wondering if for the 'current location' if there is a way of adding a 'default' location for all the other items that have not been shipped and are still sitting in the main place of origin? Would this 'default location' have to part of a calculation or can I add it in as part of the 'options' in the original 'shipping to' field? Bridge
  7. Bridge

    Tracking assetts

    Hi, Thank you for the fmp example database. I think this is totally what I am looking for. Just a question though. Since I might be moving 10 or move items on one tracking number and the next shipment to the new location might not be the exact items, I guess the best way as what I am gathering from the database, is just as there is a drop-down menu for the item iD, each log id (shipment tracking number in my case) would also be a drop-down number. That way if the 1st 10 items were sent on the same shipment to the same location, but then only 3 of those 10 get moved to the next location, I will be able to create a new record with a new LogID to track the new shipment (location). Am I getting it? Best, Bridge
  8. Bridge

    Tracking assetts

    Hi, This is more of a general question about another portion of a database I have been designing and I am not sure how to proceed. I have to track the location of a given item from one location to another (the item having been sometimes shipped to various locations before returned back to its place of origin). I want to create a tracking history of this item and also want the main database to only display the latest location of the item. How is that for confusing. Anyway, any pointers would be great. I was thinking relationships together with portals? Bridge
  9. Bridge

    Collapsing list

    Hi, Wow. Thank you. It totally works now. You've just given me a window into a new area of Filemaker that I am most definitely going to explore more. Thank you!!! Bridge
  10. Bridge

    Collapsing list

    Hi, Thank you for pointing me to the direction of custom functions (totally new to me). There are steps (lack of understanding) that I am missing. I am going to post what I have done, even though I suspect it will be totally laughable to those whose understand FMP. I created the custom function named "CollapseList" and added the function parameter called NextList. I lift the calculation box empty. And said "OK" to close the window. Then I went to my define database to a my "collapse numbers" field that I created and pasted the custom function in there and replaced the "listofvalues" to my return separated field of numbers called "Sum numbers". At the end of the calculation, I replaced the "CollapseList (NextList)" to "CollapseList (sum numbers)". What appears in my field "Collapse Numbers" is only the very 1st number in the return separated list. Totally confused. Bridge
  11. Bridge

    Collapsing list

    Hi, The field with all the numbers is return separated (between each number). I tried it again and only got the very 1st number to appear. But it is certainly since I removed the "CollapseList ( nextList )" at the end of the function, since my filemaker 8 said it was an unknown function and I was just wanting to see if I could exit the calculation window. Am I in too old a version of FMP? Still a snail - Bridge
  12. Bridge

    Collapsing list

    Hi, Thank you for the link to the Brian Dunning site. I found some very useful calculations / topics. But I did try the CollapseList and I am most definitely not getting it. Could it be because all of my numbers are in one field, not a value list? I also found another calculation on the same site called Pagenumbers_condensed_with_dashes. I played around with this one too, but I didn't understand in the calculation "flag". So I was not able to get through that one too. Still working on it - Bridge
  13. I have recently started using functions. I was wondering if someone can point me in the right direction for a calculation I would like to use. I am wanting to take a data in a field that is separated by commas and added dashes to collapse the data. This is what the data currently looks like: 210,211,213,214,376,377,400,501,502,503 I would like the calculation to produce: 210-214,376-377,400,501-503 Since sometimes the data separated by commas can be 50plus numbers in consecutive order, than a jump in the data, I am looking for a way to condense the data. Since I have been having a lot of success figuring the functions, I think I have drawn a complete blank on this one. I am thinking, should I explore "range" functions? Best, brigitte
×

Important Information

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