Thanks!

Thanks for the videos. how about I want to lock the data part and only the admin can unlock it and see the updated data?

Thank you for your tutorial! I have tried using this method without the help of ai and it didnt work, so i just gave up. But when i saw your video it was so easy, you explained it clearly ! I modified it and tried it and worked perfectly! This will be a great tool. IThank you for sharing it. :)

@technologiate

2 ай бұрын

I'm so glad to hear that the tutorial helped you! Thanks for sharing your success, and I appreciate your kind words!

Great 👍

Hi, Can this be done for micro Excel too I don't know how to feed duplicate in this section.. is there any chance that I can feed multiple duplicate data

Thank you

thank you for you tutorial , it was clear and helpful. but for the apps script when you need authorization and it has a disclaimer that google spreadsheet can delete etc etc. is it safe to use apps script? cause im confused , its extension from the google itself but the google hasnt verified it. or is there other way to do the macro without apps script thank you in advance

@technologiate

6 ай бұрын

You are welcome. I am glad that you find the tutorial helpful. It is completely safe to use the Appscript. Google shows the warning because the script is not verified with them. You can verify the script with Google using OAuth client verification. Since the script can only manipulate the worksheet, there is no harm. You can see the whole script; there is no code that can harm your data. Still, if you do not want to see that warning, you can follow this guide from Google: developers.google.com/apps-script/guides/client-verification Thank you.

if we protect the sheet and excluding the necessary fields, we can use buttons. if we use unprotected sheet, other user may delete the button. how can we set permissions to the button?

Thank you so much 🎉🎉

@technologiate

18 күн бұрын

You’re welcome 😊

Thank you for the useful video. 1. What if I want to add more fields in the form in future? Will I need to make a new prompt and rewrite the code? 2. If I just edit the code wont it falter the code for buttons since the buttons will have to pushed down to make space for new fields in the form? 3. How to add image option in the form?

@technologiate

Ай бұрын

Hi, 1. If you copy the code to ChatGPT and ask to add code for the new fields with correct cell references, it will provide you with the exact code since you already have a code base (you can copy my code; the link is in the description). 2. The buttons are not connected to any cell; you can move them anywhere on the sheet without affecting their functionalities. 3. I haven't played with image entry. Please let me know if you do and how it goes. Thank you

How to make different quotations by clicking by button

I need some help

Parabéns pelo conteúdo. Você poderia disponibilizar o código app script para fins didáticos ?.

@technologiate

9 ай бұрын

Hi, I have updated the video description with a link to the Google Sheet. You can copy the Google Sheet. Please consider subscribing to the channel. Thank you.

@gilmargilmar865

9 ай бұрын

@@technologiate Ok. Já escreví-me. Obbrigado.

When you share the sheet with others to collaborate on, will the script still work or not?

@technologiate

Ай бұрын

Yes, it will work. They need to authorize the script for the first time.

Is there a possibility where the sl. no. will rearrange itself in descending order in the data sheet?

@technologiate

18 күн бұрын

It should be possible by using another script which will automatically sort the data whenever there is an update.

Is there a possibility where the sl. no. will rearrange itself in descending order?

@josejenicehelpdesk8786

20 күн бұрын

Is there a possibility where the sl. no. will rearrange itself in descending order in the data sheet?

Hello Thank you to creating very useful video. I am create one data entry form follow all the instructions, But in end data is not save received an error "Google hasn’t verified this app" Can you please help how to slow the same.

@technologiate

5 ай бұрын

Hi, you are welcome. Please check at 9:56; I have explained how to verify the script. Click on the 'Advanced' link and then select 'Go to ..... (unsafe)'. It will verify the script. Thank you.

Hello, greetings. I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed. Is there any way you can help me with this?

@technologiate

2 ай бұрын

Hi, By default, Google Sheets keeps the logs of the changes. There are other Google services that can do it. What is your use case?

@muraly3523

Ай бұрын

Is it solved?

Bro, Is that possible to make it password protected so that the operators will automatically registrar there instead of manual change.

@technologiate

6 ай бұрын

Yes, it is possible to grab the operator's name from the user entering the data. It will require additional code.

Is there a way for me to access the form from my mobile phone?

@technologiate

7 ай бұрын

If you want to create dashboards to access from mobile, I suggest you get 'AppSheet.' This tool has a lot of cool features and integrates with Google Sheets and Drive. I use this regularly for a client.

what if 2 people or more using the form input, will the data overwrite each other?

@technologiate

6 ай бұрын

(I modified the comment; I oversaw your comment.) It will overwrite the data when more than one person is working on the inputs simultaneously. To make it work, you need to create a separate worksheet as the database and then create multiple worksheets for people for the inputs. All of the worksheets should be connected to the data worksheet.

@worldproplayer725

6 ай бұрын

@@technologiate i mean, when 2 people doing input, they will overwrite each other. can u solve this?

@technologiate

6 ай бұрын

It will overwrite the data when more than one person simultaneously works on the inputs. To make it work, you need to create a separate worksheet as the database and then create multiple worksheets for people for the inputs. All of the worksheets should be connected to the data worksheet.

Button not working on mobile. Please help.

I need write in a sheet the events that happens in one determinade range.

@technologiate

2 ай бұрын

Could you please send an email with the requirements? The complete workflow you need. We can design that for you.

@eduardopraciano4143

2 ай бұрын

@@technologiate Ty bro. I sent you an email

Hello sir multiple user cannot entry data at a same time, how can i solved it

@technologiate

5 ай бұрын

In that case, you need to create a sheet for the database and separate data entry sheets for each person.

@user-dv7xe5ks9o

5 ай бұрын

@@technologiate how to connect different sheet with database sheet

How to do this for multiple spreadsheets

@bhargavdipankar

4 ай бұрын

To be precise i need add delete modify data for multiple sheets which is present in 1 single spreadsheet . How to select the respective sheet for respective entry

How the search works if more than one record meet the search criteria?

@technologiate

4 ай бұрын

Initially, it doesn't enter duplicate entries. However, if you add duplicate entries to the data sheet at the time of the search, it will fetch the first record it finds.

@mohammeda.abdulkareem1945

4 ай бұрын

@@technologiate First of all, let me thank you for the great work and efforts that you did. Second, thanks for responding to my question. In my case, I am doing a citizens complaints management system that some users do entries from different service offices in this system. I am not expecting a duplicate entries, but expect that some information would be similar. For instance, if I search for complaints related to water services, I should expect more than one entriy, in which case, I should be able to have all related entries for further action (update, edit, delete). Thanks again.

@technologiate

4 ай бұрын

Hi Mohammed, You are welcome. The way it works, as shown in the video, is it has a unique key for the record; for a student, the roll number is the unique value, and for employees, employee ID is the unique value. And the search works with the unique value only. But you can create your dashboard with the method you need.

@mohammeda.abdulkareem1945

4 ай бұрын

Hello, Thanks for the clarification. I tried to follow the steps, but when I select the Apps Script from Extensions menue, it gives me Bad Request Error 400. Any thoughts about that? Thanks.

@technologiate

4 ай бұрын

Do you have multiple Google accounts signed in? It could be a possible error. You have the Appscript with an account, and when you open it, it tries to load the page with the other account. What I do is create multiple Google Chrome profiles for each Google account.

How to add picture??

hi I would like if could help me design a form of data entry form for the expenses track i am willing to pay you

@technologiate

6 ай бұрын

Hi, Could you please send me an email(find it on the channel about page) with the requirements you have thought about? I will try to help you. Thank you.

How to" fix reading get last row"

'Promosm' 💥