FileMaker Forum

0answers

Web view that stays the same

Does anybody know of a way, plugin, or anything else that can make what is a web viewer remain even if the site is not live anymore? I know this may be asking a lot because a web viewer’s job is to keep things live and reload the current site. However I did not want to assume no, and miss out on any know solutions for what I want. So that is what I want, a way to keep what is loaded into a web viewer always after it loads the first time. Firefox the browser can do this with the addon Scrapbook. This addon can take something like you view of a bank account, this being a type of view that you have login to see. It can take views like that and make them stay as web pages after you log off. They are not live anymore but you can always see an exact view of what it was. I don’t mind the suggestions of other ways to do this, or something like it. I am sure I am not the first developer that needs this. Thanks

Chris Johnston

0answers

Dropdown readout?

Does anyone have or know about techniques for making a dropdown display the current record you are on or things like a parent record. I have a way I am doing it but I wonder if it is the best way. The way I am accomplishing it is; I just take a field with the deduced result that I want it to display a put it on top of the field that I have set to a self-join. This self-join than has a relationship set up limiting it to the members I want to show up based on the context. What I ultimately want is a set of dropdowns across the top of my solution that show the trail or breadcrumb, and when each one is clicked I can go to that record. The top dropdowns will update accordingly. I have seen a way to make this really nice using FileMaker 13 with the visibility option so that when there is not any more trail only one dropdown will show. I would appreciate any suggestions. Thanks

Chris Johnston

2answers

Popover Lab

I followed instruction in this FileMaker document, but can’t seem to get the Popover to open with the “Go to Object” Script step. All it seems to do is highlight it. So then I put a field in the Popover and gave it an Object Name and it works. I don’t know if this can be a problem but it now highlights the field. I did not want this, I just want of show what is in my Popover and close after. Can anybody shed so light or tell how opening the Popover can be done. Thanks

Chris Johnston

0answers

Keep users in found set?

This is the relationship I have. It really works well I can have unlimited Topics for a piece of Information. Meaning Subtopic for Topics and so on. I have created a couple scripts that can deduce what I am calling the family. What I mean by family is all the members under the Information, every Topic and its Subtopics no matter how deep. So now with this list, could it become something I could receive benefit from storing in another table? My intuition says definitely, but I just want to be sure this is the way to go. I really would like to have a way to keep users in “subject-matter” only the Information and its Topics and Subtopic. Is there a way to keep users locked in a found set only or is this done via Interface design.

Chris Johnston

0answers

Specific Tracking and What Power!

Does anybody know if there are ways to store a Primary Key and a Layout to track the back and forth navigation in your database. I would then want to attach a button to navigate back and forth. Now that I figured out that silly flashing error that I was dealing with, http://grasplearning.com/filemaker-forum/32-freez-window-flash--pop I am fully enjoying the power of Finds via Scripting that make it look like nothing else happened but the production of your desired result. Tell me are there things to know about strain on the system or memory if you do a lot of these? Or can I just do as much of this that make sense (of course within the scope of best practice)?

Chris Johnston

1answers

A Global does the trick

I have been watching some training on FileMaker, and currently the instructor is showing how to build a system that navigates the Layouts in a solution. In the early stage of it, we have only added the back button.

An interesting thing has come up, and I figured I am better off trying to fully understand what is going on rather than just be satisfied I can get it working in my solution.

For the back button we built one Script that get attached to the Layout via a Trigger (it stores a variable that is list of Layout numbers) and one that gets attached to the button (It retrieve the Layout we want to return to and removes it from list).

The instructor then explained why it wouldn't work (seems like it should). He says that the other scripts firing on the Layout will clash with it so it cannot do its job. He goes on to show a procedure that fixes the problem. I present it in the pictures, I think what is going on here is it is he is creating a clause that will say “no matter what, create a situation for this to run” but that is just what I see.

What does this $$Nav global variable (pic) do for you that makes it work (it does work)?

Chris Johnston

2answers

Looping though a list of values

I am looking for an example script that loops through a list of values?? I had found the FileMaker article here: http://help.filemaker.com/app/answers/detail/a_id/2403

I was advised to avoid using the copy and paste script steps. Instead, I should capture the data into a script variable and set the result back to a field via the Set Field script step.

The article shows a way to use a loop to run through the records in a portal, and send the useful data to another field.

While it works, it seems to be inefficient. It's the only script in my solution that displays an hour glass while running.

If the list of values were in a field, how could I loop through them?

I have already determined that I'll need to use the ValueCount function instead of the Count function. I was staring at the screen for 15 minutes wondering why the Count function always returned 1.

I attached an image of the data I am working with.

Also is it possible to produce a found set out of the List? I see now after testing some more that the portal has a way to refer to a "Related Record" it can get there. I guess the way I imagined it could be further automated is missing something (probably cause of lack of knowledge ) the something being a way to get to each record in the appropriate layout and do something. In my case I just want to check a condition (via a checkbox) and if true add them to a join table.

Chris Johnston

1answers

Criteria Validation

We have a need for a user to click on a checkbox for purpose of deeming something Complete. It is an important decision in our solution because once deemed Complete it will set up other options we need to do. We want to be sure this is the correct decision. I would like know about any methods of making an important decisions trigger have to be released with a safety. I was imagining a Script that displays a message that kind of gives a checklist or some things to consider before deeming something Complete. I guess a Script could take a user to a layout and give them just that. a checklist that once all criteria is met (checked) it could continue the Script and allow for the Complete choice to be chosen and If not, it will not allow it. I was thinking there may be other ways so I am inquiring.

Chris Johnston

3answers

Progress Chart

I have a field in my database called progress. This field for now is a checkbox set that has the choices, “Un Started” “In Progress” and “Complete”. Eventually I want an elaborate way to start determining the progress of certain tasks. For now this is a start to understand the way I will construct it. Is there a way to construct a chart that would take (let’s say) 8 tasks and average there progress field and summarize it to show an average bar of where there over all progress is. So I mean on a scale of 0 – 100 with 0 being “Un Started” 50 being “in Progress” and 100 being “Complete”. I also would like to know if you would have to use a script to show the found set of 8 (8 is just a number of tasks or a particular job could be 5, or 11) or is there a way to only chart for related records.

Chris Johnston

1answers

Adjust Window

When I use a button to go to a different layout I am having trouble using the Adjust Window script step to show a correctly sized window for the layout that I am going to. By correct size I mean to change from, say a list sized window, that was the originating layout to a form sized window that is being called. Sometimes it may get the width right, but not the height and vice versa. Is there another script step that I should be using? I am using FM ver 11. Thanks in advance for the help. Rick

Rick Torchia

1answers

Script Triggers Assistance Needed

I am trying to get a script trigger to fire after a record has been modified. Which "Event" should I link it too? Thanks!

Samantha McAlister

2answers

How to run a Script when the FileMaker database opens?

I have created a script that I want to run when the database opens. Is that possible? How?

Samantha McAlister

2answers

Help, my loop isn't working!

For some reason my loop isn't working correctly! Help! When the script runs, the script begins, but not with the first record (in the found set). Then, for some reason, it keeps looping. Why doesn't it stop looping and continue executing the script? Did I forget something?

Shanna Kurpe