Saving a record in database table

Need help with saving data in database

Scenario

The drop down is a static entity ,while the comment box data will be stored inside local variable.

On button accept, need to store the id of the user, the choosen drop down static option, the comments along with the currwent date stamp. Could someone please assist with the logic steps. tried number of permutations but it is not working well yet .

Attaching .oml file for reference. Any leads or steps would be appreciated



TestModuleV2_.oml

Solution

Hi @saif sheikh 

Please go through this oml file:


V-module.oap

You are about to insert a new record to the Test_Audit_ClaimRecommendations table, right? In the action you must set the 'current' record Id - that does not exist yet - as NullIdentifier() and then make the assigns you need like YourTable.List.Current.AttributeId = SelectedOption.

No , i need to create a new table to store the decision of the user.

The audit claim recommendation table is coming through an Api. The user is to see the data of table and either accept or reject 

Not sure if I understood. Did you already create this new table to store this decision? If yes, would it need anything else beyond than assign the selected option into the record?

Solution

Hi @saif sheikh 

Please go through this oml file:


V-module.oap

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.