fileman922

hello Wim i was checking my UPS console and it has an option to insert a command that shutdown aplications before shutting down the operating system my question is how to write a command that close the databases in Filemaker Server?? i really appreciate your help thank you

thanks for your reply, i would like to know how to setup the ups to run a system level script? how the script will look like? please let me know thank you

Hello, i have a ups connected to my server so after 5 minutes when power fails, the server begins a shut down. My question is , that programed shutdown will affect my filemaker server databases? Will they get corrupted? Power fails here in my country its frequently. Please let me know Thank you

I have my database in FileMaker Pro and works fine..... the problem is when opened in filemaker go .... filemaker go does not have "enter preview mode" so it can't count the pages is going to print. for example " Page 1 of 5" does anybody has a solution to do this in filemaker go? thank you

We just upgrade to filemaker 16 thinking we will have better performance on our barcode inventory database..... at the time we scan barcodes in a fast way, fm16 leaves some readings incomplete... for example when scanning 10 same items with product number 802312 in a fast way , we got the first 3 records with 802312 and the next 7 records with 2312 ... filemaker 16 miss the first 2 characters... we had to downgrade to fm 15 .... i would like to know what could be the problem? I have a exit trigger script after each reading, the script contains a refresh portal and a commit, it works fine with filemaker 15

Hello we use filemaker server 15 and some macs takes long to upload an image in the container field, it takes about a minute to insert 100kb image.... when using filemaker server 14 it does not happend.... what could be the problem?

Thank you !! It solves the problem

Hello Lee Smith thanks for your reply yes i test the script : in the line 10 it ask to choose printer then when i choose it i press print and instead of print it shows me a PDF mac preview.

Hello , im having problem with filemaker when i try to print an invoice ... i usually press print button and then filemaker ask for printer and then prints, but now when i press "print" filemaker ask for printer and then it shows me the invoice in pdf.. it does not print .. i have to type command P to print that pdf. here i attached my script steps my script use to works fine but now i don't know whats happening.

i have an invoice solution with a summary field that summarize the price of all the line items, now i want to make a layout that shows only the invoices that are more than 500 dollars total. i have been trying but summary field in find mode is not modificable. please let me know any solution thank you Mauricio

Thank you ! it works

hello, i would like to know how to take just the last 2 characters of a field example: if the field is "342399" i would like the field "99" or field is 3467564354677 i would like the field "77" i know how to delete characters but i dont know how to leave the last 2 characters. please let me know thank you

i would like to ask if i will have performace issues in my inventory-invoice database for using unstored calculations ? i choose unstored calculation to see real time inventory. my database is products - invoices hosted in filemaker server, i have about 8 unstored calculations in each record im planning to use 200 products per semester and about 150 customers ... right now im not having troubles about performance but im worried in the future , i had read that having unstored calculations with many records it slows down your database. what i have to do to prevent that ? better hardware for server? or changing structure of database? please let me know your opinions thank you !

thank you very much!!

im sorry for my bad english price level is the category for each customer I mean, i have many customers and they are in different categories . example : “ retailres “ , “wholesale” , ” consumer” etc. 10 categories in total and each category has different prices for the products . example : red shirt for wholesale cost 10 usd red shirt for retailers cost 15 usd red shirt for consumer cost 25 usd etc so i will need 10 fields on products table to store all the prices for each category . so the calculation i have is like this . Case( customer_category = “wholesale“; products::wholesales_price ) + Case( customer_category = “retailer”; products::retailer_price ) so my question is ,,, is better to setup the prices this way or is better to create a portal in products and then check the price with a lookup? im looking for performance