lutfishah
-
Content Count
12 -
Joined
-
Last visited
-
fmp17 Conditinal Formatting Validation
lutfishah replied to lutfishah's topic in FileMaker Pro 17 Advanced
Perfect @OlgerDiekstra you did it It works. Great thanks And thanks to @comment as well -
fmp17 Conditinal Formatting Validation
lutfishah replied to lutfishah's topic in FileMaker Pro 17 Advanced
Sorry, it didn’t work -
fmp17 Conditinal Formatting Validation
lutfishah replied to lutfishah's topic in FileMaker Pro 17 Advanced
Thanks for your reply Correct that Conditional formatting is not a validation but we just are using it for visual validation that if a value is incorrect then it should only highlight it by filling a red colour. Please see my code below. Case ( Filter (Left(myfield ; & Middle(myfield ;6; 4) & "-" & Middle(myfield ;11; 4) & "-" & Right(myfield ; 4); "abcdefghijklmnopqrstuvwxyz_@!#$%&'*+/=?^_`{|}~") ; 0 ; 1) = 0 or If (Length ( myfield ) = 19 ; 1 ; 0 ) = 0 and IsEmpty (myfield ) ≠ 1 -
Dear All, I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here. The criteria of entering a value is xxxx-xxxx-xxxx-xxxx 1111-2222-3333-4444 1. Length of value is = 19 OR this should be a 16 digit number, in groups of 4 separated with dashes 2. Non-Digits characters are not valid. Please could you help me with this and I will really appreciate. Many thanks Regards Lutfi
-
Dear All, I'm struggling with the "open url" script step where I am trying to switch between a FileMaker (v17) database in web direct to another website. But rather than opening the web page in the same tab it opens up a new tab. Is there any way to open a web site in a browser in the same tab when using Open URL script step. Many thanks for your help
-
Hi Nuos, Thanks very much for your help. I have managed to make it work. So for the time being I'm fine. Sorry I couldn't reply to any of the posts as I was away. Best regards.
-
Sorry about that. Yes all invoices per hour per calendar date. Basically current date. Yes I have the time field. So lets say there are sales made Date: 18/03/2015 Invoices 09:00 --- 100.00 09:05 --- 200.00 09:30 --- 50.00 10:00 --- 90.00 10:15 --- 300.00 ... so on Totals Per hour 09 hrs = 350 10 hrs = 390 ... Thanks so much ... I will quickly create a test file for you. Cheers
-
Thanks for your reply. Would you know a better way of calculating the sums of invoices per hour. I need a calculation please.
-
Hello, I need a bit of help with my filemaker database. I'm not really good at using Filemaker charting system. I want to display the hourly sales in a chart. So if someone could please let me know a better way of getting totals of the invoices per hour of one day and then displaying them on a chart per hour. so x-axis = 09:00 10:00 11:00 12:00 13:00 ..... y-axis = the totals of the invoices. Many Thanks for you help
-
Hi, I'm creating a POS (Point of sale) database using Filemaker on a Windows (PC). Do you guys know which hardware to use? I'm in the UK Basically I need to know which Kiosk screen, Cash Drawer, Thermal Printer, Barcode Printer and Debit/Credit Card Machine(chip and pin / EMV) I should use. If someone has tried any plugins please let me know. I will really appreciate it. Many THanks Lutfi
-
Thanks Cabinetman for the nice idea but please can you show me how to set a variable on xsl : ) Thanks
-
Hi Folks, I am trying to export some data in xml format from filemaker using XSLT. I want to display the same data in three places on the xml. I was displaying the data once by using for-each tag. <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <xsl:for-each select="fmp:COL[3]/fmp:DATA"> <marker> <name> <xsl:value-of select="."/> </name> <xsl:variable name="pos" select="position()" />