I need assistant on how to set a Button that when clicked will go to a empty row in a table.
LOOK GREAT! I'm going to expand it for the other category that I need to look at.
Will keep you informed.
Thanks for sticking with this.
Also thanks to other members who helped.
are you talking about a portal ? Can you explain what you wish to do ?
Thanks. I'm not using a "Portal".
What I would like to do is when I'm done with search's in a Table is to "Click" a button that will take me to a Blank row or record. So that I can have a fresh restart. Currently after your done with search's and click "ShowAll" the form will still have data.
Do you mean you want a new record? Or, do you want to perform another find?
Then you need to call New Record/Request. It’s the same as Add New Record from the menu or button.
Jaymo, Thanks. I'm not wanting to add a "New" Record. I want have my form empty so that I can start a new find.
planteg, thanks I'll give that a try and let you and Jaymo know.
Then try Enter Find Mode.
Enter find mode again using the Command-F or Ctrl-F or the Find button in the toolbar or the Find choice under the view menu. New finds will search on all records so there's no need to show all records.
Thanks for your reply. It was helpful.
But, my goal to to be able to find a "Product" using a "Find" method. I can do this using the "Dwindling value" method and Phils "Adventure" method. Both method's would require a more complex "Relationship". I will have about 10 different selections to make. I'm currently looking 3 of my selections. "Length", "Width" and "Depth". I have 1 table in my file.
What I would like to happen is if I search for "Length" the Related values "Width", and "Depth" would be populated in the dropdowns. If I select "Depth" the the related value for "Length" and "Width" would be populated in their dropdowns.
Here's a copy of my test date.
If you can make suggestion on how to to do this I would be grateful.
Just to let you know I always try to find a solution before I ask for help. As a side note I already have this using "Excel". But, prefer using "Filemaker".
Do you just want to find a record and thus see the data in the fields that make up that record or are you creating a list of selected records such as you might to create a purchase order, sales invoice, Bill of Materials or list of ingredients for a recipe?
Not sure otherwise why you would use a dwindling value list (which drops out each previously selected value from a list.)
What I'm trying to do is emulate the "Find" or "Search" method.
If you do a find for Length 20. The table view will show the all of the data associated with 20. I will the do another find for either Depth or Width and do a constrain find. The end result will be the product that matches the values selected.
I have about 500 products which will make it difficult to scroll and select another Constrained find. So my thought was to make a "New" list for each category of the associated find.
So for this example for 20 you can see that it has 18,23 for width and 12, 9 for width. I would like to have these value in a dropdown for selections. It just like filtering in "Excel".
I thought this looked familiar...cross post from other forum
Sorry about the cross post. Will kept this in mind and not do it in the future.
There's nothing wrong with posting the same question in both forums.
We've also discussed this before here.
See if this works.
BTW, this is not a "Dwindling value list" as I demoed in the adventure file. That doesn't seem to fit what you want to do. These are just hierarchical value lists. I used the simplest version, but the "Show all" button will work with all versions of an HVL.
Nothing wrong with posting on multiple forums. I just put that out there so people can take a look and see what was discussed and tried, saving people time, and reducing the number of questions that may want to ask the OP.
Absolutely! It's "ok" to post on multiple forums. Netiquette says it's polite to state that it's x-posted, & provide links should others wish to follow and not duplicate efforts! But perhaps it's no longer necessary to have netiquette?
Thanks for the reply. This is basically what I'm trying to achieve. However it uses a relation graph. So It limits my option for selections (Left to Right) and too from previous post it was mentioned that a more complex relation need to be created to accomplish the selection of any category.
I'm wanting to be able to select any category be it "Depth", Width" and the dropdowns for the remaining category's will show only the related value to the selection. As in my example above.
Your post asked about how to "return to a blank row", not about how to implement hierarchical conditional value lists. I put those in as they were the closest thing to a "dwindling value list" that I could think of. Since it didn't seem to be the center of your question, I kept that part simple to demonstrate the "Show All" button. As I have noted, any of the more sophisticated HVL examples from the file can be also used.
To me, this does fit your example.
Are you saying that you want to select from the value lists in any order and see the other value lists filter to show only those possible for the values selected in the other fields?
This is possible, but it's definitely a more complex process.
Yes, but using the find method. Not relationship.
My script in that file performs a find. The relationships are only used to control what values appear in the value lists.
Ironically, the attached file does what you specify, but does not perform any finds. It uses go to related records to manipulate the found set. And the value lists all list all values that are present in the current value list. found set.
Please note that this is a proof of concept demo. I've made no effort to lock down all the ways you might manipulate what records are in the found set manually. Thus, in this file, you can find ways to change what records are in the found set and the value lists won't always update to match. If you stick to the value lists and the button, however, the VL's stay in sync with the data in your found set.
See if this produces the behavior that you want and if so feel free to ask questions.
This may be the first time that I set up CVL's that are based on the current layout's found set....
Keep in mind the UI “holes” that I left unplugged.
In the demo, any user action that chamges the found set without using the value lists or the show all button will not cause a corresponding update of those value lists. (Performing a find, omitting records, the “show” options in the record menu...)
When implementing this technique in a working solution, you’d need to find a way to perform the update lists script after each such change. Script triggers and custom menus are two useful options that can be employed to do that.
"UI" is user interface. But"holes" left unplugged. I'm not sure what you mean by that.
“holes” refers to the issues described in the following paragraph that document how the value lists can get out of sync with the current found set.
I was working on several Excel project and now have time to work on this little project.
Phil, I looked at your example and thought all that I need to do is just add another "Global" for another
field to search on. I emulated your script and formate for my next category "Bens". But, this did not work. However, the script works for the first three selections.
It’s been so long that I had to reread from the start to figure out where we got to here.
“Adding another global” sounds a bit too simple but you really haven’t told me enough about that and exactly how it “doesn’t work” to be able to offer much help.
Feel free to share more info.
Thanks for the reply.
I added "Ben" to my layout. When I make a Value selection for "Length" the related values are displayed. I click the "Show All" so that the layout refresh and displays all of the products. Now, when I select a value in "Ben" it does not show the related values as did the selections of "Length". I put a dialog box in the find script to check the value selected. The Value for length was displayed. But, when I select "Bens" it does not show the value selected.
Did you set up the script trigger? What list of script parameters did you specify?
I set up the script trigger. I set up the List Value for Bin.
I have the graph for TestDada "gBin" to Filtered "Bin" (per your demo).
I set the script trigger for on Modify and call up the "FindRecords" script that you already had in your demo.
Looking at the table for "TestData" the field for "Bin" shows the data. No mater which value I select for "Bin" the related values do no display.
However, when I select values for "Length" the related values are displayed.
Here is what I have.
I ered about the values I set for in the "show dialog". I had it looking for "gbin" should have set to look for "gbinvl".
It does show the selected value. But, it seem that the "Comit Record Request" did not work.
Tested my file. I used the "Show Dialog[ "Test for Value"; $Matchfield & "_" & $Value]
If I selected "Length" and the value of "20" the dialog showed my selection. However when I select "Bin" and the value of "4" the dialog only shows "_".
I'm at a complete loss. I did some searches for answers but could not find out why.
Please share a copy of the file. Sorry for not responding sooner. I've been up to my eye balls in "gators" as my employer manages schools and it's the first of the school year crush here. I've had to skip a few requests that I judged might require more than a few minutes to answer.
I thought might be busy. I do appreciated your help.
This is what I was testing.
The Show Dialog will display any selection other than the selection for "Bin".
When I look at the script trigger for one of my pop up menus, I see:
When I check the trigger on your added field, I find:
The images you sent I never seen it before. Is this something in your version of filemaker?
How did you get the "Specify Script"?
I have version 12.
Also you have a script that has a "Let" function. In you demo the setup for the database and also the "FindRecords" do not have it.
It's always important to tell folks when you are using an older version. It saves folds from going to the trouble of suggesting something that won't work in the older version.
But it's there in 12 as well.
Right click the field
Select "Script triggers"
Select the OnObjectModify Trigger
You'll get a "specify" button for selecting a script to perform from that trigger. It's where you can specify both the script and the parameters that need to be passed to the script performed by the trigger.
Thanks for the help. I can see what you did. Currently the "Bin" works as you indicated with the "Script" for "List".
I learned something new.
I'm going to consider this part done. Thanks to you I'm very grateful.
Hope you can answer this. In my real file I used the useful info that you provided. I created the Database as per your example and the "Relation Graph".
Setting list view for "Length" When I go to my layout and select "Length" it display's No Value Defined.
I compared setting for both files your sample file and my actual file. All of the settings are the same.
But, it fails.
Can you shed some light on this?
Clearly there is a difference, but I can’t tell what that is from your post.
You'll need to share screen shots of your relationships and value list set up dialogs. Also check for indexing.
All I can tell for sure from that error message is that no values are available for your value list.
Here's the screen shots. I hope this is what you wanted t see.
Not sure if my problem is because I'm using existing data. And not new entries.
The problem was I needed to delete the existing record and re-Import the data.
You left out the most important dialog, the one where you pick the fields for your value list and select other options.
I hope this is the dialog that you wanted to see.
PS: It looks like the Gators won the game on Saturday.
Also I use to live in "Cape Coral"
Never mind I found my problem. It was with the Script for "UpdateList".
Dummy me I forgot to set it.
Thanks ever so much for your time!
Glad you have it figured out, but no, that wasn’t the dialog.
I came up with a different issue.
In the test files every thing works as designed. But, I'm trying to use the same procedure in my actual database.
When I select the field for "Length" the values are displayed. However, the "Find Records" does not seem to work. I'm attaching images to show you what I have so far.
I'm only doing this for "Length". I'll add the rest of the code when I can get this issue solved.
Line 6 of Find Records has an error. Note the “unknown” in it.
I’m just using my phone to check. Comparing these to my demo might reveal other issues, but fix that one and see if it helps.
Thanks. That was the problem. I just did not see. I copied the code and did not noticed it. I should have rewritten the code instead of copy.
Copy/pasting script steps can save you a lot of time and avoid errors, but you do have to look over the pasted lines of script for any such disconnects and other errors to get it all up an running.
Retrieving data ...