Add a method to a google sheet (published version) - which allows me to hide/show a column

I want to publish the sheet called Y11 grades - see copy below

The names appear in column C

The pupils see the published version of this but I do not want them to see each others names. it would be ideal if I could give them a number to enter or a link to this webpage with passed parameter so they only get to see the one row - for their name

I am currently removing adding the = before the function IMPORTRANGE in C8 so it shows the names when I want to see them.. But his is not practical...

Can you update my version below to do this? I would want the solution so that I could understand it and use it on other gradebooks.

If you can think of any other/better way to do this then suggest it. But I only want to maintain one copy that I can see all names and the students only see their row!

[login to view URL]

Beceriler: Google Sheets, Scripting

Daha fazlasını gör: add getafreelancer google toolbar, add photo google map php, add javascript google site, add gaf google toolbar, website ability add tags google maps, extjs record add method, add aspnet google talk, add polygon google earth, add flash google map flash site, add polygon google maps, add route google maps, add places google map xml, php add dynamic google map, add marker google maps load, add polygons google earth, add data google finance excel, add info google map, add maker google maps vbnet, https://docs.google.com/spreadsheets/d/1BoluYWe-QeEmRDwp1nHYwzJw5AZwmHxdjsMlLuv8Lns/edit?usp=sharing

İşveren Hakkında:
( 18 değerlendirme ) Liversedge, United Kingdom

Proje NO: #22044236

Bu iş için 4 freelancer ortalamada $51 teklif veriyor


HI, I am good at Google sheets and formulas. I have referred the file. Looking forward to discuss further in the chat. -Chandra

$100 USD in 3 gün içinde
(1 Yorum)

Hi, It is possible that students enter their role numbers and they get their data. If you are doing it manually, it is certainly possible in automation. Thanks

$50 USD in 3 gün içinde
(1 Yorum)

Hello? How are you? I am excited to work with you on Google doc, Google spreadsheet and PPT api. So I think I can help you if you want. [login to view URL] This is what i have done in google script with a Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Hi, This can be achieved and if required long term, we can develop a data sheet. I will be excited to discuss this further and can be of help for you. Regards, Prakash

$25 USD in 5 gün içinde
(0 Değerlendirme)