0

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

Harvester
  • 7
  • 4

1 Answers1

0

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.

Luise
  • 482
  • 1
  • 6
  • 21