I would like to make a number of columns required, however these columns will be 'hide/show' based on the previous answer. That bit i have working fine.
The problem is; this only works when I leave all columns as optional, but I would like to make them all required. When they are hidden I would like them to change to optional. Is this possible? Many thanks.