2019年9月26日 星期四

戰利品(LOLLIPOP F)


8年前的MV佳作,4年前我寫的歌詞翻譯。當年像是看見曙光般充滿期待,可惜至今仍沒看到台灣唱跳團體有顯著的發展。

My cries penetrate the midnight sky
My tears slip down into my throat
Walking forward with my eyes closed
I am standing at the end of my love story

Memories tangle with the reality
Wounds split open in slow motion
I fight for you and for love
Never with regret

*Your silence strikes me like a blade running across my throat
My heart stops and my hot blood freezes all at once

My love is possessed by you as a trophy
But you turn away from me indifferently
My love is devoted to you without reservation
Though never enough for you to consume
Your eye, like a black hole, engulfs all the reasons for me to love
My love has collapsed, me crying out, lonelier than ever*

I can no longer go back
You can no longer utter a word
Let it go and step forward
I have nothing left
We lie with forced smiles
And dress the wounds with the lies
I fight for you and for love
Never with regret

(*Repeat)

I am a conquest in love but willing not to escape
My body walks alone in a bustling city
I am a conquest in love but no one in the world can save me
My heart suffers silently in a silent night

2019年9月25日 星期三

Google Form 選項額滿設定



假設要辦一個大活動,活動下有各種組別,開放活動參與者填選,但每組有名額限制,須表單在該組名額已滿時自動顯示「額滿勿選」。請問該如何設定Google表單?

首先,將表單題幹製作好(選項內容尚無須填寫):


切換到RESPONSES,點擊Create Spreadsheet:


在spreadsheet內增添一個Sheet命名為「Choices」,並填上4欄「Rename」、「Lab」、「Response Count」、「Response Limit」,其中「Rename」欄下方內填入「=IF(C2<D2,B2,TEXT(ROW(A2)-1,"0")&". 額滿勿選")」後,往下拉到足夠的選項數,使得語碼都自動填入各行: