So I am working on an app that generates an estimate for repairs across several sections of a property (kitchen, bath, HVAC, etc.) As the user fills out the quantities (2 sinks, 4 doors, etc) the calculations are made down a column. like so
Then what i am doing is a Joined list of the loggedin users estimates across the sections and then I split the joined list totals like so.
Then on the front end, a user profile has a button which sets columns from the USC to a column on the User sheet which sends the totals to a cell on their row.
What I am then doing is creating a template column to create an email (currently markdown) that imports that array pushed to the User sheet into an email. So here is my problem…
- I need somewhere in this process to be able to convert the array into something more readable like a table or even well organized with line breaks between the sections but when i add
they end up being stringed with the array and the email looks like garbage.
- Am I going about this the wrong way? In the end I would like a list of generated estimates viewable by admins. Because the values are all user specific, getting them over back into the user sheet as a non-USC required a workaround but that workaround produces something like this:
instead of something like this: