add/edit inventory by scanning barcode

[face_crab]

I am trying to follow this thread in order to add/edit items by scanning their barcodes. However when scanning, the app returns “‘Key field ‘Unique Key’ is required’, what could be the issue?”

I’m using the Inventory Management template. I’m a total newb to appsheets but I’ve been struggling with this for many hours now. Please help!

Action formula:

IF (ISNOTBLANK(LOOKUP([_THISROW].[Item ID], “Items”, “Item ID”, “Unique Key”)),

LINKTOROW(LOOKUP([_THISROW].[Item ID], “Items”, “Item ID”, “Unique Key”), “Items_Form”),

LINKTOFORM(“Items_Form”, “Item ID”, [_THISROW].[Item ID])
)

More details:

[Joseph_Seddik]

In the “Unique Key” column’s Initial value field, put this: UNIQUEID()

[face_crab]

Sorry, forgot to add that screenshot, I have already done this.

[CalvinWF]

Did you try changing the the Field Type of the Unique Key to ‘Text’ instead of the current field type ‘number’?