CODEWITHSUNDEEP
webformsconstraintsdata-collectionkobotoolboxxlsform
Harvester
Harvester

Reputation: 7

XLSForms PULL Data

please I need a help in an issue where I want the pull data function not to run when a specific field has an answer

the image describes exactly what I have

for example in the image above , no need to pull data when the field "Mohafaza" already have an answer , it is pulling data and overwrite my edits if I save the form as draft and re-open it

thank you

Upvotes: 0

Views: 222

Answers (1)

Luise
Luise

Reputation: 654

Modify the code in your calculation column for row Mohafaza from:

${Mohafazacheck}

to:

if(${Mohafaza}='', ${Mohafazacheck}, ${Mohafaza})

Every time you re-open the form, it will only replace Mohafaza if the question doesn't have an answer already.

Upvotes: 0

Related Questions