I'm using some script to direct users to different layouts when the access my database via WebDirect. At the moment all users are directed to one of two layouts using the following
#t ( Case ( APP__Application::Type = "Long" ; "Application Detail WEB" ; "Application Detail Rapid WEB" ) )
What I actually need to happen is that when a "reviewer" logs in they are directed to "Application Detail Review WEB" for everyone else the above code is correct.
Any help would be much appreciated.
I generate an invoice by a report.
The work is totalled and then VAT/GST is calculated and the total work + GST = the invoice value.
These 3 fields appear in a trailing grand summary. One above thew other above the other:
Total this invoice
Depending upon the number of items in the invoice the invoice may have more than one page. Again depending on the precise number of items in the invoice I can finish up having 2 of the 3 summary fields on one page and the remaining one on another page.
I would like to be able to print the invoice knowing that the 3 summary fields will be kept together irrespective of the number of items, or pages or where the page break occurs.
I cannot see how this can be achieved.
I would like to ask question for which I didn't find answer. I have several filemaker dbs which differs only by data entered. All tables and fields are same. My question is if it's somehow possible share layout design across all those databases because occasionally I need to modify that layout. Change it in all dbs could be time consuming. Of course I can have empty "design db" where I could re-import data after layout change but again it could be time consuming too.
Also I'm wondering if is possible to use field name (in layout) without any table name and table would be used relative by table defined in layout? (Shows records from)
Greetings and thanks for giving this a look!
I am rebuilding a client's database that was done formerly in PHP. I'm now using FM 16 Pro Advanced. There is one print layout I'm having trouble recreating.
There are a number of data fields the realtors fill out...some get filled in, other times some don't. In addition it needs to print the name of the data field then the data itself, so for instance "Construction Stick Built". I've figured out how to go through and print only the fields (and their labels) that have data. The issue I have is with the spacing in the columns.
In the attached photo, you can see that each label/data line is neatly organized in a column so that the space between the label and the data is consistent all the way down the column. It's not centered, and it's not justified...it calculates for each row of data, how much space is needed in that row to line everything up.
Would I need to determine how wide the column is, and then calculate how long the combo of the field name and data is (with that nice separator space in between them) and then use that to space everything? Seems like a lot of calculations going on but maybe that's what needs done?
I also need to figure out if the data will require it being in 1 column or using a 2 column like the one in the picture. I believe I can figure that out...it's this 2-column alignment/spacing that's got me tied up.
Hi I can not fiddle out how to make it work. I have tried several browsers with same result. We are using FM 12 server. I tried this file paths
and few others
I'm using this code in the Web Viewer which is working fine in FM client but not in browser
"data:text/html, <html> <head> <style type=text/css> " & table::style & " </style> </head> <body> <div class='thumb'> <span class='helper'></span><img class='thumb' src='" & table::ThumbnailPath & "'> </div> </body> </html>"
If it's caused by fact image is not present in web site folder as stated in document then my question is if it possible use unc network path in filename like file://///other_than_fmserver/networkpath/file.jpg. I wasn't successful either.
Any help appreciated