Log in to AnswerLog in to Follow
2021-10-17 07-42-50
vishill
56Views
8Comments
Solved
DropdownsearchOnselect with API JSON into List for Display
Question
JSON
Traditional Web
Application Type
Traditional Web

Hello everyone,

First– am New here!!

Am a prof teaching a particular subject and getting the assignments from students uploaded through a Google Form. Hence trying to make a web app which will allow me to derive values from Google Form (google sheets) and publish a real time report for students to know their progression of assignments as they upload it.

I used Google App script for get the api and import data through JSON into Outsystems. Once in OS, I attached Dropdownsearch and got the unique ID (PRN) in the search bar o dropdownsearch. Now am looking to get the List below updated based on the selection of the PRN. List is all JSON fields which are pre-calculated in Google Sheet.

Since all of this is been done without an Entity of OS – how do I use DropdownSearchOnSelect can achieve what I want?

OML as attached

0
0
30 Mar 2022

Yes @vishill I did those changes also Please refer the OML and DEMO link.

I also checked your JSON code maximum of results were not evaluated so check with particular PRN number
Example : 1062210834.


Please check the Demo Link as well.

Result :

It will update the corresponding values as well.

Please check the DEMO Link attached Above and OML as well.
Any doubts feel free to comment so that we can help you.

- Palle Vijay Bhaskar Reddy

See solution in context
0
0
30 Mar 2022

attached oml

Tio.oml
0
0
30 Mar 2022

Hi @vishill ,

Just now I gone through your OML,

Some changes needs to be done, Please follow the below steps and I'll attach the Modified OML as well.

1. I added one local variable to store the selected value and to display the same on the message which you added in the Dropdown Onchange.


2. Inside Dropdown OnChange Assign value.

Result: 


If this is not the requirement Please add the more comments, so that we can help you more.

I attached the Modified OML and the DEMO Link as well.

DEMO Link.

I Hope this helps.

- Palle Vijay Bhaskar Reddy

Tio Modified.oml
0
0
30 Mar 2022

thanks @Vijay Bhaskar Reddy Palle , infact i had read your answers which was on dropdown earlier as well... 

The Objective is NOT the message (message was ONLY for validating) - but the LIST below - which gives the corresponding values from the Json. So am looking for a solution to get the Dropdown selection value (PRN) and connect it with the list along its corresponding values from Json file...

0
0
30 Mar 2022

Yes @vishill I did those changes also Please refer the OML and DEMO link.

I also checked your JSON code maximum of results were not evaluated so check with particular PRN number
Example : 1062210834.


Please check the Demo Link as well.

Result :

It will update the corresponding values as well.

Please check the DEMO Link attached Above and OML as well.
Any doubts feel free to comment so that we can help you.

- Palle Vijay Bhaskar Reddy

0
0
30 Mar 2022

Replying to Vijay Bhaskar Reddy Palle's comment on 30 Mar 2022 14:49:45

hello Vijay - thanks for the response - however it is NOT updating the values below and Yes i did checked your version and link...

here are the comparative answers for a particular PRN... 

I want the values of the Google sheet to be seen here in the list below = values from OS. We do have the value of the selected PRN from DropdownOnselect - but how do i connect that to the values of OS given PRN been the common parser. Thanks

0
0
30 Mar 2022

Replying to vishill's comment on 30 Mar 2022 15:35:11

Yes @vishill ,

I'm saying the same thing.

DEMO LINK

Please check the DEMO and OML.

NOTE : Make sure your selection should be Perfect PRN number that having DATA.

I took the same PRN Number = 1062211283 which you mentioned above.

Please check the Below Screenshot.

- Palle Vijay Bhaskar Reddy.

Tio Modified.oml
0
0
30 Mar 2022

Replying to Vijay Bhaskar Reddy Palle's comment on 30 Mar 2022 15:38:34

Yup i see it now.... thank you so much... i tired with Filter but not the same what you did... i think i was over doing it. but looking at your solution makes complete sense. Thank you.

 Solving out... 

0
0
30 Mar 2022
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.