How to acess transformer in pdf content

[Bilal_Anjum]

Continuing the discussion from Use PDF Exporter to print content of table:

Hi @Kabirdas How to access transformer data into pdf content
Have a look what is the problem here ?

[edurmush]

Hello @Bilal_Anjum,

First you have to create a transformer

You can find more information about transformers:

Transform data with JavaScript | Retool Docs

[Bilal_Anjum]

I have attached the screenshoot. The code I have written is a transformer of PDF QUERY. Kindly follow the link

Use PDF Exporter to print content of table

Hey @AlanT and @PatrickMast! The comment by @rferland above (this one) gives context for the solutions here. You can do this by creating a standalone transformer that looks something like: const source = {{ table3.data }} // <--- this is where you'd pass your table data! const isNumber = (value) => typeof value === 'number' && isFinite(value) const convertToMarkdown = (data) => { const headers = [Object.keys(data[0])]; const breaks = [headers[0].map((fieldName) => isNumber(data[0][fieldNam…

& then read my question again.

[edurmush]

Hello @Bilal_Anjum again,

I think we are talking about the same thing but in different way.
@Kabirdas says you can use standalone transformers that i also show you how to do that.

[Bilal_Anjum]

Thanks for your kind feedback @edurmush but why would I create another transformer while the query has its own.

Can u please update the code. just return the value from query's transformer & access it in PDF content.

Thanx

[mbruijnpff]

@Bilal_Anjum ,
The transformer in the query is to transform the result of the query, not to create/transform the data being used by the query.

So you’ll need a separate transformer.

[Bilal_Anjum]

Hmm thanx @mbruijnpff for the answer.
Can you please tell me if we can define the width of the column (excel sheet) through some script from retool

you can see columns are not properly visible, can we apply any style or width to the downloaded columns ?

[mbruijnpff]

Not with the default Retool options, but you might be able to do this using another Excel JS library available on various CDN's. I haven't used them, but there are some examples here on the forum.