Jump to content

Dimitrios Fkiaras

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Dimitrios Fkiaras

  • Rank
  • Birthday 07/30/1972

Profile Information

  • Gender
  • Location

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

1,324 profile views
  1. Hello, I have VIRTUAL LIST ----x---- PERSONELL tables connected with cartesian join. On a layout based on the PERSONELL table, there is a "filters" button that fires a script, which gathers data from some tables and presents them in a list (VIRTUAL LIST TABLE) . User clicks on a record (search criterion) , fake checkbox is updated and the search in PERSONELL TO occurs. The problem is that if I don't first close the card window and only then perform the search, the found set in the parent window remains unaltered. Is there a workaround to this? Closing the "filters" card window, performing search and opening again is not very nice to watch. Thanks for all the support!
  2. Thanks! I guess we will have to live without these for the time...
  3. Is it possible to style a card window with round edges?
  4. Hello all and happy New Year! I am working into my first and only solution which expanded quite a bit. Now it has 4 modules: HRM, LOGISTICS, CALENDAR and DOC MANAGEMENT I would like to have a UI similar to what is proposed widely today : A fixed sidebar accordion menu. The reason is because I think this type of menu kind of orientates the user in the app. Where he is and where he can go. Is there a way to achieve this in FM18? What are your thoughts on this kind of UI and the alternatives? I have already built an accordion menu shown on a card window - with the limitation that is not visible all the time. Thanks a lot!
  5. Hello, I have a script with a single step, attached to a button. Step: Open URL: "prizmogo://x-callback-url/captureText?input=camera&ocr=el&x-success=fmp://$/MYFILE?/script=Dialogue" When I press the button, the Prizmo Go application fires up, I take a photo of the text, it recognizes it but the application stays open. I want to close the application and return the results to FileMaker. What am I doing wrong? Anyone? Thanks.
  6. Well, the solution seems to work... What amazes me is how fast FileMaker makes all these calculations. I'd expect that 2000 calc reps x 75,000 records will take a long time. Even in Webdirect there is a delay of just 1 sec (LAN). Maybe my knowledge is a bit limited on this matter also. *New: Even with 20000 reps X 75,000 records there is no delay. Why?? After maybe the 2000th rep all other calc repetitions result to "empty". So we can assume that FileMaker engine can summarize empty repetitions instantly?
  7. Well, if I select a date that lies before or after the 2000 reps I get a "?" in the calculation. I defined 2000 reps for the sake of the test. I am thinking to define maybe 90 reps. If the user selects a date before the initial date or after the final rep date, I am thinking to show a warning like: "You have selected a date range that is not expected. It will take some time to calculate --- OK, Cancel" and then set a different initial date so the 90 reps will cover the desired range As for the $variable... no particular reason... my ignorance... I removed it. I will test the solution on WebDirect and let you know of its performance.
  8. Thanks! I don't know if I am being very dumb, but this version seems to work pretty fast. CrossTabR_Test.fmp12 PS. When I created the test data I didn't take care to avoid overlapping absences, so summarized data could be off sometimes
  9. Thanks a lot for the explanation! As for the second part, you are partly correct. The people responsible for approving leaves etc. want to have the big picture of absences for... lets say -3 / +15 days in order to be able to decide. There's no reason to navigate throughout the past... or the empty future. Just a little back and forth. Unfortunately the Refresh Window script step takes soooo long to complete on Webdirect (FileMaker Pro handles it just fine, even on legacy PC's). All in all we just need to summarize around 150-200 records (100 people with approximately 1-2 leaves in 15 days). That is why I thought of filtering the relationship.
  10. Thank you very much! The calculation is very elegant! The problem is that when I change the gReportDate, the summary field refreshes only for the selected record!! I tried moving the fields gReportDate and cDateR to the Personel table, only to confirm the same behaviour. Then I filtered the relationship by adding gReportDateStart and gReportDateEnd fields, and the summary fields auto refresh. Why don't the repeating calculations evaluate with the change of gReportDate?? CrossTabR_Mod.fmp12
  11. Thanks a lot! Though I feel more comfortable with native FileMaker solutions!
  12. Hello to all, I am building a solution, where the user needs to see a crosstab absence sheet of their personell. The people there can be absent for a variety of reasons, (absence types) which are recorded. The users want to be able to select a date and see the absent personell for a certain date range. I tried very hard to find the a way to do this, so that the app will be responsive. The solution is accessed via WebDirect (so I tried to avoid the Window Refresh script step) So far I have come with two ways to do this. The first way is based on a repeating calc and the second one on a summary field (which summarizes a repeating calc) See the attached files (the records in the real solution, will not be as much. Maybe 1/10th.) How would you approach this problem? In the past I tried to solve this problem with filtered portals in each date, or with virtual list. Both solutions didn't seem to be fast enough (although I admit I haven't spent the time to optimize them, like the current solutions). I also thought about creating a summary table somehow but cannot finish my though on this. I suspect that there may be a better way to do this (maybe without calculations, only relationships). Any help is greatly appreciated. Thank you all! Absence_sheet_demo_1.fmp12 Absence_sheet_demo_2.fmp12
  13. What exactly is a clinic? Can you send a screenshot from you relationship graph?
  14. I want to conditionally format the items (btns, fields) in the active row of the master portal. Thus my formula is : Get (ActivePortalRow) = Get (RecordNumber). This works ok, but when I click outside the portal, the formula no longer validates correctly. (however, in the Data Viewer, the Get(ActivePortalRow)=Get(RecordNumber). I am using FM17 on Windows 7 machine.
  15. Sorry for continuing this thread. I haven't got any success in showing a local .html file thru WebViewer I entered the absolute path, as that was calculated by the example file in post #2 (for a MAC computer) The webviewer seems to find the file but give me a message that a suitable application was not found to open the file What is wrong? ** UPDATE ** Solved : I had a problem with slashes "/" "file://Macintosh HD/Users/JohnDoe/Desktop/Folder/File.html" correct format
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.