Desktop View Error while Try to submit form that include Reference Table

[sundeeseeyou]

I am currently developing stock management apps. It works fine on Mobile or Table view when I submit form that includes referenced table.

So when I submit this, it works fine, and it shows me the list of submitted form.

But when I use desktop view, it says error on my Item ID Referenced field. (Item ID is invalid)

Can someone help me?

[AleksiAlkio]

Does it work if you don't add any Item? Is the behavior the same what ever you select for the Item ID?

[sundeeseeyou]

I make the Item ID required, so I cant post empty form

[sundeeseeyou]

I still can add item to the inventory_details, but when I am about to save them. It says the ID is invalid. It works fine on my mobile or tablet preview. And I don't have problem when I input item_id on my item table.

[AleksiAlkio]

Are you using the new desktop UX? If yes, what happens if you change it to the old version?

[sundeeseeyou]

The problem is on preview desktop sir. I don't know may be my valid if trigger something on desktop view. While it works fine on mobile/tablet view.

[AleksiAlkio]

So.. if you open the full screen mode from the most right icon, it works fine?

[sundeeseeyou]

No its not. i think desktop view kinda do error checking first before we even click save/next.

It's clear when i open the form, the require field give error right away with red warning text.

this is my valid if code, that works perfectly fine on mobile/tablet. But desktop view wont let me

IF(
LOOKUP([_THISROW].[item_id], "item", "item_id", "category") = "Consumable",
TRUE,
AND(
LOOKUP([_THISROW].[item_id], "item", "item_id", "Total Items") = 0,
NOT(
IN(
[item_id],
SELECT(
inventory_details[item_id],
[inventory_id] = [_THISROW].[inventory_id]
)
)
)
)
)