Solved

How to make fields active / inactive with radio button options ?

Posted on 2004-08-23
8
1,207 Views
Last Modified: 2008-02-01
Scenario is like this , there is layout in that layout I have nine different fields and one radio button with three diffrent options.

When I choose Option 1 then, first three fields( Field 01 , Field 02 , Field 03) should be active and last six fields (Field 04 , Field 05 , Field 06 ,Field 07 , Field 08 , Field 09)  should be inactive (or locked or hidden ).

When I choose Option 2 then, first three fields( Field 01 , Field 02 , Field 03) and last three fields (Field 07 , Field 08 , Field 09) should be inactive (or locked or hidden ). and  middle three fields should be active (Field 04, Field 05, Field 06 ) for data entry.


When I choose Option 3 then, first six fields( Field 01 , Field 02 , Field 03 , Field 04 , Field 05 , Field 06) should be inactive (or locked or hidden ) and last three fields should be active (Field 07, Field 08, Field 09 ) for data entry.

I’m having hard time making script please make me a script.

Thanks
Roger Gill
0
Comment
Question by:gurshaan
  • 3
  • 3
8 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 63 total points
ID: 11878564
Hi,

It is not possible to script-wise hide objects on a layout.
I suggest instead you use many layouts:

Let the radio button look like a radio, but actually be a button. Then let that button take you to various layouts:

When BUTTON 1 - you get a LAYOUT where... " first three fields( Field 01 , Field 02 , Field 03) should be active and last six fields (Field 04 , Field 05 , Field 06 ,Field 07 , Field 08 , Field 09)  should be inactive (or locked or hidden )."

When click on BUTTON 2 - you get to a LAYOUT where... "When I choose Option 2 then, first three fields( Field 01 , Field 02 , Field 03) and last three fields (Field 07 , Field 08 , Field 09) should be inactive (or locked or hidden ). and  middle three fields should be active (Field 04, Field 05, Field 06 ) for data entry."

To switch layouts based on buttons should be quite easy. And NO SCRIPTING...

with a smile
/prifre
0
 
LVL 28

Assisted Solution

by:lesouef
lesouef earned 62 total points
ID: 11886198
other way, (not tested):
define for each field which option value must be true.
ex: in field1 definition: control if option=1. when option <> 1 , FM will issue an error msg if you attempt to chenge field1 value.
less smart that the previous comment, but can be done in a single layout.
0
 
LVL 9

Expert Comment

by:prifre
ID: 11895340
Well, if you want the simple solution in ONE layout, you can use a menu-popup field, where you write out all the alternatives (they are as I understand not so many. That will take far less space and you can have it in one layout and it needs no programming.

Option1, Field 1
Option1, Field 2
Option1, Field 3
Option2, Field 1
Option2, Field 2
Option2, Field 3
Option2, Field 6
Option2, Field 7
Option2, Field 8
Option3, Field...etc.

Quite effective.

With a smile
/prifre

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 28

Expert Comment

by:lesouef
ID: 11900419
true, but may become too much if the amount of conditions grow further later on??.
I think the multi-layout solution, though less smart in theory, is easier to maintain, and that should never be forgotten when you'll have to modify in a 2 years time. Also, layouts can be changed on the fly, while field definitions request you disconnect users, quite a problem in many places.
0
 
LVL 9

Expert Comment

by:prifre
ID: 11902259
No, no no - Field definitions? You should use a value list and the contents of a value list can be based on field contents. In fact a database I was working on it was very practical to have valued lists in a related database - anyone could then define the contents of the popup. Gives new kinds of possibilities - and even better reg. maintainance!

With a smile
/prifre
0
 
LVL 28

Expert Comment

by:lesouef
ID: 11902950
this way, ok. I thought you wanted to list all conditions in that same layout. an external table is of course that right way for long lists.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Taking database online 3 304
Primary 1 74
Filemaker Server 14 Licensing : Concurrent connections at upgrade 4 181
FileMakerPro10 required fields interfering with data entry. 3 62
Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now