I using DocAutomator

Ask for Help
1

I am using DocAutomator to generate PDF. But does anyone know how to view as image from URL?
As we know we can use formula =image(URL) if we are using Google Sheet.
Unfortunately, DocAutomator only using Google Doc.
Great if you guys can help!

2

@Rupert

3

Since you tagged him, then i know where to explore.
Hence, i found this article.

Thanks for your help @Hassan_Nadeem !!

1 Like
4

Thanks for tagging @Hassan_Nadeem !

@biha, let me know if you need help. Best place is DocsAutomator’s in-app chat :slight_smile:

1 Like
5

But let say I have a split column then how can i show in document for each value separately .

6

Great if you can help!

I need to show in results column.

image
image749Ă—474 22.5 KB

But in Glide, it store like this:

image
image777Ă—147 21.3 KB

7

You will need to have a unique column for each value. If you have 10 values then generate 10 columns. Use the splice array column. The first one should have the value 0 and then 1. The next 1 then 2, etc… This will return 1 value for each column.

However, you now have 10 single element arrays. You then need to convert the single elements into text. So you will need another set of 10 columns. This time each column should be a joined list column, where you convert each element into text.

image
image458Ă—670 22.3 KB

image

8

i cross my mind to do like this but i have literally 70 value :rofl: :rofl:

1 Like
9

What is the end result that you need to pass to Docs Automator? (I’ve not used it yet, so I’m not familiar with what it expects).

10

image
image749Ă—474 22.5 KB

image
image722Ă—480 25.5 KB

Its something like this , answer of the inspection checklist. its around 70 questions for all parts depending on the type of inspection.

11

Yes, but I mean what do you actually need to send to Docs Automator?
A JSON Array?
A Joined List?
Something else?

12

Oh sorry, misunderstand your question.
Joined list. yes

13

You already have a Joined List, right?
You need to translate the values to something else?

14

image
image881Ă—261 43.5 KB

Correct, i do have.
So the first question will be TRUE, same with question 2, 3 and 4.
The TRUE i need to reflect in Document

15

Hi @biha, is the table dynamic aka do the number of rows / items included vary? OR are they static, meaning the same rows are always present?

16

Hi @Rupert !

Some static, some dynamic.
Because there’s few tables.

17

Thanks. Static values (Q1, Q2, …) will have to come from a single column. Meaning you will have to have a single column for Q1, one for Q2, … it seems like you’re looking these values up from another table. You’re then passing these values in the integration to DocsAutomator.

Dynamic values will have to be formatted via a joined list and then turned into an array. Please see “line items” or “multiple line items” in the article you shared above.

Happy to help with the syntax :slight_smile:

1 Like
18

Thanks for your reply!
Meaning its same with what @Darren_Murphy mention above?
Am i right?

19

That I’m not 100% sure about. Let me know if you need further help! You can also reach out in the chat in DocsAutomator.

20

I’m not quite familiar with this case, but wouldn’t it be easier to construct a HTML table inside Glide then pass the full thing over? Is that something you can render?