How to fetch data in horizontal row in google sheet

Hello guys. I am a beginner to google sheet and google app script. I have developed a app for residents to pay the monthly fees right now I have a prototype on how the app look like I will include the link here for your references. For part two days, I am trying my level best to come up with a program where after user have loged in using their account they can view the payment status ( for my database it should show from G2 to R2 ) but I cant do so. Can anyone here help me to do that thing? Thanks in advance
Link for google sheet
Link for Google Appscript source code

On my phone so sorry for the short reply but there is a query parameter called “majorDimension” which you can set to “ROW” when you create your request

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.