Completed

Transferring Google Sheet data into a PDF to send using add-on, Document Studio

Some background

As a psychology practice, we often get clients to fill in questionnaire data in Google Forms. This raw data is then converted into Google Sheets. From here, we have set up some formulas so this raw data is converted into scorable material that we can use to figure out cut-offs and normative results.

For example,

“How happy are you?

Very happy | Happy | Average | Not Happy | Very Unhappy |”

Once we receive the answer for such a this is entered into a ‘Form response’ sheet in Google Forms. Next, we have created a separate sheet within the same workbook which is basically array formulas: e.g. =arrayformula( if( row('Form Responses 1'!N1:N) = 1, 'Form Responses 1'!N1, 'Form Responses 1'!N1:N ) )

From here, we have created another sheet within the same workbook (see below):

This scoring is then added up and made into a total score or a cut-off score etc.

Our problem

We have been using an add-on called ‘Document Studio’ which can grab variables from the ‘Form Responses 1’ sheet and put it into a PDF file which can then be directly sent to our relevant clinicians. While the raw scores often work, the scoring does not (see document attached for screenshots of what we actually receive - it is circled).

The data from the ‘Form responses 1’ worksheet comes through with the variables but the formula data that we have used to score, does not.

Attempted solutions

We have already tried to double check the variables multiple times – the variables are being picked up (see screenshot in attached document). However, they are just not being entered into the template as we want.

You can find our template that we use in Document studio here:

[login to view URL]

For a description with screenshots, please see the attached document.

Skills: Google Sheets, Technical Support

See more: can save entire page pdf format using php, send form data mysql database using php, creating pdf form send data pdf, document studio tutorial, google forms, document studio alternative, document studio vs autocrat, google sheets, document studio markers, document studio help, document studio add-on download, pdf sheet data attached, send data web server using java, data pdf using php, excel sheet data extraction pdf vba, add data sheet data sheet excell, extract fields data pdf using, data pdf excel sheet macro, excel sheet data sharepoint using bdc, send data android app using tcp connection

About the Employer:
( 4 reviews ) St Leonards, Australia

Project ID: #27464474

Awarded to:

sureshkatla

Hi, I understood your concern. I can solve it. I have extensive experience in excel or sheet automations. Moreover, I configured document studio for one of my clients and I know how it works and it's limitations. So, More

$55 AUD in 2 days
(0 Reviews)
0.0

10 freelancers are bidding on average $51 for this job

greatbharat50022

__________________I am available right now______________________ Hi there, Quality and time is my commitment. I read the description and I am sure I can do this task perfectly. I want to say that, I will start right no More

$50 AUD in 1 day
(0 Reviews)
0.0
JohnRikz

I'm a spreadsheets expert. I have checked you doc attached and understood your issue. Whenever you are adding a new row, the reference is shifting with it while you need it to stay locked. Of course absolute reference More

$50 AUD in 1 day
(0 Reviews)
0.0
nakawsar

Hi There I am professional google script developer. I am Highly interested to work on this project. I can solve your problem with google apps [login to view URL] wit will automate the process and even you don't need to use the More

$53 AUD in 7 days
(0 Reviews)
0.0
abhitandan01044

I am a professional computer engineering, game developer, app developer, site, experts no data entry, excel, from filling, etc. I must completed your work within 5 days with correctly honestly.

$51 AUD in 5 days
(0 Reviews)
0.0
lorineatef

Hii I'm lorine I would help you in this project and making this documents isn't that difficult so i gonna make it as fast as i could

$53 AUD in 7 days
(0 Reviews)
0.0
nisgho

Hi, I am having 4 years experience of fixing Google Sheet issues. I am available immediately and 24 x 7 to fix your issue quickly. We can discuss more details over chat. Please provide me the opportunity to assist you More

$50 AUD in 1 day
(0 Reviews)
0.0
(0 Reviews)
0.0
badreddinelahmi0

Hello I have just checked the questionnaire and I am very interested in this offer because I can work well with google sheet and google forms and I have a great experience

$50 AUD in 3 days
(0 Reviews)
0.0
sheetexpert15

I hv understood your req & I can orobide uou with a app script which will help you get the pdf once the answers are recorded

$50 AUD in 3 days
(0 Reviews)
0.0