Newbee Help

[SpadeFlush]

Just started useing FMP 11 and need some help with:

#1

if field_A has any data entered: set the validation to (Not empty) for field_B, field_C, and field_D.

#2

field_A fails validation: if field_B has any data entered.

#3

If field_A has any data entered: use layout_1 - If field_A and field_B both have data entered: use layout_2 - If field_A and field_B and field_C all have data entered: use layout_3: than open the layout (1,2, or 3) in a new web browser window if web published.

Thank you....

[bcooney]

Posting questions that are so abstract, imho, will not get the best answers. Often, new users feel that a technique is necessary, only to find that after discussion, they might have the data model incorrect.

So, what are the specifics of what you're doing?

[SpadeFlush]

Sorry, To many late nights and not enough Red Bull.

I am trying to-do 3 different things in 3 different places.

The first 1 is to have a field that when any data is entered into it, it runs a script that would change the validation to (not empty) on three other fields. So entering data into Field B,C and D is only mandatory if field contains data.

The second one is to have 2 fields where if any data is entered into either field that’s OK only if the other field is empty.

The 3rd one may not be possible.

I would like to have 3 different layouts for printing. The layout that gets used (viewd in a new window) would be selected by whether data is entered in certain fields. So if Field_a has data in it use layout_1, if field_a and Field_b has data in it use layout_2, and if field_a ,field_b. and field_c have data entered in them use layout_3.

[comment]

1. It's not possible - or necessary - to change validation by script. You can validate fields B, C and D by calculation =

IsEmpty ( A ) or not IsEmpty ( Self )

Uncheck the "Validate only if field has been modified" flag.





2. Validate one or both fields by calculation = 

IsEmpty ( OtherField ) or IsEmpty ( Self )

3. You could use a script triggered OnRecordLoad - but I don't think that will work in IWP. You could make your own navigation buttons, though.

[SpadeFlush]

Thank you so much #1 and #2 work,.

Just what I wanted todo.

Thank you.

#3:

I am finding that IWP has a lot of limitations. Is there a better solution for having the database on the web? Are all the limitations the same if you have the database hosted on a Filemaker server?

[Fitch]

Not only can scripts not be triggered by user actions in IWP, you cannot create new windows in IWP (only "virtual" new windows for use by scripts).

Using FileMaker Server is always the best choice for hosting your files, but for IWP it has the same limitations except it allows more connected users.

[comment]

There is CWP.