mr_vodka

Because it wasn't created efficiently for that. Keep in mind that you don't have control over the SQL statements that are being sent. FM interprets a user's actions and then tries to create a query to match what you are asking of it. Sometimes it is perfectly fine and other times very very inefficient, depending on what the structure and action given. It is best suited for ancillary activities to a core system IMO. Calculation fields created in FM in the shadow table of your SQL table will be unstored calculations and not indexed. It is better to create the calculation in the view or table in your SQL table itself. As for what UI changes that should be made etc TBH I am sorry to have some bad news for you... It would take a lot more than the forums to create an efficient system. It just takes a lot of experience and trials, a very good understanding of SQL besides just basic SQL selects, and then knowing when to leverage the native SQL system features where you can. Again for things such as simple relationships and simple searching, you may want to give it go as it should be efficient enough. However, if it gets pretty complex then better to find a work around. I would start here and then also read all the additional resource info. https://www.filemaker.com/learning/custom-app-academy/205/external-sql-sources-ess.html

Hi Pedro. What comment is saying is spot on. You may be able to get the result you desire but you may have to change the type of UI you use. You can search for "google type search filemaker" and you should come across many posts on the subject. Also quick finds will search all your fields. Perhaps this old thread can help you a little.

Besides having to ensure that your data will fit properly into SQL data types, once migrated over, I don't think you should expect to just use the existing UI and repoint it to the new SQL tables. FM should not be used strictly as UI to build off of SQL systems. You would have to reevaluate and re create some of the UIs to efficiently use via ESS. A bunch of things can be off loaded to the SQL side with optimized views, trigger, and stored procedures.

Click the popover ITSELF and name it. As OlgerDiekstra said, you have name the button object for the popover, not the popover itself.

https://360works.com/filemaker-sync/ https://www.geistinteractive.com/products/filemaker-sync-gozync/ https://www.seedcode.com/filemaker-sync-gozync/ https://www.filemaker-sync.com/en/ http://www.fmgosync.com/ http://www.restfm.com/restfmsync/

Case ( IsEmpty ( Projects::filter_assignment_status ); 1 ; IsEmpty ( FilterValues ( Projects::filter_assignment_status; Assignments::Status ) ) ) You will need to refresh the portal. You can use a simple script trigger to refresh the portal when the global field is modified. * This also assumes that you want to show all the records if nothing is checked in the global. If you do not want that, then just rid of the first part of the Case statement.

well you can keep your original relationship and then use the filter portal option.

This would have been a lot more obvious prior to version 16. The zoom controls used to be at the bottom of the document window and users could use the - / + buttons to zoom in and out. The script step would lock / unlock it so that users could not use the buttons. With version 16 and up, the option is in in the View window or keyboard shortcut. Locking it with the script step would disable users to change it from the view menu.

Unstored calc can not be used on the child side of the relationship as a key field.

In the inspector. The first tab "positions" tab.

I believe this would be set by their machine as to what application is the default when opening various file types.

Those pre canned templates are just that. They are starter solutions. If you are trying to combine 2 of them, you will need to import all the tables, recreate the relationships, import the scripts, and create new layouts ( you can copy and paste from the other template ).

Your synopsis layout is based on Cabinet Library. Shouldn't you be using the 'Total Minutes for Door' field from Cabinet Library?

10 years later? If you haven't figured it out in 10 years then maybe time to hire someone? lol 😂

I'm not sure what you mean here. You should be able to to insert the file into your containers field in a hosted solution. If you have a common network shared location, then you should be able to capture the file name and path since you can use the UNC file path. One more thing you can look at is using a global container field which you can then store the path in a text field.