Excellent idea

Thank you, it works 👍

tq dor the knowledge sharing 🎉

thank you very much🤟

Thank you very much, it is working like charm.

@SunriseITEducation

Жыл бұрын

See video and get source code and replace SiTE

@ahmedroshdy6493

Жыл бұрын

Can you send me the code ?

good job

Thank you so much brother i try it and it will work . Love from Pakistan

@jamiamuhammadiaf-64islamab51

4 ай бұрын

بھائی صاحب میں کافی ٹائم سے چیک کر رہا ہوں مگر مجھے کوڈ نہیں مل رہا۔ کیا آپ مجھے بھیج سکتے ہیں؟؟؟

hello sir is there a way to receive QRcode with my details once I fill out a form? and like if 3rd part scans they will get the details?

Dear Sir Can we Get Audio Output for the same number?

Sir, agar is form ka copy bnayege to kya ye same chiz uspe bhi kam karegi ya dubara karna padega

When I entered one form than another form the generated no. Is same, what i do plss resolve my issue

I want Google form payment system. Complete payment, then open Google form. Is it possible???

Else how to get audio output in Google sheets

Please let me know if every time we fill the google form, our receiver gets our mail address or not.

@SunriseITEducation

2 жыл бұрын

Yes

Can the date be changed ? The next day wil automatically become 202205100001/202205110002/202205120003

where is the source code bro??

Hi, how to make the form generate the number based on certain values i.e (date, total order)

@SunriseITEducation

7 ай бұрын

Open website and click download script option and get source code

I am getting error apps script...

Hello Sir ! How to Registration No fatch from Google sheet particular colum after form Submission ???? Plzzz solution me sir. Thank you...

@SunriseITEducation

2 жыл бұрын

Google form data submit than see video Google sheet data fetch to webpage

@rashidulhoque9460

2 жыл бұрын

Sir ! Google sheet Mai Formula Se generate hua random number Google from ka greeting msg Mai keise show karau after form Submitting???

When i run your script , unknown people ask to request access to my form.

@SunriseITEducation

2 жыл бұрын

See video and follow all step in given video

Hi i am getting error at line 56, showing Cannot read properties of undefined (reading 'getRange'). and also error at line 69. can you help

@SunriseITEducation

11 ай бұрын

Click video description and open website and get source code

I'm getting an error when I try to create a Trigger - You cannot create a trigger without a target function, please add functions to the attached script.

@SunriseITEducation

2 жыл бұрын

Email your google form and google sheet in editable mode

@felominavaron1557

10 ай бұрын

Gooday! Is this free?

hello, pls help doesn't work on my form, when i try to run script error in range - undefined. thank you

@SunriseITEducation

9 ай бұрын

Open website and click download script option and get source code

I have liked and subscribed Please share code

@SunriseITEducation

Жыл бұрын

Click video description and get source code

i am unable to get the sorce code from the website it is asking for some sort of payment

@SunriseITEducation

9 ай бұрын

Yes

When I am submit the google form after some time I'm not getting unique number and also not showing in the response sheet.

@SunriseITEducation

2 жыл бұрын

See video carefully and follow process and get source code

@devendersingh7732

2 жыл бұрын

@Sunrise IT Education I get 13 source codes in first time but then after 2 hours i fill form again then source code shows 14 but it is not showing in response sheet and then only 14 source code shows in each submission are.

@devendersingh7732

2 жыл бұрын

Please help me.

@devendersingh7732

2 жыл бұрын

Please suggest here

I have tried this upto 1st 30 serial it gives correct response code after that it is jumping, example a person serial wise based on timing it is 35 but response code comes as 50, something is wrong

@SunriseITEducation

Жыл бұрын

See video and learn

@sridharmurthy8393

Жыл бұрын

@@SunriseITEducation yes I have followed all instructions given in video, yet also that problem came to me

@udit.beniwal

Жыл бұрын

where did you get source code?? please tell :)

@sridharmurthy8393

Жыл бұрын

@@udit.beniwal from your website sunrise

Sheet shear kare sir make copy karenge kar skte h

@SunriseITEducation

Ай бұрын

Open website and click Download script option and get source code

Sir, Registration no Ko Randomly Genarate Kia ja Sakta hai Kia ???

@SunriseITEducation

Жыл бұрын

Randomly no see video kzread.info/dash/bejne/iI2Nqairp7bKYdI.html

@rashidulhoque9460

Жыл бұрын

Sir, dono function Marg karke ek video banaaiye, with Random No. (Email sand & presentation view)

@udit.beniwal

Жыл бұрын

code kaha se mila

Hi, may i know how to change the “ UID “ to another word? As example pau0001 , pau0002 please help me

@SunriseITEducation

Ай бұрын

Replaces

can it be done in mobile??

@SunriseITEducation

3 ай бұрын

Yes

you make awesome videos but every time i go to your site i donnot get the desired code. Sorry to say but very disapponting

@SunriseITEducation

Жыл бұрын

Open website and click download script option and get source code

Hi. How to change the font color and size only text "SiTE0001"?

@SunriseITEducation

10 ай бұрын

Open website and click download script option and get source code and make own application

@abhi_sir_totalexam

9 ай бұрын

@@SunriseITEducation please provide source code. I am unable to find source code

they are asking for donation then only providethe source code

@SunriseITEducation

8 ай бұрын

Open website and click download script option and get source code

कोई गूगल फार्म सम्मिट करता है तो उसके मोबाइल में सम्मिट हो गया का मेसेज ऑटोमेटिक चला जाएगा । ऐसा कोई वीडियो है तो कृपया लिंक भेजने की कृपा करें । 🙏

@SunriseITEducation

3 ай бұрын

Yes see video on my channel

the username and id send to me via email does not work

hello sir, how to take the codes ?

@SunriseITEducation

3 ай бұрын

Open website and click Download script option and get source code

Can i get this link

@SunriseITEducation

6 ай бұрын

Open website and click download script option and get source

Code is paid version, Not free

Please Share Script Code

@SunriseITEducation

2 жыл бұрын

Click to google sheet with source code copy than read carefully instruction and get source code

when i am clicking over app script it show error that , Sorry, unable to open the file at present. Please check the address and try again.

@mayanksinghvi3923

Жыл бұрын

Please help us in this regards

Your website is not opening

@SunriseITEducation

7 ай бұрын

Click video description and open website and get source code

There’s no source code on the website

@SunriseITEducation

Жыл бұрын

Open website and click download script option and get source code

Code kaise milega ye btao na yrr

@SunriseITEducation

11 ай бұрын

Click video description and open website and get source code

How to get the source code please?

@SunriseITEducation

8 ай бұрын

Open website and click download script option and summit registration form and get source code

there is no 38 option

@SunriseITEducation

Жыл бұрын

Yes

I can"t see any source code. And to getting source code process i can't trust.

@SunriseITEducation

Жыл бұрын

Click video description and get source code

@udit.beniwal

Жыл бұрын

bhai kisi ko bhi nhi mila pagal banaya h

Music volume kam rakho

@SunriseITEducation

11 ай бұрын

OK

Muje ek hi number bar bar show ho rha hai

@SunriseITEducation

Жыл бұрын

Read video description and get source code

@udit.beniwal

Жыл бұрын

code kaha se mila

I have clicked so many ads and followed instructions but i still do not see the source code. please help

@SunriseITEducation

Жыл бұрын

Click video description and follow instructions and get source code

@blossombuttercup715

Жыл бұрын

@@SunriseITEducation can you send me the code please

@SunriseITEducation

Жыл бұрын

@@blossombuttercup715 click video description and follow instructions and get source code

@udit.beniwal

Жыл бұрын

@@SunriseITEducation code nhi aa raha bhai

hi where is the code?

@SunriseITEducation

Жыл бұрын

Open website and click download script option and get source code

Code nhi arha hai

@SunriseITEducation

8 ай бұрын

Open website and click download script option and get source code

@sherdawalakhan

3 ай бұрын

Nahi aayega Phle ise paise dene pdenege

I’m not able to copy the code, could you please help me ?

@SunriseITEducation

Жыл бұрын

Click video description and get source code

@ahmedroshdy6493

Жыл бұрын

@@SunriseITEducation i cannot understand what’s written since it is not in english

@SunriseITEducation

Жыл бұрын

@@ahmedroshdy6493 cluck video description and click link and read instruction carefully and get source code

@udit.beniwal

Жыл бұрын

Bhai kisi ko bhi nhi mila pagal banaya h, iske har video ka yehi chakkar h

No English translation, I can't comprehend what you are saying

@SunriseITEducation

3 ай бұрын

See video and learn

Unsubscribe

I want my ID is like "22S001" I try it But it's not work. I replaced "SiTE" to "22S" It is not work. So please help me.

@SunriseITEducation

Жыл бұрын

Send your google sheet with edittable mode by email

@changeindia5866

Жыл бұрын

@@SunriseITEducation mail id

@SunriseITEducation

Жыл бұрын

@@changeindia5866 see latest video and click description and get email id

how to change the const SiTE/XYZ to the time format like oder number 202205090001/202205090002

@SunriseITEducation

2 жыл бұрын

SiTE to replace your formate 20220509

@wongvoonhong

2 жыл бұрын

@@SunriseITEducation Can the date be changed ? The next day wil automatically become 202205100001/202205110002/2 02205120003

How to change This auto generate code "SiTE00001" To "22S001" Please reply me soon.

@SunriseITEducation

2 жыл бұрын

Replace to SiTE to 22S

@kasunthilanka4958

2 жыл бұрын

@@SunriseITEducation Thank you. But I try it. It's not work.

@kasunthilanka4958

2 жыл бұрын

const SiTE = { HEADER: "SiTE_HEADER", PREFIX: "SiTE", LENGTH: 5, } class App{ constructor(){ this.ss = SpreadsheetApp.getActive() this.sheet = this.getLinkedSheet() if (!this.sheet) { throw Error(`There is no linked form in this spreadsheet.`) } this.form = FormApp.openByUrl(this.sheet.getFormUrl()) this.message = this.form.getConfirmationMessage() this.uidRegex = new RegExp(`${SiTE.PREFIX}[\\d]{${SiTE.LENGTH}}`, 'gi') } createUidByNumber(number){ return SiTE.PREFIX + (10 ** SiTE.LENGTH + number).toString().slice(-SiTE.LENGTH) } getLinkedSheet(){ return this.ss.getSheets().find(sheet => sheet.getFormUrl()) } getUidFromConfirmationMessage(){ const message = this.form.getConfirmationMessage() const results = message.match(this.uidRegex) if (!results) throw Error(`No SiTE found in the current confirmation message with regex ${this.uidRegex}.`) return results[0] } createNextUid(currentUid){ const nextUidNumber = Number(currentUid.replace(SiTE.PREFIX, "")) + 1 return this.createUidByNumber(nextUidNumber) } saveCurrentUid(uid, rowStart){ const [headers] = this.sheet.getDataRange().getDisplayValues() let uidHeaderIndex = headers.indexOf(SiTE.HEADER) if (uidHeaderIndex === -1) { uidHeaderIndex = headers.length this.sheet.getRange(1, uidHeaderIndex + 1).setValue(SiTE.HEADER) } this.sheet.getRange(rowStart, uidHeaderIndex + 1).setValue(uid) } updateConfirmationMessage(nextUid){ const message = this.message.replace(this.uidRegex, nextUid) this.form.setConfirmationMessage(message) } run(e){ const {rowStart} = e.range const currentUid = this.getUidFromConfirmationMessage() this.saveCurrentUid(currentUid, rowStart) const nextUid = this.createNextUid(currentUid) this.updateConfirmationMessage(nextUid) } } function _onFormSubmit(e) { new App().run(e) } function _onFormSubmit(e) { new App().run(e) } Please change this one kindly.

@kasunthilanka4958

2 жыл бұрын

Please reply me immediately. Because I want to send it for my students end this month. Please help me.... Thank you.....

@SunriseITEducation

2 жыл бұрын

@@kasunthilanka4958 which type help