So I cannot for the life of me figure out why a datacard is not updating the record in the SP list from a form.
I have three simple fields. User, Comment and a TicketID.
I have User and Comment populating correctly when the form is submitted.
TicketID needs to be updated with the number held in varItem. This record ID is used all over the app, it's the ID of the parent record in the main list.
This second list is a normalized comments list. User is being set with Claims on datacard which passes to the control as the default selected items and then when the form submits, it updates based on the selected items. Which can never even change because the datacard is hidden. It's just there to hold the current user.
The comments field is a straightforward multiline text field and works a treat.
The ID field...my goodness why can't I make this work?
The datacard autopopulates the Datafield when the card is added to the form: "TicketID"
Default on this card defaults to ThisItem.TicketID which is meaningless since we're on the form in New mode so there is no ThisItem.
Required = true
Update = Value(DataCardValue31.Text)
DatacardValue31.Default = varItem (which I can see in the editor is a number. 156 specifically and btw I can see the 156 is the control since I haven't hidden it yet)
But no matter what I change the Update property to on the datacard, the column does not populate in the SP list.
And what is really odd is that when I was trying to resolve, I ended up trying to submit with NOTHING which actually resulted in an error because the datacard is marked as required AND the SP list column is required.
But when I submit, I get no error which seems to indicate to me that the app believes it has a value to update/create the record with but doesn't in fact use it.
I'm truly stumped about what is happening. I have exactly the same functions working in other apps but I can't for the life of me figure out what is going on with the datacard.