AnsweredAssumed Answered

Field Not Empty Based On Criteria

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


Field Not Empty Based On Criteria


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