showModalDialog | window.showModalDialog polyfill using a dialog | User Interface library

Yo, I would like to create a script where the user can choose a folder and then by getting the id of the folder I display the size of the folder. I manage to retrieve the ID but I don't know how from this id I can calculate the size and display it. here is the code to show the picker google drive :

Im creating a google apps script and im trying to have json data from code.gs to the html files dropdown. I don't really know how this is done by not being so experienced with JS and google's own stuff. Heres the code:

I created a Google sheet for my team and we needed to attach files on it. I found a code which i thought worked well. I haven't coded for sometime nor used google script before. But from looking at it not working it must be the script or the onclick= on submit?

The google drive ID is fine , and i checked for all the <> and ;.....but cant seem get to my head around it to upload the file and run the functions.....

I am using the code from https://blackstormdesign.com/how-to-upload-a-file-to-google-drive-through-google-sheets/

Script: Upload_files

I have search for hours and cant find a solution to this. I have some appscript code that creates a menu and open a modal in google docs:

Good day all, I have a team vacation calendar. The user presses the letter "v" to set a vacation date, to which the date of the vacation is stored in an external worksheet (used for other purposes, so I can't simply have a separate worksheet in the same spreadsheet).

The problem, a vacation date can either be "Paid" or "Banked" (for crediting later). I use a modal Html window to ask the user which of the two, the vacation is. However, global variables I set before opening the html modal window lose their value. I need these global variables to store the row and column of the original entry (since the user clicking off the cell after typing "v" changes the value of getActiveCell().

What SHOULD happen:

1. user types "v"
2. html window pops up "which vacation type is this? banked or paid?
3. code enters the date of the vacation into the external spreadsheet.
4. code enters the "paid" or "Banked" value into the external spreadsheet.

I can get it to go as far as step 3 above, however, global variables are losing their values and there's no way to determine which cell the user originally clicked.

Step 1

Step 2

So I have a library that is used by several dozen sheets, which call the individual functions like this:

(from a menu)

Here's the problem:

I got these codes running without error, but altogether, they won't work as expected.

The intent is once the user ticks a box in column A, the code running on onEdit basis is supposed to open a dialog box for the user to enter the date. Then the code changes a value in one of the row's column and the date is to be written right next to it. Once the user inputs the date and clicks on Add, the dialog box is supposed to close automatically.

I am not sure about the order of the functions and how to have the onEdit function wait until the user enters the date so that the dialog box disappears and it continues writing the date to its destination.

Thanks for your attention.

Is it possible the create modaldialog/modelessdialog that is always x% of the screen? I know that I can set constat width and height like so, but I'd love to have it depending on the user screen

First of all apologies if this is a silly question as I am a total newbie to coding and programming.

I am trying to create a CRM Webapp using Google Apps Script for my company that stores all of its data in Google Sheet. The work is still in progress.

This CRM Webapp will basically have a Home Tab (to Search and Edit Data), Sales Tab (to enter Sales Entry), Purchase Tab, (to enter Purchase Entry) and Contact Tab (to add Contact Details).

The idea is that a user will first add the contact details of a New Customer/Supplier in the Contact Tab, and this data will be stored in the Google Sheet.

Now to make a Sales or a Purchase Entry, the user will have to now First select the already entered Contact (Only Name, Phone Number and Email Id will be visible) within the respective Tab.

For this I am trying to add a Data List from Bootstrap which will help the user to search and select the already stored Contact Details, and the depending contact fields need to fill automatically based on the Selected Name/Email/Phone.

I tired a lot of methods and referred several posts, but I am not able to populate the Search data from within Google Sheet. I tried using the Dropdown Logic, but even that did not work.

Following is my code. I am pasting only the parts that will look relevant to you guys as the entire thing is very unorganized. Any help will be highly appreciated.

Loadform.gs: