Hello, i was wondering is there a way to create a right join of two google sheet tables?
I have 1 screen that shows a list of elderly residents, by clicking on the list it will bring you another page that will show the individual's personal info which is in a elder data sheet. In that page there will be a list view for appointments that will be connected to another sheet known for their doctors appointment. is there a way to connect the two sheets where both tables have the a common value of the resident's name?
Suggest a bit of research, this is a google sheets question, not AI2....
If you can download both sheets into tables via CSV, here is an equijoin filter ...
select_where_equijoin.aia (11.7 KB)
All the blocks images are draggable directly into the Blocks Editor.
These are 2 seperate Google Sheets
This is the Android app output
Both sheets are connected by a Column having the Sr Citizen's Name.When click a Name in ListView1(showing u names of all the registered Sr Citizens), it looks for all records of the same name in the 2nd Google Sheet and displays the appointments in ListView2.
I dont know if this is something like what you are trying to do.
yess that's exactly what I need, I couldn't find a video on right joins or any type of joins for google sheet so I tried a different way. It works but the output does not show in one single row for each appointment. Can someone help?
this is how the output looks like:
these are the blocks:
@Allysha_April
you may consider sharing your project .aia file and also explain the entire flow of data,and most important - What is the output u uneed !
ECMS.aia (2.2 MB)
The place you'll need to be searching is the database screen. When running it'll bring you to a list of the residents, once selecting a resident it'll bring you to a personal view layout of the resident just like the above. every data shown above is from a different sheet while the appointment list view will be coming from another sheet of information.
The block codes will be in the far right bottom, for the output. I just want something similar to yours. where by clicking the resident, it'll show what appointment the person has.
Where r ur blocks to READ from the Google Sheets????
U r using firebase for registration and login??
Where r these appointments being written??
There is no WebWrite or WebRead ! No Google Sheet Components in the app code blocks !
You are in the wrong screen.
I think you got the wrong screen but it's okay, I tried your method through your aia file. Thank you so much, it worked out just fine
I kept the linking from the 2 seperate google sheets very simple and basic .... hope it works out for u
Now how do I clear out the list view after recent searches?
this is how it looks like right now after I edited some of the spacing to make it look nicer, it just adds to the past searches I had:
@Allysha_April
You are Setting ListViewElements from a Globat List
Option 1. Set ListView to Create Empty List when u want to clear it up
Option 2. Set the Global List to Create Empty List.
As it is the Global List will get values when u are calling WebRead Got Text and assigning the Global List from responseContent.
Here I am assigning the WebRead Got Text responseContent to GlobalList1
From GlobalList1 I am creating globalList2
I am clearing up globalList2 to refresh it
because when I go to that screen again, global list2 will again get the values as per my filter from Global List 1
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.