Field pre-populating in form but no writing to data source (excel file)

[bpansy4]

My screen is used as follows:

1. user selects a case from the Case button
   • in that data table, I have CaseDataTable.CaseID Onselect: Set(varCase, "Edit") to make view/edit the case, and a button to create a new entry  (ResetForm(formCase); NewForm(formCase); Set(varCase, "Edit")
2. user then hits the Needs button and NeedsDataTable and formNeeds populate as seen below.

HID and CaseID prepopulate based on the step1, but when I save the form CaseID isn't saving, but Case_Date and HID are writing fine. I can even go into the record and edit the call_back field (since it's not relying on anything from the previous table) and it saves, just the CaseID won't. Any thoughts here?

[WarrenBelz]

Hi @bpansy4 ,

I assume you are using SubmitForm() here - what is the Update on the Data Card that the CaseID Text box is in?

[bpansy4]

Yes, just a simple button for SubmitForm(formNeeds) and the update is just DataCardValue33.text

[WarrenBelz]

Thanks @bpansy4 ,

Very strange - sorry for repeating the question, but just to be sure the following is true

• Your CaseID Text box in your screen shot is called DataCardValue33
• The Update of the Data Card this is in is DataCardValue33.Text
• The DataField of the Data Card is "CaseID"
• The field you are writing back to CaseID is a Text Field
• Your are using SubmitForm() to save this form
• The data from this field does not save to the list

Is there anything inaccurate here?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[bpansy4]

No need to apologize, you're trying to help me out! And yes to all your questions. I even went to the two excel tables as my sources and did a quick caseID(tblCase) = caseID(tblNeeds) and it returned TRUE, so I'm baffled. Every other field writes, can be edited, etc... just not that one field.

[WarrenBelz · Accepted solution]

@bpansy4 ,

One more (rather hopeful) question - what is the DataField of the card?

[bpansy4 · Accepted solution]

Bingo. CaseID = CaseID & "_" & HID. CaseID was supposed to be date only, but it kept adding a timestamp that I wasn't seeing because I removed the hr/min from the date picker. That was the issue. Appreciate the tip there @WarrenBelz.  

[WarrenBelz]

@bpansy4 ,

After all of that you marked your own reply as the solution - you might consider also accepting the response that helped you the most.

[bpansy4]

sorry about that, honest mistake.