error/ complications in alignment when creating a dynamic report

16 views
Skip to first unread message

Burhanuddin Kutub

unread,
Jun 3, 2025, 8:08:32 AM6/3/25
to Google Apps Script Community
Dear Community,
my use case is creating a dynamic medical report from a form submission,
the data is divided into 2 parts,

1. the data is in a table as i wanted a the alignment and formatting right and mainly because the values will be cumpulsory and therefore wont need any dynamically adjusting feature.

2. is the laboratory section , where the script will dynamically change according to the test done,
if the test has a result the test name will be shown otherwise the line will be removed,
if the entire category doesnt have any results of the tests, the entire category will be removed and the empty spaces will be replaced by tests that do have results.

the alignment/formatting works well for the
main category (to the left)
test name (in the middle)
but fails to align/format the {variables}

i created individual variable to also try and find the sweet spot for the variables to align but failed.

i tried moving to creating a dynamically creating table, but have got too many errors to switch,

Link to the google docs template

Link to the appscript

Looking forward for your help.

Thanking you.
Burhan.

Reply all
Reply to author
Forward
0 new messages