Upvote 1

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

Solved Paul G ● ago

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

Danielle Schneider ●

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

Files:

Replies (1)

Danielle Schneider ●

Hi Paul,

This tutorial should help with this: https://www.justinmind.com/support/modifying-records-to-a-data-list-using-forms/

Paul G ●

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..

Files:

Danielle Schneider ●

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

Files:

Paul G ●

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

Thanks