Complex Google Sheets project – batch exchange of web applications

I'm a teacher and I design a tool that allows teachers to design lessons and plan lessons. I'm new to programming and that's going to be a bit ambitious for me. I'm happy with what I've got so far, but there are some details I can not figure out. The idea is that this will be widely used, even for teachers with little technical knowledge. That's why it has to be "bulletproof".

Below is a copy of the spreadsheet so you can see the code and get an overview. What I mainly limit myself to is figuring out how to display the lessons in the unit summary so that they can be automatically updated and easily rearranged.

Each lesson has a tab and the unit summary contains data that has been validated to display the lessons in a drop-down menu based on another tab named "Sheet Name" that contains a script that retrieves all the lesson names. After selecting from the drop-down menu, the text will be replaced by a link to this tab. However, this script refers to the Sheet Name tab by line number. So, if you delete a lesson that is not the last one created, the unit summary will be confused and the lesson will appear in that row in the sheet name sheet. Any ideas on how to fix this? [this is mainly the script “UnitOverviewLinkGenerator.gs”, but because it’s important to see the other scripts too, I thought it made more sense to share rather than post just that script]

Also, I'd like to have the option to use the Google Drive Picker in the timetables where "Insert resource via link" to add a link to a Google Drive file. I've read a lot, but I think that's beyond what I can do.

If you have any thoughts, please post here or comment on the spreadsheet instead of making changes directly.

Thank you for any ideas or help you can provide!

Editable version of the table

Applications – Android drivers in one app

I have seen this app

https://play.google.com/store/apps/details?id=net.kismetwireless.android.pcapcapture

What makes your external wireless adapter (RTL8187 cards) work, no root, no custom kernels. The only way this works is a kind of user-space driver. My question is, can I create an app that supports the wireless card TL2WN722N as well as this app? If I think that's possible, is it legal and how difficult is it?

python – Import language modules for internationalization of applications

I'm thinking about importing separate language modules (or configuration data) to use when selected by the user. Everything else except the displayed texts should stay the same, and (I think) this should help save disk space since only the language being used is imported and read.
Below is a sample code:

en.py

text1 = "Good morning"
text2 = "This is a test"

de.py

text1 = "Good morning"
text2 = "This is a test"

main.py

language = input ("Choose your language:")

if language == "en":
To attempt:
del.py
from en.py import *
elif language == "de":
To attempt:
del en.py
from de.py import *

# Main program here
print (text1)
print (text2)

In the above example, each language module used is exported when a language is selected, and the language to be used is imported.
I realize that importing modules into the mid-code is often considered bad practice. Would this be acceptable or is there a smarter way to do it?
I mainly want to store memory and processing in this way.

asp.net core – How are two web applications combined in Visual Studio?

I have two different web applications as different projects (solutions). Both use the same version of the ASP.NET core backend. Both projects are perfectly structured and run without problems. A web application is a forum. When it is executed, it will be opened in the following path.

localhost: port / forum

Other web applications are normal websites. It opens in the following.

localhost: port

I want to combine these two projects and create a single web application. So if I press a button on the main website, it will be redirected to the forum. But I can not find a way to combine these two projects.

I tried to right-click on the main site solution -> add an existing project and select the forum project solution file. But only one error is displayed ObjectDisposedException, Everything is broken.

New in Visual Studio and I use Visual Studio 2019. Any help is greatly appreciated. Thank you.

Web applications – Does JavaScript stop the execution of a script when a Web Assembly function is called?

I'm pretty inexperienced in web development, and I'd like to spend a lot of time learning JavaScript and Web assembly, because together they seem to be extremely powerful tools. When structuring my projects, should I assume that the V8 engine simply stops executing code when I execute a WASM function from JS, or is it running at the same time?

Applications – Where can I find user data for an app?

I downloaded an app on my phone because I want to remove information from it. It has pages (in picture form, probably PNG) that I need on my computer. I went to the store and clicked on the app. "Space in use" states that the app has a size of 57.27 MB, but I would like the user data to be displayed. I have opened the app that offers the option to download the pages and the download option all pages clicked. The user data is 288 MB and the total size of the pages is probably 200 MB. That is, the pages are in "user data". When I connect my phone to my computer via USB, the following is displayed:

Enter image description here

So, if the images are in user data, from which can I find the "user data" of the app?
Note that this is the name of the app Al-Muhaffiz and it was released by Mahad al-Zahra publications.

Jazakum Allah Khayran,

Which business applications should be backed up regularly?

Many cloud business applications, such as Shopify, Zendesk, etc., do not provide backup and restore capabilities. If the vendor's app is no longer available in a disaster scenario, or if you or your team member makes mistakes with the data, there is often no way to access or reset your data unless you have performed a manual backup.

Some people have suggested to me that, depending on your business, it is often a good idea to manually back up all the apps that are important to you, although I can not imagine that many have the discipline to do so in practice. I wonder then, does your team routinely backup the data on your cloud apps? If so, which apps are taking the time to backup? Shopify, Quickbooks, HubSpot etc.?