Perform script on change in Drop down

[Guest s_k_123456]

Hi,

 

I have a dropdown list, with some values, and i want to perform action on change in drop down like HTML. like if i select 'Billed' from drop down , i need to dispaly only those who billed the full ammount or i select 'Unbilled' from list , i need to display only those who are nor billed.

 

Please help me.

 

Shiva

[Maarten Witberg]

You need a plugin to trigger scripts based on field values. Try ZippScript or DoScript (I can say ZippScript works fine, I have no experience with DoScript. There may be other plugins that do this.)

 

But I suspect you do not need a script. You can use the billed status as a relationship filter. Selecting the appropriate value you can view the records in a portal.

[Guest s_k_123456]

Hi,

Thanks for reply.

I have less idea about relationship in file maker, could u pls sugg. or provide some reading material on this. it will help me.

 

Shiva

[Maarten Witberg]

Suppose you have two tables:

 

"client" and "invoices"

 

Put a field in client called "BilledStatusSelect"

Put a field in Invoices called "BilledStatus"

 

Now create a relationship between the two tables like this

[b]Clients  ------------------<  Invoices [/b]
ClientID                   =     ClientID
AND                             AND
BilledStatusSelect     =     BilledStatus

Now create a value list for BilledStatusSelect matching the possible status in Invoices. Based upon the selected status value, you will see either set of invoices for a client.