Jump to content

William Graves

Members
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About William Graves

  • Rank
    novice
  1. William Graves

    Searching with scriptmaker and a checkbox

    Removing that "restore" thing worked Queue, *smacks forehead. It works fine now. I miss SQL, lol :-) Thanks again all!
  2. William Graves

    Searching with scriptmaker and a checkbox

    The date function works fine for me, it's just the checkbox :- Thanks for all the help guys :-)
  3. William Graves

    Searching with scriptmaker and a checkbox

    When I use ANY of the Insert or Set functions with either = or "=" I get a result back saying that "No valid criteria in this request..." My Exact Script looks like this: Enter Find Mode [] Set Field ["CheckboxField", ""=""] Perform Find [Restore, Replace Found Set] I also tried: Enter Find Mode [] Insert Text ["CheckboxField", "="] Perform Find [Restore, Replace Found Set] The latter returns every record, checked or not. The checkbox field is a text type, and entering the = works in the regular find mode... Is there a special way of representing
  4. William Graves

    Searching with scriptmaker and a checkbox

    The MyDateField is for the date, not the checkbox. We'll call the checkbox "CheckboxField" So I changed "CheckboxField" to a Text field, and when i enter find mode and put in the equal sign (=) it returns the proper files, but for some reason, it won't work with either insert text[select,"CheckboxField","="] or insert calculatedresult[select, "checkboxfield",""=""]. Thoughts?
  5. William Graves

    Searching with scriptmaker and a checkbox

    Im in Sacramento too :-) small world...
  6. William Graves

    Searching with scriptmaker and a checkbox

    Just tried that, it didn't work either
  7. Hi all, I'm a fm 6 newbie. I have a database with a date and boolean checkbox (the field is specified as a number). I can get filemaker to search on the date ok, but i want to search on boxes that are NOT checked. Basically, the search needs to be for a specific date AND the box is UNchecked. I've tried Null values... The script I'm using looks like this for the date: Enter Find Mode [] Insert Current Date [select, "MyDateField"] Perform Find [replace found set] Now, how do I find the empty checkbox? Should I be using a different search technique in the first place? Thanks a billion! -Will
×

Important Information

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