Autofill in forms -need help with allowing autofill fields to be edited by user if they don't fill

[Shirlene_Clark]

Hi 

I have an app form

When people enter their NADACRegNum into the first field in the form the app auto fills some other fields in the form from another table called dog id.  My issue is if the NADACRegNum is not listed in the Dog_Id table I want the fields to allow the person to enter in their data into the form themselves and then update the Dog_Id table  once they submit their completed form.

So far i have the following expression working giving me the autofill and it is working well.

lookup([_thisrow].[NADACRegNum],"Dog_ID","NADACRegNum","DogCallName")

However, if they are not in the Dog_Id table the form isn't allowing these fields be visible to the user and therefore not allowing them to inout into the fields.  Because they are not inputting these fields there submissions are coming through blank in these fields. 

Can anyone give me some steps to fix this?

Many thanks

Shirlene

[dbaum]

For the columns you want to autofill when data is available, it sounds like you have probably put your expression in the App formula property. Try instead:

• Move the expression to the Initial value property
• Enter an expression in the Editable property that allows editing only if the NADACRegNum entered is NOT IN the other table.

[Shirlene_Clark]

Thank you dbaum.

Moving the expression to the initial value property has solved half my problem.  The fields are now visible.

ok i can see where to put the next expression into the editable property so that if the NADACRegNum is not in the Dog_ID table.  I just am not sure how to write the expression.

So I want the expression to allow the field in table to be editable if the NADACRegNum cannot be found in the Dog_Id table

Can you provide me with an example expression?

Many thanks in advance.

[dbaum]

NOT(IN([_THIS], Dog_ID[NADACRegNum]))

[Shirlene_Clark]

thanks dbaum ...I haven't got it to work yet but will keep trying

[Steve]

Set Reset on edit? to this expression:

ISBLANK([_THIS])