CDML Vs Pop up menus

[muhajer2k]

Hello everone,

Help!!!

I have been searching the web for help and I found your web site where I discovered that you may be able to help me with the problem I am having with Filemaker.

My query is this:

If you are designing a custom web site that communicate with a database over the web using CDML tags, how would you display a pop up (drop down) menu to display value lists that are derived from a relationship ?

I know that in order to display a pop up menu to display value list you could use the following tag:

<select name="cs_Operation">

<OPTION VALUE="" SELECTED>- Select Operation -

[FMP-option: cs_Operation, list=Operation]

</select>

Where cs_Operation is the field name and Operation is the Value List name. Operation is also a relationship between two database files: K_Coachv1.fp5 and Teamv1.fp5.

cs_Operation is a field name in K_Coachv1.fp5

What I am trying to do is:

1- Display a pop up menu with all the operations available. I have used the tag above and it is working fine. Then the user adds this operation to the new record. Then

2- Display a pop menu with all the teams associated with the operation selected earlier. In order to this I used the following tag which does not seem to be working:

<select name="cs_Team">

<OPTION VALUE="" SELECTED>- Select Team -

[FMP-option: cs_Team, list=Team]

</select>

Where "cs_Team" is a field name in K_Coachv1.fp5 and "Team" is a Value List Name whose source is from Relationship "Operation".

Please help me as I have searched high and low for the answer.

Kind regards,

Muhajer2k

[dspires]

Make the value list for "Team" a conditional value list based on the desired relationship.

[muhajer2k]

Team is a conditional value list of the relationship Operation. The problem is that cs_Team which is a pop up list uses "Team" as a value list. When I tired to display "cs_Team" on my customer web page using following CDML tags

<select name="cs_Team">

<OPTION VALUE="" SELECTED>- Select Team -

[FMP-option: cs_Team, list= Team_coached]

</select>

It does not work.

Is there a code or CDML tag that I could use to sort this problem out??

[dspires]

If "Team" is the value list then that should be the list called out here:

[FMP-option: cs_Team, list= Team_coached]

In any case though, you will need at least a 2-step record creation and completion process since FMP will have to get the 'Operation' value on creation and the generate the value list in the 2nd web page.

Another option, although much more complicated, is to use javascript to generate the lists.

[muhajer2k]

Thanks for the reply.

My problem is that Team is a dynamic value list. It is a sublist of "Operation" relationship.

I have created a page to connect to the database to create a new record. Then I created a another page as a result page which displays the a drop down list of the operations using the following code:

<select name="cs_Operation">

<OPTION VALUE="" SELECTED>- Select Team -

[FMP-option: cs_Operation, list= Operation]

</select>

This works fine. And these are the "First" 2 steps process.

Then I repeat the same 2 step process to choose the team. I.e. from one page I go "connect" to the same record in the database to select the Team. This is by using the following code:

<select name="cs_Team">

<OPTION VALUE="" SELECTED>- Select Team -

[FMP-option: cs_Team, list= Team]

</select>

Where Team is a sublist "Dynamic list" of a relationship called Operation.

Now, this menu comes up empty all the time and this is driving me mad.

Is there any way or code so that CDML would display this dynamic list on the customer web page. Or is there any other way that this menu will display my team. If so please give me the code :~(

[Keith M. Davie]

"Is there any way or code so that CDML would display this dynamic list on the customer web page. Or is there any other way that this menu will display my team."

If your team has been selected and that selection is all you want to display (not the entire list), then if your field is formatted as text in your -layout="web" and not as a pop-up menu, you will be able to display that text value in your browser solution using the replacement tag [fmp-field: field_name].

Peace

Keith M. Davie

[Vaughan]

Bzzzt.

Conditional value lists don't work through Web Companion over the web.

Ding! Next patient please...

[muhajer2k]

quote:

---

Originally posted by Vaughan:

Bzzzt.

Conditional value lists don't work through Web Companion over the web.

Ding! Next patient please...

---

So Vaughan is there any other way to do this, if so please tell me or send me the code.

Many thanx

[Anatoli]

quote:

---

Originally posted by muhajer2k:

So Vaughan is there any other way to do this, if so please tell me or send me the code.

Many thanx

---

I am not exactly in the picture, what is Conditional Value list? So far all my value lists are OK on web.

[Vaughan]

IN FMP5 you can create a value list based on a relationship. These work very well in FMP on clients, but for some reason (a bug perhaps) when the value list is used in a custom html formal file, it comes up empty all the time (ie it doesn't work).

I haven't done a lot with conditional value lists, but over the past few months there has been a lot of posts about the issue, usually from people asking why they don't work over the web.

I have no work-around. Sorry.

[Keith M. Davie]

Ok, let's see if I've got this straight. You have a database which has pop-up lists which are relational between two databases. You now desire to create a browser solution to display and interact with that existing database.

If this isn't the case, you don't need to read any further.

You are the developer. You make a database layout "browser" exclusively for your browser solution. Now you have this relational pop-up list "team" for team selection in some other layout your db solution that people have been using. Ok, so in your layout "browser" you place this field "team" and you display it as a standard field, not a pop-up menu. Guess what, it will display the team selected from the pop-up menu as text. So you direct your browser solution to this text field in -lay="browser" and treat it as you would any text field to display, create a new record, edit, etc.

If there is a still a problem then you make a calculation field to re-format the field "team" for browser display.

I hope you find this approach useful.

Peace

Keith M. Davie

[Anatoli]

quote:

---

Originally posted by Vaughan:

IN FMP5 you can create a value list based on a relationship. These work very well in FMP on clients, but for some reason (a bug perhaps) when the value list is used in a custom html formal file, it comes up empty all the time (ie it doesn't work).

I have no work-around. Sorry.

---

Mine are working OK. Maybe I am using different technique...?

[muhajer2k]

quote:

---

Originally posted by Anatoli:

Mine are working OK. Maybe I am using different technique...?

---

So Anatoli could you tell me what technique are you using please?

[Anatoli]

quote:

---

Originally posted by muhajer2k:

So Anatoli could you tell me what technique are you using please?

---

I wish I knew.

Everything what I am doing is to using relations up to a full potential I know.

If you will go slowly on me with step by step request from 1 to 10, maybe I can help.

If somebody presents the whole non-working stuff (db, HTML and CDML) I do not have the time to analyze that; my family will die from hunger.

You know, the cost of labor here are so low and everything so expensive, so I must work at least 12 hours a day to generate enough income for family of 3 :-(

[Vaughan]

Anatoli

Here in Sydney Australia *both* me and my wife work to feed the family. Can't afford to have mum (or dad) stay at home with the kids. And we both earn good money...

[yafreax]

GRRRR. . . before i extend my frustrations, i wanted to post this link for anyone that cares. It deals with conditional value lists through javascript. BUT, it, of course, doesn't involve Filemaker. However, you may be able to implement it if you know javascript or if you know how to pass cookies. (Set the cookie to the selected option, then have the field(s) equal to the fields???)

http://htmlgoodies.earthweb.com/tutors/ifthis.html

enjoy

now. . . here in america, people seem to think that both moms and pops must work in order to support a family unless one or the other is just making gosh darn good money. I am proof that this just isn't true. At 19, i MAY be the youngest developer subscribed to this site, and i'm probably the lowest paid. After all, i'm still "In Training" (ya, well, i bet if i threatened to leave they'd start showing some dough). Anyway, on my support alone, which is very little, my family of three pays our own bills, lives away from our parents and takes care of all the family needs with some (very little) left over to either save or squander. This isn't done by my high salary; it's done by cost effective living and being content with what we can afford until we can afford more. Don't tell me it can't be done. Don't tell me that two income families are a must. What kind of house do you own (or live in)? What kind of car do you drive? How many corners do you cut a week? (i'm not actually asking, they're only points to be made). In some cases it is NECESSARY for a two income family. Before i got this job we needed to incomes, instead we moved in with my parents and mooched until i could get this job. So if i'm wrong here, forgive me.

Well, anyway, to step off my soap box i say this:

Anatoli, i don't doubt in my mind that you need to work 12 hours a day, and i praise you for it. I pray things get better for your job situation.

Vaughan. . . I don't doubt in my mind that both of you are working to give the family the best possible living conditions and to meet the needs AND desires of the family. I praise you for that. But don't tell me it's a must. Send Money. . .

anyway, no hard feelings, just a pet peeve of mine, so i had to unload.

jeremy

[Anatoli]

Good salary here is 15k, approx. $400 a month. I am paying for small flat in which only the poorest US family will like to live $300 a month. Talking about relations.

Petrol costs twice as much, than in CA etc...

[gin]

Hello,

Beneath you will find the code I use to display in a scroll list the content of a Value List.

<form action="FMPro" method="POST">

<input type="hidden" name="-DB" value="Categories.fp5">

<input type="hidden" name="-Format" value="valuelist.html">

<select size=1 name="Category">

<OPTION VALUE="[FMP-VALUELIST: Category, LIST=Categories] [FMP-VALUELISTITEM][/FMP-VALUELIST]">[FMP-VALUELIST: Category, LIST=Categorylist] <option value="[FMP-ValueListItem]" >[FMP-VALUELISTITEM][/FMP-VALUELIST]

</SELECT>

This scroll list display the content of my Value List "Categorylist". I use two tables. Table1 contains a field with the name "Category" and this field is linked to Table2 (=categorylist.fp5). Doing this way, I'm able to update easily online the content of my scrolling list by adding new categories in the categorylist.fp5 table.

I hope this helps.

B.

[gin]

Oups, there is a little mistake in my previous post :

I forgot to replace some names (= categories)to make it more comprehensive.

You have to replace "categories" by "categorylist".

B.