• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About nexgen

  • Rank
  • Birthday

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
  1. Even if I give full access to records, if I don't show them in layouts then is there anyway the user will have access to those data? I have full access to records for design simplicity. I know its bad practice but it comes with the easiness in design.
  2. I have given access to all records in all tables. The script trigger are on the layout they have access to but for performing some of it's action it needs to goto restricted layout. For example: Go to layout: "Restricted Layout" Request new record etc... That's exactly what I am trying to do. They have access to all records/tables but going to restricted layout won't work via script. Good suggestion. However, I think it will cause lots of clutter with lots of multiple layouts. I'll have to think about it.
  3. I don't want certain layouts to be seen by certain users. However, some of the fields needs to be modified in those layouts by certain scripts. I tried but those users who don't have access to certain layouts (restricted from manage > security) can't trigger the scripts which access the fields from those layouts. Hence, I have given access to those layouts but have hidden them from layout menu. This still don't solve my problem since I am always worried that due to some mistake the user will have access to those layouts which they shouldn't see. Isn't there anyway to run the scripts and access the fields from those restricted layout while at the same time they are restricted using the security?
  4. Thank you for the info.
  5. I had heard that filemaker downloads a single record with all fields from server even if there's only one field in the layout. That means the server needs to calculate all the calculated fields before downloading. Is that correct? You are right. I'm splitting the table.
  6. Can you please elaborate more on right 'summary' buckets? The only way I know to create the summary is by defining sub-summary part.
  7. This will still need the records to be sorted since I'm using sub-summary.
  8. I have some sub-summary layouts which needs sorted records. Since, my file is hosted in filemaker server in cloud, all the records are fetched first before sorting. This is causing some delays and I'm imagining what will happen if there will be lots of records. Is there anyway to speed it up?
  9. I noticed webdirect don't show custom menus. I don't use buttons in layout to navigate and I rely entirely upon custom menus for navigation. What's the solution?
  10. I have a table which has too many fields which contains various aspects of the product. Since the database is hosted in filemaker server and accessed via internet, I think it will cause unnecessary load since I think the whole record is downloaded even if I need just a couple of fileds in certain layout. I think it will be better to split the tables into multiple tables with relevant data. This will cause one to one relationship. Is it good or bad? If it's good to do that then is there anyway I can automatically create record in other related table whenever the record is added in the original table?
  11. That's a good solution I think. Thank you.
  12. So any suggestion that user is presented with such months option but the data is stored as date?
  13. Thanks for suggestion. Regarding value list, I want to populate it from Jan 2016 to current month. Any suggestion for that?
  14. I need to enter monthly data like: end of the month inventory value etc... I have many datas which needs to be entered once a month only and I used to enter those datas as Dec 2016, Jan 2017 etc...