FileMaker Forum

2answers

Compare Lists Boolean?

I have the result in a return separated list (it came from ExecuteSQL) something like this:

DOC000000095

LNK000000080

LNK000000081

I also have another list

DOC000000081

DOC000000088

DOC000000089

DOC000000090

DOC000000091

DOC000000093

DOC000000094

DOC000000095

DOC000000096

What is a way FileMaker can say if any of the values in List 1 exit List 2 evaluate as true? I was trying to use FilterValues ( ) Inside of PatternCount () but it went sour and I forgot the whole plan.

Chris Johnston

1answers

Variable in ExecuteSQL?

Is it possible via ExecuteSQL to use a variable like this?

Let (

@sort = INFORMATION::exsqlsort

ExecuteSQL ( " SELECT \"name\" FROM \"TOPICLIST\"

WHERE \"_fk_infoparent_id\" = ?
ORDER BY \"name\" @sort" ;

"";

"";

INFORMATION::_kp_information_id

)

)

Then I would go to a field named INFORMATION::exsqlsort setup as radio button with the choices ASC and DESC.

Chris Johnston

2answers

Wrap lines of list

If you have a return separated list how could you wrap each line like this?

Cat

Elephant

Woodpecker

Dog

Mongoose

To this

<wrap>Cat</wrap>

<wrap>Elephant</wrap>

<wrap>Woodpecker</wrap>

<wrap>Dog</wrap>

<wrap>Mongoose</wrap>

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

Wildcard like syntax

In FileMaker how can you say:

Case (Left(someField; 3) = "cat"; "Feline";

(Left(someField; 3) = "dog"; "Canine";

(Left(someField; 3) = "(?any other combination of 3 digits)"; "Unclasified";

)

I am trying to understand how you state "any other 3 digits and things like that in a Case statement. I know here you can just put a default vale at the end here, but I would like to know the equivalent of Willcards like "*" on Windows search?

Chris Johnston

1answers

Breadcrumbs & Dropdowns

I am new to FileMaker and I am loving every moment of it. It is so powerful. I have took some training (online) and have been reading on best practices and other related topics. My solutions for my business are coming along, but I am stuck on some areas. I have constructed a database that will collect information for my business. This information will have Topic and Subtopics. It was suggested to me that I try a setup like this.

INFORMATION and INFORMATION_Topic are both Tabel Occurrences with the same data source table. TOPICLIST is a join table that allows the Many to Many relationship. This was a stretch for me to understand at first but once I played with it a bit it made very good sense. I fully understand now and have been able to get it all working well. I learned a lot and I am pleased.

The problem I am having now is that I need a way to offer a breadcrumb like system to know where you are at as it relates to information, and having a way to navigate the levels of Topic or Subtopic you are in. I need to be able to go up or down a level, and make dropdown list of all available at current level.

I have learned about global fields and I am finding a lot of reading on how to use them with a Table. This Table that is described seems to be populated from existing content as a utility Table. I am lost in this area and don’t know where to start. How do you populate a table with existing data? I have used a global for filtering via a Table Occurrence, but it seems to be different with this type of setup which I am new to. Should a global work the same way here to create a way to populate the related children of particular parents in to something like a dropdown. I was able to get a lot out of ExecuteSQL, I have a good amount of experience with PHP and SQL related concepts. With ExecuteSQL I could see ways to deduce who is a child of a particular parent and so on. However I want to learn more of the FileMaker Table Occurrence or before ExecuteSQL ways, because that is not my strong point. I think learning it will give me a greater understanding of FileMaker.

So to be clear I need help understanding:

  • How to create a utility Table that can help with a breadcrumb system, dropdown lists, and listing over all.
  • How to populate this table with the correct existing data to make it useful.
  • How to use a global field and Table Occurrences with this type of Many to Many setup to help with the process.

I have included a Mimic file much less complex then my database but it show this setup exactly like mine and can created Topic or Subtopics for as many levels of information as you choose. I hope someone else like me who does not have the knowledge of this type of set up find their way to it. I had learned some of FileMaker’s concepts but this was a great one to learn.

mimicdb.fmp12

Chris Johnston

2answers

Go to Object( "ObjectName" ) Gotcha for New Players

Let me explain. I have an abstracted record deletion script. By that I mean I want it to be able to go to any layout and find a name field an use it to find a record for deletion. This means it can be used to delete records on layouts with different tables. It goes like this;

Go to Layout( "SomeLayout" )

Go to Object( "PrimaryID" )

Enter Find Mode

Set Field ( $PrimaryID )

Perform Find

If found count is 1

Delete Record

End If

This script fails if the found count is 0 to start with. It's not a problem if you do a Show All Records first but it is a gotcha for new players.

The problem is that when the object is a field it seems that as far as FileMaker is concerned the object does not exist unless there is a record. You can have other objects on the layout with a 0 found count and the Go to Object() function will work for them.

So my question is "Is it a bug or a feature?"

Simon Plint

1answers

Play video in filemaker go

i want to play video / audio in filemaker go without going to a new window. is it possible? if so, How?

alistair campbell

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

1answers

Can anyone help me with portal highlighting?

So I have a portal on a layout that's displaying related note records. What I want to do is highlight the selected portal record. Any easy ways to accomplish that? Thanks!

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