How to display some datamaster record's values in the next screen

Paul G shared this problem 10 months ago
Solved

Hello there,

I need some help to figure out a way to display other object attributes/ values based on the ID input by the user.

On screen A, user is required to enter Merchant ID and Amount. Then on screen B, I need to see a summary showing other merchant details based on the ID entered.


Eg: In a datamaster named "Merchants", I have fields including Merchant ID, Merchant Name, Location and Telephone and i have added records. Lets assume I have a record with the values Merchant ID="123456", Name="City Shoppers", Tel= "07123456789" and location="Kampala".

User enters the ID 123456 on screen A and on screen B, I should be able to see a summary of the other information based on the ID.

I have created an On-Page Load event but cant figure out the expression to filter info based on the ID entered.

I appreciate your help.

Any help is much appreciated.

Best Answer
photo

Thanks for clarifying. Does the attached prototype achieve what you're looking for?

Comments (4)

photo
1

Hi Danielle, thanks for the response. However, when i use Data Grid/ List as shown in the video, the output includes all the records in the Datamaster. What i need is to ouput only the information from the row whose ID was entered at sreen A (Just one record). I have attached sample screens.

I appreciate your help..

photo
1

Thanks for clarifying. Does the attached prototype achieve what you're looking for?

photo
1

Soo great, many thanks Danielle. Just reproduced in my prototype and everything is alright.

Thanks

photo