
tmas73
Members-
Posts
376 -
Joined
-
Last visited
Everything posted by tmas73
-
Remove Text format to phone calculation!
tmas73 replied to tmas73's topic in Calculation Engine (Define Fields)
Sorry, but what does this mean? -
Perfect, thanks!
-
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
-
Remove Text format to phone calculation!
tmas73 posted a topic in Calculation Engine (Define Fields)
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 -
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?
-
Great, thats perfect. The naming convention should be better once I implemented this fix! Thanks for your help! T
-
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.
-
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?
-
OK here the file it might be easier and you see what I try to fix. Log: 1 Pass :2 Sales_Relation.fp7.zip
-
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?
-
Dublicate portal script step.
tmas73 replied to tmas73's topic in Script Workspace and Script Triggers
Its basically just for the user to duplicate a existing record incl. its portal entries. -
Dublicate portal script step.
tmas73 replied to tmas73's topic in Script Workspace and Script Triggers
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) ] -
Dublicate portal script step.
tmas73 replied to tmas73's topic in Script Workspace and Script Triggers
Interesting what does GTRR: mean? -
Dublicate portal script step.
tmas73 replied to tmas73's topic in Script Workspace and Script Triggers
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 -
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 ]
-
Is that possible? I did not find any info on that. T
-
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
-
Solved! connect eo_materials to eo_contacts_lookup Tooltip.fp7.zip
-
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]
-
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
-
Hi, what you mean the index of the file structure or what referred to?
-
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
-
With someone's help in a different forum, the solution is attached! Log:1 Pass:2 webcap.fp7.zip
-
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.
-
Heheh foreigns ehh. =) You cannot replicate it? Can you have a look at this screen cap? Capture Thanks