Saving records with custom lookup lists

Hi @MartinF ,

How did you try to configure the approval status metrix code table values here? Your intension is to make this filed as a look up and save the values or have you added new data into this particular table and unable to save those new records? Could you kindly elaborate a bit more?

Hi @MartinF ,

If I understood correctly, you want to override the project.approval_status column values with a custom global code table? If that’s the case, assume that you have created the global code list first. See the example below.

Then what you need to do is to go to custom metadata and define this global code table list under the approval_status column. Create custom metadata table for PROJECT and add the filed properties similar to the properties in FSM metadata. 

Then you need to define the relationship for the lookup under lookup section with global_code_table.your_global_code. Check the sample below. The code values which we have added in the global code list are going to get saved as the approval_status here.

 Once this is done, save and refresh the cache. Go to the UI Designer and select your custom screen.

Remove the existing approval_status field and then add the lookup /combobox for project.approval_status. Save and refresh cache. Open the assigned custom screen and check this out with the approval status field(ideally the code descriptions should be populated). You will be able to see the overridden result as you save a new project .