Hi All,
I want to ask, how to show value in other field column automatically when we already type in the one column? So, I use Table record. In there, there are contactPerson_name, contactPerson_Position, contactPerson_Email, contactPerson_Phone. When I type in the contactPerson name, the value that already store in the database, will show in list, and we can choose that. after that, the other information will automatically show the value. like if in ContactPerson table has jeffry information, when I type the name is Jeffry, then, in jeffry field, will show the list of jeffry name, and then when we choose jeffry, the field of contactPerson_position, contactPerson_Email, contactPerson_Phone will automatically filled with jeffry information. But, If in the contactPerson table don't have Jeffry information, we can input the information in that table, and that will store in database. But , we can re-use that information again in other company.
In here, I have some problem:
1. why when I choose jeffry that show in that, the other information can't automatically filled?
2. when I already click button save, and then when I open again the company name, the information that I already filled in contact person table record is dissapear. But, the information has already save in database.
Here I attach the OML. and you can see in the CompanyDetail screen.
Thank You
Regards,
RKT
Hi riesta,
In addition with the previous post, I have created a sample app based on the mentioned scenario..
Please refer the attached .oml for better understanding :)
Hope this helps you!
Kind regards,
Benjith Sam
Hi Benjith Sam,
Sorry for the late respon. thanks before for your help. But, I have a Question, Why when I choose the suggestion in list name, when I choose Jeki, this error message always pop up ? and the other value in other field, can't be filled ?
I observed that the OnContactPersonNameChange > GetContactPersonsById Aggregate Filter condition is incorrect. Could you please update the Aggregate Filter condition as mentioned in the attached .oml file and check once
ContactPerson.Id = TextToIdentifier(Input_AutoComplete_GetIdentifier.Identifier)
Refer the update attached .oml file
Thanks before. it's work finally. But, do you know, how to show the record that we already filled for that company ? Can we see, in here we already fill the contact person detail, but when we save, and then we re-open the information for the company, the contact person detail has 0 record, even we already fill the detail.
Sorry, I'm unable to understand the mentioned requirement.. is it that you want to showcase all the contact information that you previously entered within the table in the same screen?
If that is the case then you will have to do some code changes in the implementation i.e. You will have to map/refer an aggregate (defined with associated entity as source) result-set to the respective Table Records - Source Record List field property instead of Local List variable (which is not dumped with any value within the preparation action flow)
Hai Benjith Sam,
WowwThank you very much. It's work.
You are welcome, riesta :)
Glad I could be of help!
kind regards,
Hi RKT,
I did not get chance to run your code, but here are some of my findings.
1. On entering contact details, you invoke an action to fetch additional details and append to TableRecords List, but there is not code to refresh the container displaying those records, hence you don't see the details filled.
2. In preparation you are fetching the company contacts, but there is no usage of those aggregates in the code. This is the reason you don't see saved data on the screen on second load. Make the appropriate aggregate source of the TableRecords widget to see last saved data.
Hope this helps!
Junaid
I have checked the attached .oml file and found a lot of implementation flaws.
Please refer the attached .oml files which includes required code changes with comments..