Crow Canyon Software Forum

Crow Canyon User Community ForumNITRO Studio: Forms DesignerMulti Lookup Column Value(s) not …

Please or Register to create posts and topics.

Multi Lookup Column Value(s) not saving

#1 · November 8, 2023, 6:56 pm

Hello,

I've got 2 columns:
StandardEquipment (Multi-Lookup Column)
Price (Numbers Column)

Configure form Event Action:
Fetch Price :
Action Title: FetchSE
Type: Items
Get Item(s) from: StandardEquipment

Configure Update Form Controls:
Value: CCSQLFetchSE##$sum([PRICE|PRICE0])

Issue:
After a 'new' form is created, I click 'edit', and the Price (Numbers Column) doesn't appear value. is it possible to get price value to stick rather than the value be zero?

Uploaded files:

#2 · November 13, 2023, 4:41 pm

Hi @anguyen,

Please edit the form event action and send us screenshot of the main page (Configure Form Event Action). We will check when the action executes and suggest.

#3 · November 13, 2023, 4:49 pm

here's the (configure form event action) page

Uploaded files:

#4 · November 13, 2023, 4:51 pm

this is the multi-lookup that's part of my designer form.

After form designer is published, I click on 'edit' from sharepoint list, and see that the multi lookup 'Price' fields show 0 instead of the quantity of the selected.

Uploaded files:

#5 · November 16, 2023, 1:49 pm

'SHOW - Price Column' Form action!

I found the sus!!!

What had happened was that I said for the 'price' columns to set to zero if the 'standardEquipment' column was empty. I'm not quite sure why price would be set to zero when columns were selected though, but found the bandaid!

If you have any other solutions or suggestions, please keep me posted!