
Peter (duksis3)
Members-
Content Count
165 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout Peter (duksis3)
-
Rank
member
- Birthday 09/21/1953
-
Two-directional currency converter
Peter (duksis3) replied to kav's topic in Calculation Engine (Define Fields)
Hi, 1)How did you trigger script? 2)Just PriceUSD*Rate isn't enough - Round is necessary, or omit digits starting from 3rd after"," - depend from how is accepted by accounting department. 3)Import USD and EUR into separate fields and show them in new calculation field. Approx like this: If (Is Empty (Trim(USD)); Round(EUR/Rate;2); If (Is Empty (Trim(EUR)); Round(USD*Rate;2);"")) And you can include value from field Show all in USD/EUR: If(USD/EUR=USD;If (Is Empty (Trim(USD)); Round(EUR/Rate;2); If (Is Empty (Trim(EUR)); Round(USD*Rate;2);"")); If (Is Empty (Trim(USD)); Round(EUR/ -
Rounding up to next quarter?
Peter (duksis3) replied to JariV's topic in Calculation Engine (Define Fields)
Hi, The first that comes in mind is: N-number to be rounded UP You can use Case or If. In general formula is (Case): Case [N-Int(N)>=0 and N-Int(N)<=0,25; Int(N)+0,25; N-Int(N)>0,25 and N-Int(N)<=0,5; Int(N)+0,5; N-Int(N)>0,5 and N-Int(N)<=0,75; Int(N)+0,75; Int(N)+1] -
Field separation for import/export
Peter (duksis3) replied to saralee's topic in Importing & Exporting
I have seen lot of posts here regarding similar questions. Probably you can find answer via search -
Login to Wordpress using Web Assistant fails
Peter (duksis3) replied to brian rich's topic in 360 Works General Support
Hi, I think that you need to connect WordPress MySQL and FileMaker databases because WP login is connection to WP MySQL. Web Assistant is for FileMaker database. -
Hi, PHP files typically have small special part for IE. If doesn't work - problem is here. Open every file involved including CSS with text editor and compare "original" (made by PHP Assistant ) and modified. It can take some time.
-
Name field calculation
Peter (duksis3) replied to Henry Ammons's topic in Calculation Engine (Define Fields)
Hi, Need some more explanation - if there is 2 persons: you want to see both to choose witch one? Probably you can use portal -
Runtime created on Mac OS sent to Windows Vista will not execute
Peter (duksis3) replied to Sandolini's topic in Windows
In general - here is no big question or problems if you are on the OS X: 1) Install Win via BootCamp, 2) Install FM Pro Advanced on Win, 3) Open FM file you need to convert to runtime. 4) Take a look on layout - field sizes, fonts, portal sizes - because typically you need add 2pt in size for Win version and fonts also sometime need to be changed. 5) Make runtime. 6) Test and if OK - send it to the client. 8) client don't need FM to run it, as you know -
Runtime created on Mac OS sent to Windows Vista will not execute
Peter (duksis3) replied to Sandolini's topic in Windows
That is correct. You need to create runtime on Windows machine to run on Windows machine. That is a bit dummy because you need to install filemaker on 2 machines if you need to create runtime for 2 platforms. -
Hi, I haven't go very deep in your solution but some years ago I make something similar and I use duplicated particular table(s) in the Graph (for another relationships) to get more easy working or (what you say) put left and right part together.
-
How to generate a sequence of dates for import?
Peter (duksis3) replied to ebenjen's topic in Importing & Exporting
Hi, As I can see - you have a sequence of days from date. Question is - do you need to convert to dates once (after import) or calculate all the time? If once, I'll use temporary script - starting from first record and looping through the end and new date field. You can use LeftWords function to get next or current month. And year is defined by script. -
You can open PDF via FM web viewer. So you just point address (calculation) to necessary PDF (better is to keep all Help PDF's in one folder together with corresponding FM file).
-
Hi, This is internet provider question - ask him to bind www.website.com to http://12.12.12.12 address via DNS. Then you can use IWP as you like.
-
Upgrade to FM11 is to expensive.