Jump to content

Sinky

Members
  • Content Count

    18
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Sinky

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    19

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified
  1. The filed was on the Form layout. Well, you're right.... I can't recreate the problem but I don't understand how I managed to solve it. 😑
  2. For what is worth, I think I found the source of the problem. Table::Years field was not included in the Table view layout.
  3. You're right....so, the field contains one value which is chosen via drop-down list attached to the list Tnx for trying!
  4. Yes...it's global field. It's called "years" because it's a dropdown list that contains a list of years.
  5. Hi FM people! I have one problem which is probably simple to solve but so far solution eluded me. I have a dropdown text field which offers a list of years (Table::Years). This is global field. I have very simple find script: Enter Find Mode [Pause: Off] Set Field [Table::Order Date; Table::Years] Constrain Found Set [ ] Table::Order Date is a date field. Idea is to perform find according to the value chosen from a dropdown list. However, this does not work. I'm getting "provided find criteria not valid". But, if I enter manually one of the years from the l
  6. Great! Thank you for taking the time to help me and provide some insight. I will look into your instructions and figure the rest out. Respect!
  7. Charting is one of many aspects of FM with which I don't have much experience. What I'm about to say therefore might not sound reasonable. One reason why I would like to avoid charting by the found set is because I'm trying to build a dashboard with several charts and I would like that these charts are independent from the sort or find changes in a table view. Therefore I opted for delimited data. That being said, your calculation works like magic and provides exactly what I had hoped for. Thank you a million times! 🥳🥳🥳
  8. Sure. But I would like to design the charts according to delimited data. So far, the summary list fields and ValueCount ( FilterValues ( MyList ; MyItem ) worked really good. However, now I stumbled on a situation where MyItem is not anymore an item from fixed list of values but an item from the list of values that can be expanded with new values. You probably have a better suggestion. My idea was to look for a way how I can automatically generate a list of sums according to the current state of the value list. Do you think that something like Fast Summaries would be of any use for t
  9. Sure. But I would like to design the charts according to delimited data. So far, the summary list fields and ValueCount ( FilterValues ( MyList ; MyItem ) worked really good. However, now I stumbled on a situation where MyItem is not anymore an item from fixed list of values but an item from the list of values that can be expanded with new values. You probably have a better suggestion. My idea was to look for a way how I can automatically generate a list of sums according to the current state of the value list.
  10. Hi! Thank you for replying so fast! I updated my profile, sorry about that. Yes, you're completely right. The thing is, I was wondering is there another way how to do this by calculation and avoiding the usual procedure. Besides, I would like to have, in the end, the list of sums of each item type so I can use it for charting.
  11. Hi guys! I hope someone can help me with this. I have a SUMMARY LIST field which contains types of items eg. (shoes, shoes, sneakers, boxers, jumpers, boxers, jackets, shoes, sneakers...). These items are also listed in a value list (boxers, jumpers, shoes, jackets, sneakers) Is there a way how I can generate a count list of items by and in order of the value list? Taken the example above, this count list would look like this (2, 1, 3, 1, 2). The commas here should actually be the carriage return. Tnx a lot!
  12. Hi people! I have a field which validation is set to Always, Allow user to override during data entry unchecked, unique value, custom message checked. When validation fails the message box offers two options: revert record and OK. Is there a way to trigger particular script if I choose OK? or is there a way to get the message with only one option (revert record) to choose? Much obliged!
  13. Hi! I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value. When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great! But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working.
  14. You're completely right. I messed something up. Anyway, I used your suggestion and after some trial-and-error moves I found the solution. So thank you!!!!! I'm using both methods because the script I was working on supposed to be a part of the much larger script so I was simply trying out different things.
  15. Hi people! I hope someone can shed some light on the following issue. I made a simple script for button to import the data from .xlsx and update a field. Script works good but I have a problem with the last step. If xlsx contains the data for import, field gets updated and record is not shifted. Fine. However, if the .xlsx has no data to import, FM automatically shifts to the first record. What I would like is that in the latter case record is not shifted or in other words... I press the button, there is no import because there is no new data, current record is not shifted. I tr
×
×
  • Create New...

Important Information

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