So I have a hosted solution, with a dashboard with a couple portals. When I go to scroll a portal, scrolling even one portal screen has a delay of a few seconds, ie I click the scroll bar or try to drag it, and it takes about 3 seconds before it moves. Running locally, it's instantaneous. Running on a dev server on my LAN, there's a slight delay, but minimal.
Having read various threads about this situation, my first thought was it's due to a filtered portal, so I removed filtering, but that made no difference.
I also read various posts about unstored calcs and other factors that would cause all the data to have to be transferred to the client over the WAN.
But here's the thing - at the moment, there are about 20 records in the database, related to the particular portal.
Clearly, moving that data can't be the primary issue - right?
I do have a lot of Execute SQL calculations in related tables, and I've read that can cause poor performance. But wouldn't that only be a factor when there are a lot of records?
Are there design /schema choices that would cause significant lag regardless of the amount of data?
Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) )
how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help.
Thanks for any help
I have developed an work order intake form on Web direct. The problem I'm having is that some users can't see a portal I have to enter certain information. Whereas most users do not have this problem. This is occurring on window users using Chrome. I am using FMP 16 and Server 16.
Does anyone has any idea why this is occurring. Is this a chrome or windows problem?
By Haris Durrani
Assalam u aliqum dear Brothers
I am creating a database for a Bricks Kilns. Though me being a beginner i have managed to make it somewhow but now i am stuck in making a portal of customers where i enter bills and the record should go tot heir related filed.
I have following tables
Customers (linked to with foreign key)
Challan (further liked to)
The portal shows only one customer related record
where as i want a portal where when i cretae record it goes automatically to related customer record.
Sample file is attached
By Panagiotis Alexoula
First of all im newbie in fm. I use the filemaker 16. I want to make a new base that keeps track of pages and especially registerstations and log ins. So i created 5 tables:
"sites, user_names, passowrds, emails and account_descripion) I linked the tables with relationships. I created a portal witch have fields from three different tables, a field user_name from table user_names, a field password form table passwords and a field email from emails table. When i insert the first line(raw) in the portal ιτ seems to work. but if i try to insert values in the second line (say in a site you vave two accounts like facebook one ofiicial and the other one "a fake account") it seems that something is not working properly. I upload a 3m12sec video to show you what i mean. Please check it if you have the time.
Also, the source file that im working on is in this link (filemaker 16 file):
Thanks for your time