nexgen

Members
  • Content count

    31
  • Joined

  • Last visited

Community Reputation

0 Neutral

About nexgen

  • Rank
    member

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
  1. Currently, the value list setup as first field as product's id and second field as product name. If the user selects all, then I'll have "All" as product id.
  2. I have my filemaker solution hosting in a filemaker server. I want to use a php script to fetch some data from my database and then create some records. How can I connect a php file with the filemaker solution hosted in filemaker server?
  3. How will the product id will be filled when user selects a product that way?
  4. I have created a value list based on Products table. However, while selecting products, sometime I need to select all products. While showing product name in popup menu, I want to show one more value called "All" for denoting that it applies to all products. How can I do that?
  5. Any example for this? Btw, the autocomplete method will only work for filtering the values which matches from the beginning. I want to match the typed string match anywhere in the value.
  6. Couldn't find much help regarding what I want to accomplish in that page.
  7. How can I make the dropdown field narrow down the displayed list as I type? The solution you suggested is just a simple drop down field with a value list. Regarding _kf_products_id I mistakenly typed that way. I have corrected it.
  8. I have a table called PRODUCTS and it has two fields: _kp_products_id product_name In product_name field it has following values in separate records: iPhone Screen Protector Samsung Screen Protector iPhone Charger Selfie Stick In a layout I want to show the product_name in a drop down field and when the user choose any of the value it should assign _kp_products_id of that product. If I type: "Char" in the field then it should filter down the dropdown with these values: iPhone Charger If I type: "iPho" in the field then it should filter down the dropdown with these values: iPhone Screen Protector iPhone Charger How can I accomplish this?
  9. I'm currently using filemaker pro 14 connected to filemaker 14 server. I don't want to upgrade to filemaker 15 because of it's new license policy. Is it possible to get filemaker pro 14's license? I checked filemaker's website and it seems I can buy filemaker 15 license only.
  10. 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.
  11. 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.
  12. 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?
  13. Thank you for the info.
  14. 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.
  15. Can you please elaborate more on right 'summary' buckets? The only way I know to create the summary is by defining sub-summary part.