I have a catalog item with a date field and another text field.
The requirement is that when a requestor opens the catalog item then based on the date field value it should fetch the values from another table that contains this data for the requestor.
for example, the table "ABC" has the following data stored.
Username = "Test User"
Date = 31-08-2022
ID = 123
so what is needed is that when the requestor "Test User" opens the catalog item and selects the date as 31-08-2022 the other fields on the catalog item should populate the values stored in the table ABC for this date and this user.
so if the requestor selects the date 31-08-2022 the field u_ID on the catalog item should auto-populate from the ID field in the ABC table.
Any help would be appreciated.
