AnsweredAssumed Answered

Field Not Empty Based On Criteria

Question asked by DanielGordon on Apr 22, 2015
Latest reply on Apr 22, 2015 by philmodjunk

Title

Field Not Empty Based On Criteria

Post

I need to ensure that certain fields within a table are not left empty upon completion, some users forget to update these based on the type.

I have 3 main fields that are key;

Type: test 1, test 2, test 3, test 4  

Time Spent:

Date Completed:

I need to find the best way of ensuring that the time spent field is not empty if the date completed field is updated and the type selected is either Test 1 or Test 2.

Test 3 and Test 4 are reported in a different way 

I hope I have explained the above.

Many thanks for your time

Outcomes