Populating form from data table

New user ramping up my learning. Having problems with a pushing data from a data table to a form.

Building a data form where I can do CRUD operations on a record set. The page has a data table (top) which, with a record selected, will populate the form (by setting the data model to the form using the “On Record Selected” action).

The form has input fields and select fields (to be used if user needs to change the selection), with each column name of the data table connected using the the “Value Logic” field. Select fields are used for specific choice selection (to be used if user needs to change the selection), and are populated using “On Page Enter” action.

My problem is that the Team field (a select field) comes over fine (data is transferred from the data table fine. The Incident Type and Misconduct Applied fields (both select fields) will not read and show the data from the table.

I’ve been troubleshooting for a few hours … no luck.

Would appreciate any ideas you can provide. I’m happy to provide to link to application if that helps.

Thank you.

Hello @Miller_Newlon

Are you able to create a minimal reproducible example of your issue?

Regards, Dima.

yes, Dima. I can let you look at the form. Please let me know how to share my prioject with you. Thanks

Just create a page that doesn’t require any additional steps like login in your app, and let me know the app name and page name.

app: Game Reports
page: IncidentsMisconduct_AddUpdate

Hi @Miller_Newlon,

Please provide your Application ID. I couldn’t find the application by name, and application names cannot contain spaces.

Regards,
Viktor

app ID: CF5F60C0-9172-07D0-FFD7-8334D48CDB00

Hi Miller,

I just ran the IncidentsMisconduct_AddUpdate page and can see the data in the select fields:

Did you already get it fixed, or did I misunderstand the issue?

Regards,
Mark

The select list fields are working and loading correctly.

I got the Incident Type field working (data is read correctly from data table)

What is not working is data in Misconduct Applied field read from the data table and pushed to the form when the record is selected.

When I run the page, the table is empty:

Sorry, the data loads through the lgoin page. I will reconfigure to read data without login.

reconfigured so login not required to see data. Data will move to table now. thank you.

Here’s the reason why the Misconduct Applied select is not showing a value for the selected record:

The Misconduct Applied select component has the following labels/values. Specifically, notice the values are objectIds from the list_IndidentsMisconduct table:

When a record from the data table is selected, it becomes the data model for the IMForm form:
UI Builder - default - GameReports - Backendless 2024-02-01 09-35-11

The Misconduct Applied select component has the following data binding for the Value Logic
UI Builder - default - GameReports - Backendless 2024-02-01 09-35-53

Now, let’s take a look what kind of value a data record has for the MisconductApplied property:

As you can see, it is just a string, the same string that is used for labels in that select component. The values corresponding to the labels must be objectIds (see the first screenshot at the top of my response).

I hope it makes sense.

Regards,
Mark