Hi guys, I wasn’t sure if this should go into the ‘Showcase’ section but as it is far from complete I felt it better here - feel free to move it if necessary. Anyway, I am currently building a prototype app which will consist of one part of the finished article- my plan is to a) ensure I can do wh…

Hi Jeff, Thanks very much for your response. I have amended the detail relating to my Q1 by using a simple join of data within my spreadsheet - annoyed I never thought of this before as it looks so much better on the app. I have also spent the last couple of hours learning about emoji’s and using…

Hi Jeff, Once again, thanks for your previous response. Really helped me and as I said before your advice regarding my Q’s 1 & 2 lead me to quick solutions for these. I have now (after a weekend of trial and error and lots of learning about inline lists and relations - and maybe the odd scream to r…

Notes aren’t internal. They are still stored in the sheet. For clarification, are the notes visible to all users? If not, then you could probable get away with creating a user specific column to hold the notes that would only be visible to each individual user. If you need them to be visible to …

Thanks again for your response Jeff. In respect of the notes situation, I have decided to just have notes that I would add where necessary and not have any facility for individual users to add notes themselves. I would want any notes I added to be visible to all users though and I guess this leads …

For your Sighted switch, you could create a user specific column in the data editor and assign the switch to that column. This will keep the switch value unique for each user. You or anybody else will not have access to what the user selected for the switch. This would allow for storing values un…

In addition to what Jeff has proposed, I recorded a video here to visualize the process. [image] Hide/Unhide components on sheet visible to all users I attach a video, hope it can help. Basically create a new boolean user-specific column in the Data Editor, then link it…

@Jeff_Hager and @ThinhDinh - that is the perfect solution to my problem. Also may lead me to reinstating my original idea of a user specific notes section as well as I assume that to be the same process? It has lead me to another minor issue with regards to the ‘Haulage’ switch as in my spreadsheet…

Have not experienced that myself, does a setting of row owner solve the switch problem? Would need @Jeff_Hager for this one.

Indeed, I had another read up of a few potential options and a further play around with these options yesterday but had no luck at all unfortunately :frowning:

Here is how I would approach this. I’m assuming that you are also capturing the user’s email when they submit the haulage form. Forgive me for not being familiar with the terminology, so I may get some of this wrong. Hopefully you’ll still understand what I mean. My dad was a brakeman/conductor …

Tips to improve my prototype app

Ask for Help

ThinhDinh May 12, 2020, 12:19am 8

In addition to what Jeff has proposed, I recorded a video here to visualize the process.

Topic		Replies	Views
User Specific Columns + User Profiles Demo Community Resources tutorial	89	5240	May 31, 2020
Long Form guidelines Ask for Help	25	1304	September 4, 2021
Dream features - what’s yours? Feature Requests	122	5609	October 7, 2020
List line items linking to other sheets Feature Requests	55	2807	May 25, 2021
🎤 We'll Do It Live - Episode 5 General	118	2789	July 22, 2021

Tips to improve my prototype app

Related topics