Why do i see the row data not the column data

[mustafaalbasel]

i get rid of the firebase and used the googlesheet for my data so lets help me in three points please!
1-i wanna show the row instead of the column as below

2- lets show me blocks for how to make that join button so i wanna customer when he add his no of people and press join so the data will be saved inside the row did he select so when the existed people num in the sheet is 2 and he added 1 so the sheet no of people will be 3 and his name will be added in the selected row

3- i wanna know how to delete the selected items from googlesheet

[TIMAI2]

FAQ Section: Google Sheets

Starter Guides Download a Google Sheet as CSV for the Media Folder and load it at startup - ABG AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web…

FAQ Section: Lists

Introductory Making Lists (Concepts) - MIT Lists Chapter from MIT AI2 Online book Translatable copy of Lists Chapter from MIT AI2 Online book How to work with Lists - imagnity MIT AI2 List Blocks Help Page How to Display a List - MIT nb191 Advanced list blocks (filter, sort, map, reduce) Tables Dynamic-editable-html-table - @TimAI2 free-tableviewer-fully-style-customized-to-show-table-data (extension) - @Kevinkun Dynamic Table Layout and Table Listpicker (HTML) - @Taifun Samples (S…

https://ai2.appinventor.mit.edu/reference/components/userinterface.html#ListView

[mustafaalbasel]

i see he just downlaoded a file and used its data but i wanna use the updated google sheet link not just a downloaded file

[ABG]

This sample app shows how to automatically update summary information in Google Sheets:

Logging Marathon Runner Checkpoints in Google Sheets

This sample is intended to show how to use Google Sheets aggregation functions like MAXIFS to summarize multirow log data into single line summaries. This sample uses the New York City Marathon as a base, though it probably can't scale to the 53,000 runners. It is based on three sheets: Checkpoints, a list of locations each runner must cross on his route Mileposts, a detail list of runner checkpoint timestamps Runners, a master list of runners, with identifying bar codes and stats Checkpoin…

You will need to study how Google Sheets formulas work.

[mustafaalbasel]

i found it, this is how to show rows from google sheet

[TIMAI2]

To be on the safe side, I would put the set Listview Elements block at the end of your format procedure

[mustafaalbasel]

alright but lets help me in the second request,
as i wanna when press add the new customer data will be added in the same row selected , lets show me its block,
something like that last cells

[TIMAI2]

What method are you going to use to add data to your google sheet ?

Spreadsheet component
Google Apps Script
Google Forms Prefill
...

[mustafaalbasel]

prefill

i just dont know how to add that global addition for the components, as i said i just wanna add the customer no people fill box in the same selected row whatever the customers additions are so the row cells will be increased

[TIMAI2]

A full Create/Read/Update/Delete using google forms / spreadsheet is detailed HERE

[mustafaalbasel]

but i wanna add more cells to the selected row not updating cells in the row