Populate Attribute Table Based on Select_one Response

Question

I would like certain fields in the attribute table to populate based on a select_one response. For example, the user must chose Mooring, Vessel, Mooring & Vessel or Non-TBMP. Based on this answer, certain fields will show up on the form. For example, if the user chooses Vessel, the next set of questions relate to the vessel; however, if the user chooses Mooring, the next set of questions will relate to the mooring. This all works great on the form!

However, I'm stuck on populating the output table. I would like the fields in the attribute table to be populated with "Not Applicable" when Vessel is chosen and the fields are related to Buoy/Lease Visibility. I would like the same to happen when Mooring is chosen and the fields are related to the vessel. See image below. Is it possible to automatically populate fields with NA?

STezak · Answer

Great! Thank you, kindly.

JamesTedrick · Answer

Hi Sage,

It is possible to construct this, to it makes the form a little more complicated.  You would do this by slightly separating the question the user sees from the answer supplied.  Create a calculate question to submit the value to the database and have it use the coalesce function to provide the NA default value if the question:
coalesce(${q}, 'NA').  Take a look at the sample attached.

na_example.xlsx