Jump to content

tmas73

Members
  • Posts

    376
  • Joined

  • Last visited

Everything posted by tmas73

  1. Sorry, but what does this mean?
  2. Perfect, thanks!
  3. How is it possible to have 2 case functions in one calculation? Case 1 = Case ( uw = "g" ; ?; uw = "oz";: * .0352739619 ) Case 2 = Case ( lye_type = "NaOH" ; recipes::sum_NaOH * (1 - superfat_percent / 100); lye_type = "KOH";recipes::sum_NaOH * (1 - superfat_percent / 100) ) Both NaOH and KoH should have the possibility of "g" and "oz" conversion. Case ( uw = "g" ; (Case2); uw = "oz"; (Case2 * .0352739619 ) Thanks
  4. Hi, I have following format in my phone number field. Let([ con_phone_1 = Filter(con_phone_1;"0123456789"); Length = Length(con_phone_1); Phone10 = "(" & Left(con_phone_1;3) & ") " & Middle(con_phone_1;4;3) & "-" & Middle(con_phone_1;7;4); Phone11 = "(" & Left(con_phone_1;3) & ") " & Middle(con_phone_1;4;4) & "-" & Middle(con_phone_1;8;4) ]; Case(Length = 11; Phone11; Length = 10; Phone10; con_phone_1) ) How can I remove the text format in this calculation? TextFormatRemove (con_phone_1) Thanks
  5. Hi I run into a small problem when a user enters nothing in the category field the record hides and is not accessible in the portal window, anyway around this, besides a field validation?
  6. Great, thats perfect. The naming convention should be better once I implemented this fix! Thanks for your help! T
  7. Thanks susan but what tables do I have to connect in order to get the calculations going? If you look at my sample I have the fields already there the problem I'm facing is my lack of relationships to get this working.
  8. Sorry about that. 1. Sum of all Products sold and subtracted from total stock with products left. 2. The user should see how many products are left and how many were sold. He should see it and also be able to print a report of the sales. (Time period sounds like a good idea) 3. Product layout also should display the contact the product was sold to. Does this help?
  9. OK here the file it might be easier and you see what I try to fix. Log: 1 Pass :2 Sales_Relation.fp7.zip
  10. Hi, How can I add up all the sold products? So if I sell 2 products to one client and I sell 5 products of the same kind to a different client how can I add up all the sold products. Is the picture enough or should I post a file?
  11. Its basically just for the user to duplicate a existing record incl. its portal entries.
  12. Something like this? But how does it know to import this record? Go to Related Record [ From table: “oil_materials”; Using layout: “oil_detail” (oil_materials) ] [ Show only related records; New window ] Import Records [ ] [ No dialog ] Close Window [ Current Window ] Go to Layout [ “recipes” (recipes) ]
  13. Interesting what does GTRR: mean?
  14. So should I repeat the whole top script step? Like this? Sorry but I dont understand the way it repeats. Set Variable [ $OrigWindowName; Value:Get ( WindowName ) ] Go to Related Record [ From table: “oil_quantities”; Using layout: “oil_quantities” (oil_quantities) ] [ Show only related records; New window ] Select Window [ Name: $OrigWindowName ] Duplicate Record/Request Set Variable [ $NewRecipeID; Value:recipes::recipe_id ] Select Window [ Name: "OilDupes" ] # Duplicate Oils Go to Record/Request/Page [ Last ] Loop Duplicate Record/Request Set Field [ oil_quantities::recipe_id; $NewRecipeID ] Omit Record Omit Record Exit Loop If [ Get ( FoundCount ) = 0 ] End Loop Set Variable [ $OrigWindowName; Value:Get ( WindowName ) ] Go to Related Record [ From table: “eo_quantities”; Using layout: “eo_quantities” (eo_quantities) ] [ Show only related records; New window ] Select Window [ Name: $OrigWindowName ] Duplicate Record/Request Set Variable [ $NewRecipeID; Value:recipes::recipe_id ] Select Window [ Name: "EoDupes" ] # Duplicate EOs Go to Record/Request/Page [ Last ] Loop Duplicate Record/Request Set Field [ eo_quantities::recipe_id; $NewRecipeID ] Omit Record Omit Record Exit Loop If [ Get ( FoundCount ) = 0 ] End Loop
  15. I need help on this script. I have a layout with 3 different portal tables and the script should make a duplicate record and also duplicate the 3 portal tables. The script works fine with one table but it wont Loop/repeat the other 2, whats wrong with the script? Thanks # # # Set Variable [ $OrigWindowName; Value:Get ( WindowName ) ] Go to Related Record [ From table: “oil_quantities”; Using layout: “oil_quantities” (oil_quantities) ] [ Show only related records; New window ] Select Window [ Name: $OrigWindowName ] Duplicate Record/Request Set Variable [ $NewRecipeID; Value:recipes::recipe_id ] Select Window [ Name: "OilDupes" ] # # # Duplicate Oils Go to Record/Request/Page [ Last ] Loop Duplicate Record/Request Set Field [ oil_quantities::recipe_id; $NewRecipeID ] Omit Record Omit Record Exit Loop If [ Get ( FoundCount ) = 0 ] End Loop # Duplicate adds Go to Record/Request/Page [ Last ] Loop Duplicate Record/Request Set Field [ add_quantities::recipe_id; $NewRecipeID ] Omit Record Omit Record Exit Loop If [ Get ( FoundCount ) = 0 ] End Loop # Duplicate EOs Go to Record/Request/Page [ Last ] Loop Duplicate Record/Request Set Field [ eo_quantities::recipe_id; $NewRecipeID ] Omit Record Omit Record Exit Loop If [ Get ( FoundCount ) = 0 ] End Loop Close Window [ Current Window ] Commit Records/Requests [ Skip data entry validation; No dialog ]
  16. Is that possible? I did not find any info on that. T
  17. Is it possible to display the current browsed URL in a field? If I have a url field in filemaker and the webviewer is using this field as url reverence, how can it be possible to update the field dynamically when I browse in the webviewer? Thanks
  18. Solved! connect eo_materials to eo_contacts_lookup Tooltip.fp7.zip
  19. How would I go about that? With a find script step? I tried this, but wont work SetVariable [$recnumber; Value:Get (RecordID) Go to Layout ["scrap_webcap" (scrap_materials)] Print Setup [Restore; No Dialog] Adjust Window [Resize to Fit] Enter Preview Mode [] Go to Record/Request/Page [No dialog; $recnumber]
  20. I have the webviewer using a fields url properties to load a page. If I switch to preview mode it loads a different records url. Is this normal? If so how can I preview the correct URL? Thanks Webviewer.fp7.zip
  21. tmas73

    File Size??

    Hi, what you mean the index of the file structure or what referred to?
  22. tmas73

    File Size??

    Dont know where to post this topic but I'm curious. I uses one of my solutions and deleted everything I could think of in the file, there should be nothing left. the file size is 828kb. I then created a new document and the file size is 52k. What is in the file that makes it so much bigger? Thanks
  23. With someone's help in a different forum, the solution is attached! Log:1 Pass:2 webcap.fp7.zip
  24. Awesome, at first sight looks like it! I wonder it seems the g_filter doen not work. I changed the show all in the popup menu? I will have a seperate button for show all (portal rows) the show all in the popup menue is just for the categories. =) But good idea this way. Thanks so much.
  25. Heheh foreigns ehh. =) You cannot replicate it? Can you have a look at this screen cap? Capture Thanks
×
×
  • Create New...

Important Information

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