Jump to content

Jonas Löfvenmark

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jonas Löfvenmark

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Dear bcooney, thank you for your input! There are different files as this project will be a huge PIM system involving thousands of products from hundreds of manufacturers sold through multiple franchises in different regions and languages with storing of images as well as price calculations in different currencies, also tracking competition pricing. Phew, almost fainted writing that - what a project... Anyway, 1 file simply gets too blurry incorporating everything so I try to plan ahead and keep things as separate as possible. Do items related to more than one Company? Do items have more
  2. I have a table of Companies, operating in differing Regions (defined in a Regions table), stored in a repeating Regions field for each company. For my Items table (located in a different file) would like to store Companies in a repeating field in a similar matter, and be able to set Regions for each item via a value list based on the Regions defined in each Company. If: Company A have Regions 1, 2, 3 Company B have Regions 2, 4 and I select Company A for the first repetition of the Items Company field and B for the second repetition, I would like the value list for the items
  3. the goal is transforming something like this: id1: "Audiogear -> Microphones -> USB-Microphones" id2: "Audiogear -> Wireless equipment -> In Ear-monitoring -> Receivers" id3: "Audiogear -> Wireless equipment -> In Ear-monitoring -> Senders" id4: "Guitars -> Instruments -> Electric Guitars" etc. for 485 records times 4 languages to: id1: "Audiogear", parent: root id2: "Microphones", parent: 1 id3: "USB-Microphones", parent: 2 id4: "Wireless equipment", parent: 1 id5: "In Ear-monitoring", parent: 4 id6: "Receivers", parent: 5 id7: "Se
  4. Interesting - I get the same result on my client using mac, PC, and Filemaker Server windows with loads of memory! I need this for exporting data to a webiste where items are sorted based on priority (higher values first) where as the data in filemaker is sorted ascending. Also the filemaker data has one record for each item and group where as the website needs groups separated from items with parent linking to group items. Filemaker data 1 Computers -> Mac 2 Computers -> PC Webiste data 1 Computers 2 Mac, parent 1 3 PC, parent 1 (yes, it is poorly structur
  5. Funny how sometimes you just need to sit down and formulate a problem to understand the solution Found what I believe to be the best solution by avoiding getnthrecord and instead using a value list. By defining a value list for the Name column and using the valuelistfunction you get a set of unique set of names. Then find the position of the record's name in the list of names, like: Let([uqNames= ¶&ValueListItems("myfile";"myvaluelist")&¶ ; myname = name ; mylist = Right(uqNames;Length(uqNames)-Position(uqNames;¶&myname&¶;0;1) )] ; PatternCount ( mylis
  6. I am trying to define a calculation to check if the name field has changed from the next record, and add a counter if so like: name order DESC A 3 A 3 B 2 C 1 Case(Get(Postnumber)=Get(FoundPosts);1;Let([ this=name; next=GetNthRecord(name;Get(Postnumber)+1); value=GetNthRecord(order DESC;Get(Postnumber)+1)]; Case(Exact(this;next);value;value+1))) (I've translated the get functions from swedish to english as I remember them - if wrong it's my bad) The calculation above functions fine up till 173 records. Adding record 174 the calcula
  7. Äntligen är Super Mario tillbaka från semestern. Det har varit för få grodor och pudlar i svensk politik på sistone...

  8. Yes, that could be usefull! Thanks for input!! Position( ¶ & List( cities::name ) & ¶ ; ¶ & "Paris" & ¶ ;0 ;1 )
  9. Thanks! Will look into that. For now I came up with: getnthrecord( cities::id ; PatternCount(Left( List( cities::name) ; Position( List( cities::name ) ; "Paris" ;0 ;1 )); ¶) +1)
  10. I see.... hm. Thought I had id! Kudos to your hawk eyes. Any idea on how to do this? basically an automation of what happends when I manually select a entry in a valuelist that is set to only show the second column.
  11. Found it! Thanks for your fast reply though. GetNthRecord ( cities::id ; Position(List(cities::name) ; "Paris" ;0 ;1 ))
  12. Good day dear FM friends, I have hot stuck on something much trivial - something I though would be a breeze to set up, but apparently not. Please help, dear friends! I thought I could easily find a function similar to GetValue but the other way around. With a valuelist based on cities::id to show cities::name I would need to do something like: getValueListItem("cities value list"; "Paris") to return cities::id. I understand I can use position to find the position in the list, but how about the corresponding id?
  13. Thank you all for all your input! I have this working for one hosted file, but strangely enough not for the other; by setting the filemaker service to "allow desktop access" I can export to a server side local drive by using the CNSImage_Export function on a variable. Exactly what I wanted! Why this only works for one of the files is a mystery. Both file's script run fine from the client, but only one of them from the server. Both files have the same user with full access, and both scripts are run with full user access. Next I will look into importing images from a network share, and
  14. 18 December: Ytterligheternas dödsdag. RIP Václav Havel, BIH Kim Jong Il

  • Create New...

Important Information

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