How to date entry with additional condition

#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

#2

Hi @shiv

  1. create Custom List with your status codes, named status
  2. create hidden date field for each random date you want to generate, named __date_gen
  3. 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