I hope you’re doing well. I’m encountering an issue while attempting to save data from the UD31 form. In the debug console log, I can see that my data appears to be stored correctly. However, when I check via a BAQ, no data is displayed, suggesting it’s not being persisted to the database.
Could you kindly assist me in identifying what might be going wrong? I’d be happy to provide additional details if needed.
Try moving these settings to the Request Parameters instead of the Response.
You’re sending updated data with your update Request… you shouldn’t need anything in the response.
I know going into the dataset sometimes locks up the whole widget, so you may need to delete the rest-kinetic widget and rebuild it. But this time, try using the request params instead of the response params.
Here’s one I have on one of my apps. Request is filled out, Response is blank:
Thank you for your suggestion. I tried implementing the approach you recommended, but I was unable to update the data in the UD31 database. However, I can see the data saved in the UD31 data view when checking the debug log.
Additionally, I created the data view using a BAQ of UD31—could this be affecting the ability to save data into the grid or database? Also, when saving the data, I do not see a new line being created in the grid.
As demonstrated in the attached GIF, my event is being triggered, and the values are correctly stored in the DataView. However, when checking through a BAQ, these values do not appear to be saved in the UD31 table.
I would greatly appreciate it if you could guide me through the exact steps required to configure a UD Grid so that when a user enters values in the form, they are saved in the UD31 table on the backend and also displayed as a newly created line in the grid. Additionally, if any modifications are needed at the grid level, kindly suggest the necessary adjustments. Your guidance would be of immense help.
I’m going to go back to this… can you add Key4 & Key5 to your dataset? Just enter null values if you want. But even when updating UD tables via DMT, you need to include all (5) keys in your template.
Look at your Debugger > Network tab, and review the “Update” call. What is being sent in the payload?
Here’s an example of one of mine. I’m not using Key 3 or Key 4… I am sending “empty” values, but the columns are included in my dataset.
In my case, my dataview is based on the the UD02 tableset. So, I’m passing the entire table.
In your case, you’re using a BAQ to populate your dataview, so the only columns available are coming from your BAQ.
I would try, first, adding Key 4 & Key 5 to your BAQ as display columns. Its okay that they’re empty.
Save your BAQ, and re-preview your dashboard again in App Studio. See if your dataset now includes those columns. If so, try the update again.
If that doesn’t work, in your save event, add a row-update before the update rest call. In that row update, just set columns VS_UD31.UD31_Key4 & Key 5 to an expression of “”. Perhaps that will help ensure they’re populated with something, even if it is an empty value.
Thank you for your suggestion. I have already included all rows from UD31 in my BAQ. However, my dataset only displays rows that are being saved, meaning it does not show null fields.
I tried adding a row update before the REST update widget and set Key4 and Key5 to null as suggested, but the results remain the same i.e. data is not being stored in UD31 DB.
I know this is getting repetitive, but try adding Company. Again, required when updating UD tables via DMT… and if you were using UD31 as a dataset, Company would be included.
Again, here’s an example of my update… but I’m passing their entire UD02 table in my dataset.
I have created a new event for updating the UD31 table, along with an updatable BAQ for the UD31 table, and bound it to a new data view, VS_UD31_V01. As suggested by @dcamlin, I have also included the Company field in my BAQ and, additionally, used the Row Update widget to set the Company field to the current company.
However, when I execute my customization and check the Network tab, the payload value appears empty. In contrast, in the image you shared, I can see that null values are being populated.
As you suggested @dcamlin, creating a UD31 data view without using a BAQ, could you please advise which method I should select when creating the data view?
Just an update—instead of using the Kinetic-ERP widget, I used the Kinetic-BAQ widget in my update event, and it worked! I am now able to save my UD Form entry into the UD31 grid, which I have confirmed through my BAQ.
However, for some reason, the grid where I want to display the saved line is not showing the newly added entry. I want the line to be displayed in the grid I created at the GRN Entry line level. Could you please suggest any changes?
Just an update—instead of using the Kinetic-ERP widget, I used the Kinetic-BAQ widget in my update event, and it worked! I am now able to save my UD Form entry into the UD31 table, which I have confirmed through my BAQ.
However, for some reason, the grid where I want to display the saved line is not showing the newly added entry. I want the line to be displayed in the grid I created at the GRN Entry line level. Could you please suggest any changes?
After my Update… (ignore the row-update, that’s just setting a save flag)… I have another event run that freshes all my BAQs… this updates all my BAQ grids.
I tried the suggestions which you suggested. But didn’t work well on my end. I first tried adding refresh grid after slide close and it didn’t update my grid with the save line as shown in below gif.
Secondly, I tried adding BAQ- Kinetic widget with “mode = Get” as suggested. But instead of updating only the saved line whole BAQ is getting initialized and no data is being updated.
