rfp | Working prototype of Real Functional PHP library | Functional Programming library

I am having some problems retrieving data in a one-to-one relationship. I have this existing Table and I want to retrieve the data from rfp_details. here is my code

I have a function that sends an email in App script and using the HTML template to build the body of the email. The forEach loops through rows in a sheet.

When I run my function from the Editor, it all works fine. The email body contains the rows I expect to see. No errors.

When the time-driven trigger runs it, the output in the email is missing the data (tr and td) from my forEach loop which sits in the .html file/template.

When I look at the execution logs (time-driven trigger), there are no errors and the logs are consistent with the email body.

While testing, I set the trigger timer to "every 1 minute".

Here's the code.gs:

I have an async function to store several files from a form into Firebase Storage and i want to collect file names so that i can store them in the database in the next step.

The problem is that the array with file names that is generated is sort of "nested" and when stored into database - the field is empty. When i return array in the console (please see picture below), array is:

1. Empty if pasted with JSON stringify (green line in the picture)
2. Is a "multi level" array of a sort which can not be saved to database (at list as array) (pink line in the picture)
3. Array is empty when converted to String (blue line in the picture)

Please suggest how to correct this. Thank you!

Here is my code:

Question coming from someone who started coding GAS 3 days ago. I'm trying to transfer a tool I developed as an Excel VBA Add-In with Windows Forms into Google Workspace. I apologize in advance if this is potentially something that simply isn't possible in GAS/HTML.

I'll try to describe the use case as simply as possible:

I have implemented a sidebar in Google Sheets with multiple text boxes for user input. I have successfully transferred inputs from the HTML textboxes into the GAS part of things. Now, I have a field that is pre-filled in with a date. Below are two buttons. These should be used for the convenience of increasing the date in said textbox by a number of days (+1 day; +3 days; etc.).

So clicking on +1 should automatically increase the displayed value in the textbox by 1 day.

I'm trying to implement exactly that functionality. As of now I have successfully handed over the value in the textbox to a GAS function that increases the date by 1 (even that almost made me lose my mind compared to how this is done in VBA :( ). Now I want to transfer that new date back into the text box.

After trying to search for any similar use case almost the entire day, I gave up and registered here for help. The only comparable things I could find with regards to transferring values from GAS to HTML used these values in the createHtmlOutputFromFile function to hand them over when creating and launching the sidebar. In my case I want the value in the textbox to change while the sidebar is open.

I rely on this not only for something as trivial as increasing a date, but for the sake of clarity this was one of the easiest examples to explain.

Thanks for any help in advance!!

UPDATE WITH CODE

So I'm trying to create a bash script to pass the IP array needed to make inventory file for ansible the official docs say that this is achieved through

My aim is to predict between five and six numbers in an array, based on csv data with six columns. The below script is supposed to predict only one number, from an array of 5. I assumed I could work my way up to the entire 5 or 6 from there, but I might be wrong about that.

Mre:

While reading the PDF table using camelot some columns are concatenated and their values too like below

I'm trying to receive stock data for about 1000 stocks, to speed up the process I'm using multiprocessing, unfortunately due to the large amount of stock data I'm trying to receive python as a whole just crashes.

Is there a way to use multiprocessing without python crashing, I understand it would still take some time to do all of the 1000 stocks, but all I need is to do this process as fast as possible.

I have a Grand Parent component in which I have a button , and basis on some code I want to show/hide that button so for that my code is as follow :

grandparent.component.html