shiv
1
Hi,
I need to create custom code for Date entry
e.g
Status = GG,YY,ZZ,XW,HB,TB
entry DATE= (Generate entry dates if status = ZZ, HB)
Expiration DATE= (expiration date if status =ZZ, HB status)
Conditions->
Generate entry date (random) if status = ZZ, HB
Generate expiration date random if status =ZZ, HB status
mp_np
2
Hi @shiv
- create Custom List with your status codes, named status
- create hidden date field for each random date you want to generate, named __date_gen
- set entry date or expiry date as formula and enter the following formula:
case status when *['HB','ZZ'] then __date_gen else '' end
see example at https://www.mockaroo.com/14abaf70