Jump to content

rekent

Members
  • Content count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About rekent

  • Rank
    member

Recent Profile Visitors

665 profile views
  1. Ok, that fixes the functionality that I was going for here. It looks like I at least had the right basic idea in incrementing my buttons for each repetition, but my implementation was off because I hadn't thought to set it as a variable. It also emphasizes an area that I need to work on because it touches on the aspect of Filemaker that I was always weakest on: Relationships and when/how to use them. Now all that is left is a strange bug that I am trying to track down. When zSort Selection is one value, the layout updates properly based on the Switch Type script, but when zSort Selection is a different value, the layout does not update properly. I've gone through the scripts looking for any use of zSort Selection that could be altering the results, but haven't found one, so it looks like it will just require more hunting and experimenting.
  2. I plan to keep trying to improve it to function like I am hoping, but ultimately it is merely a hobby database that several people I know have asked me to share with them because they like the idea and that I will continue to use to get back into Filemaker and relearn more of it. Which is to say, probably not worth any more of your time since it is not a serious thing.
  3. Quite frankly, it was initially for the sake of simplicity. I began with one of the starter solutions because this was just a little project for personal use and I didn't want to mess with the visual layout too much, But, as I tested it out I began changing a significant amount and adding functionality, it has ballooned into something that probably is not well suited to have a starter solution as its base.
  4. Thanks again. That makes sense and fixed it, but I found a new problem as a result. No matter which record I choose (e.g., New Content [2] through [5] in the attached), only the first record is changed (when using the "Toggle Type" script). It looks like I may have to rethink this entire functionality, unless there is a modification to the code that will take the values of the particular repetition being clicked on into account. I know that I can user Get(ActiveRepetitionNumber) to determine which repetition I am clicking on, but when I try to integrate that into the script (using the "Switch Type" script) then the status change functionality no longer works (it looks like the Get function is always returning zero). Production Demo.fmp12
  5. A follow-up question, BruceR. My file has two views: a thumbnail view, and the individual record view where the buttons previous described are located. I wanted to include a single additional button on the thumbnail page that toggled between the two values, regardless of what they are. In the attached Function Demo, when you click the toggle, the button works properly and as expected, and the status immediately changes. In the attached Production Demo, which is made from the actual file I am working in, you have to click the button and then click anywhere else in the layout other than on the button before the status will change. The script coding is the same for both. In the Production Demo, the button is located on the Thumbnails page underneath the words "New Content". Production Demo.fmp12 Function Demo.fmp12
  6. Much better, and much appreciated! It has been years since I have touched Filemaker and I knew that I was missing something - I was trying to both select the field and set the value from the calculate step rather than two separate ones. Thanks for the assist!
  7. Attached is a basic demo file. Essentially I want the large buttons on the right to function like the radio boxes on the left (in essence giving me supersize radio boxes). However, the SetField script is not changing the field value to the text strings that I specify. Demo.fmp12
  8. I have a layout that is being designed for use on an iPad, and have a value list for a record type. For a desktop implementation, I would use radio boxes to choose the value. However, they are too small for what I need for the iPad. I would like to create a button that acts like a radio box, most likely based on scripting, however my attempts at doing so with SetField have not worked. Is what I am attempting to do possible, and if so, any pointers on correct programming for these buttons?
  9. I have a database that accepts first and last name entries for a primary person and a secondary person. However, there is a problem that sometimes the secondary person comes back looking to be entered as a separate primary person, which is not permitted. However, I do not have any data validation or verification to prevent this. When a new record is created, would I be able to use SQL to check the first and last name combinations entered for the primary and the secondary persons against the names previously entered in the database and create a dismissible dialog popup giving a warning when duplicate names are entered? Ideally the dialog box would also give a link to go to the record where the duplicate name was previously entered to verify that the individual is the same.
  10. I am a bit new to this, so perhaps I am going about it the wrong way. I increased the repetitions to a rather large number because at 1 repetition it did not calculate correctly, but at many repetitions it does. I have a multiple records, each representing a single person. Within each record the is a portal that contains fields to record various forms of aid such as gas, utilities, etc., and a source of the aid. I want to determine a sum across all the records of a specific type of aid for a given source in the past 365 days and then place all the results on a single sheet that can be presented to show all activity over the past year. Is there a simpler and/or better way to go about this? If it matters, I am also wanting to chart the results (for example, a pie chart listing gas, utilities, and then a single field combining anything that is not gas or utilities).
  11. I have a field that has a Calculation type, with the result being an un-stored number. Â It has a field for the number of repetitions for the calculation to perform. Â I have attached a picture so you can see it more clearly than my terrible explanation. Â Â
  12. The above SQL is determining the values I need perfectly, but I noticed a potential issue. The code is used as the calculation for a calculation field, but I am required to specify a number of iterations. Is there a way to avoid that so the calculation simply computes for all records? I realize I could set it for an extremely high number of iterations, but my assumption is that would result in poor performance and sluggish response. On the other side, if the number of iterations is set too low and the number of records in the database exceeds that number, I will no longer have an accurate result.
  13. Perfect, thanks! I had a feeling it was me doing/missing something stupid... The table name repeat is because some of the fields in the table, for example church name, can occur in another table and have different values. At the time this was made, that seemed the easiest way of differentiating between them and keeping everything straight. In retrospect, it could have been done better.
  14. I have a field in a portal named "Assistance | Amount" in a table named "Assistance" that I want to summarize when "Assistance | Church" is "fbcec" and the entries are during a specified date range. I have a count of the occurrences of such a record using the COUNT(*) function, but when I modify the code to give me a sum of the dollar amounts, the field populates with a question mark. Granted, I am not extremely proficient with SQL, but I have looked over this a few times and compared it to the working code I have and the proper syntax for SUM() and I am not sure where my error is. Does anyone more familiar with SQL possibly see where I messed up? Let ( [ ~cd = Get ( CurrentDate ) ; ~sd = Date ( Month ( ~cd ) ; Day ( ~cd ) ; Year ( ~cd ) - 1 ) ; ~sql = " SELECT SUM (Assistance | Amount) FROM Assistance WHERE ( "Assistance | Type" = ? ) AND ( "Assistance | Church" = ? ) AND "Assistance | Date" BETWEEN ? AND ? " ; ~cost = ExecuteSQL ( ~sql ; "" ; "" ; "Gas" ; "fbcec" ; ~sd ; ~cd ) ] ; ~cost )
  15. I have the following function that is operating correctly (returning true when more than 1 "Gas" or "Utilities" entries exists. If( (ValueCount( FilterValues( List( Assistance::Assistance Type); "Gas")) + ValueCount( FilterValues( List( Assistance::Assistance Type); "Utilities"))) > 1; 1) I want to add another limitation, but I am not sure how to and am hoping for help. I only want the above function to return true if the "Gas" and "Utilities" criteria that it is finding appear more than once within the past 365 days - currently it returns true if the criteria appear more than once ever. The date of each Assistance Type is stored in Assistance::Assistance Date. These fields, Assistance Type and Assistance Date are fields in a portal, if that is important. In normal words: If more than one entry of the type gas or utilities has been made in the past 365 days, return true. Is there some way to do this by introducing a limitation that uses Get ( CurrentDate ) and (Get ( Current Date) - 365)? Any help would be very greatly appreciated, and I thank you in advance for whatever you are able to do to help me out here.
×

Important Information

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