Google Doc Folder Table View and LastModifiedBy Returning Blank for App Owner but no one else

[Syntria]

Hello!

tld;r - Created an app to make a simple quick-view list of lastmodifiedby for a bunch of files in Google Docs (started the process in a spreadsheet that serves no purpose and I moved the data files/the data folder + tried to edit/delete files from within the app just to see if it would let me and got an error) and now the value of LastModifiedBy anytime my google account edits a file (Same account that's the app owner) returns a false value/blank, but if anyone else edits that same file, it pulls their info fine. 

Let me start by saying I've never tried to program an app before, and this is just a little personal project. Though I've been doing IT consulting/break-fix for 20 years and can usually find/fix obvious SQL/PHP/database errors that are pretty basic. Like a client manually editing cells and including symbols or deleting the < at the start of an html document, lol. I've literally just been spending hours (about 10 so far) trying different combinations of expressions and seeing what kind of outputs I get and reading about if/and/or/true/false/statements and in general enjoying messing around. 

Situation: I have 20 google docs that me and a friend write together in, updating constantly (20-30x each a day in each file, and we 'tag' each other on discord to let the other know we're done and they can take over, to the tune of 500k words in the last few weeks).  As you can imagine, between 20 documents it's easy to miss which one's have been updated or not. Depending on who the doc owner is, and if we're editing lots of other files, the activity tab/sorting by modified doesn't help too much via the google doc view. 

Goal: Create a quick view of the File Name (ideally hyperlinked to the source document), lastmodifiedby to know who last touched it, and it would be fantastic to create some kind of way to pull last modified datetime even if it is using a side-spreadsheet or script to just create a time anytime the value of lastmodifiedby changes. 

ISSUE/ERROR: I was making good progress and feeling pretty good about it UNTIL I was in a preview of the app and I tested out what would happen if I tried to update a document name through the app (had update/add/delete enabled plus the editable box ticked) and oh boy! After receiving an error about how it isn't possible to push changes, I was curious so I tried to delete the file as well, same error (but the file did move to my trash bin it looked like!). Okay, no problem right?

So I go and turn off update/add/delete and switch it to read-only and untick edible. During this time, I was also taking full ownership of all the docs since I only 'owed' half and was an 'editor' on half and that seemed to cause problems. I moved them around to a new folder as well instead of being in 3 different folders and pointing to the root of that one. 

Suddenly, anytime I edit a document now, the value in the table for LastModifiedBy now comes up BLANK. 100% empty. ISBlank comes back as true (I think) but not ISNotBlank(false). Anytime my friend edits it, their information fills in. I spent about 6 hours determined to troubleshoot this myself and wasn't able to figure out where I went wrong. 

Troubleshooting that maybe just made things worse

• Maybe a permission issue from moving the file/folder around/taking ownership of them (I deleted the old data table, renamed the folder I moved, and made a new data table) OR that the error when I tried to edit/delete via the app was some how causing something to be 'stuck' as sometimes I'd get it again when I'd hit sync in the app but never could click on anything.
• I read somewhere about a 'confirmation required' being ticked on for a field can cause some weird stuff (email if changes are made automation?) and I spent hours adding views/automations/tasks and just clicking every field and clearing them, saving, and deleting them again trying to manually 'reset' my account. I signed out/back in, used another computer/browser, Shift+F5, deleted the spreadsheets in appdata, deleted the app, deleted my appsheet account and remade it, removed appsheet permissions from my google account everywhere I could find it and re-added it. Reset google chrome and resigned in fresh. 
• I tried remaking the app fresh 3x and tried different combinations of cloud/server appdata saving settings/permission settings. I invited myself to edit the app even though I was the owner of it just to see if that might break something free. Same issue - when I edit Docs the lastmodifiedby returns as false/empty, but if anyone else edits it, their information pulls up just fine. 

[Syntria]

Additional Observation

I created a new folder in the root of Google Drive, moved all the file sto the root. I created a new table, pointed it at the new folder, and went in and created a singular new doc. This resulted in success! I moved in one doc from the root to this new folder, synced, success! 

HOWEVER

I moved in another doc. After 3-5 minutes it did not populate even after repeatedly hitting sync. I went in and clicked into the doc via Google Drive to 'wake it up' or rather 'make it acknowledge me' in some way, though I did not edit it (my friend is still the last person to modify it last). 

Broke. 

Is this a meta data issue? Permission issue? Is this an issue with a limitation of lastmodifiedby/appsheets and google folder data? 

I'm going to repeat the setup to get it 'working' and then have my friend (Secretly) edit one of the docs that's in the folder/while it appears to be pulling meta data properly and see if suddenly tops pulling a value when my name (Synplay) is the last person to have edited it. If it continues to work properly, I'll edit the doc again and see if it breaks it. If it doesn't, I'll move in an additional file that's known to cause it to break once I open that file in that folder (matchmaking in this case). 

Untitled Doc - was created in that folder by me as a first test
The Fog - was created by me a few days ago but was previously in 2 other folders which had various share permissions but my friend had accessed it/modified it but I was the last to modify it prior to moving it into that folder
Matchmaking - Was created by me but was last edited by my friend when I moved it into the folder. Did not show up within the app via syncing for several minutes until I went to click the file in google drive to access it (But not edit it) and things broke.