Images are not loaded

[Luiz Alexandre]

Good afternoon!
Even following all the tips in this group, I can't transfer the generated image to the documents in Google Docs, I've already left it loose and in the table but it doesn't load the generated image or the generated images.
Any tips?
The formulas used follow:
=arrayformula(IFERROR(split(if(row(A:A)=1;"IMAGEM_1,IMAGEM_2,IMAGEM_3,IMAGEM_4";T:T);",";TRUE;TRUE);" ")) "Here I separate the files sent via google form"
=arrayformula(iferror(split(if(row(A:A)=1;"ANNEX_1,ANNEX_2,ANNEX_3,ANNEX_4";substitute(trim(T:T);"drive.google.com/open?";"docs .google.com/thumbnail?sz=w600&"));",";TRUE;TRUE);" ")) " Here they generate the images"
The entire shelf normally loads only those photos that are not loaded in the generated document.
Any tips or suggestions?

[Joseph Schmidt]

Are these photos submitted via a Google Form?

I don't understand "The entire shelf normally loads only those photos that are not loaded in the generated document."  What is a shelf?

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/2f69446e-2daf-4a45-909b-4a7922e2db8bn%40googlegroups.com.

[Luiz Alexandre]

Essas fotos são enviadas por meio de um Formulário Google? 

Resposta: sim (sim)

Não entendo "A estante inteira normalmente carrega apenas as fotos que não estão carregadas no documento gerado." O que é uma prateleira?

Resposta: Desculpe quis dizer que as colunas geram os links das imagens e elas não carregam no documento. Eu já tentei colocar dentro de tabela e solto no documento, no autocrat recepciona todas as referências no documento que será preenchido pelos dados lançados na planilha após terem sido lançados no formulário google.

Joe Schmidt

[Joseph Schmidt]

Are you sure the folder contains the photos is shared with anyone with the link?

Do you get any error messages?

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/4de7ea8c-a012-4b6b-a445-29c31da783f6n%40googlegroups.com.

[Luiz Alexandre]

Segue a parte do documento onde deveria aparecer a imagem ou as imagens

[Luiz Alexandre]

Sim, a pasta que contém as fotos ou imagens está na mesma pasta onde são gerados os novos documentos

[Luiz Alexandre]

Não recebo nenhuma mensagem de erro!!

[Luiz Alexandre]

Segue a tela com os links gerados pela formula e pelo autocrat, porém mesmo o autocrat reconhecendo a referencia no docs não carrega nenhuma imagem lá.

[Joseph Schmidt]

Can you share the link created by the formula for one of the photos.

Do the merge tags for the photos show in the third step?

Copy one of the links to an incognito window in chrome and see if it returns the photo.

On Sun, Nov 5, 2023, 7:18 PM Luiz Alexandre <luij...@gmail.com> wrote:

Não recebo nenhuma mensagem de erro!!

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/97188262-b25e-418f-a66c-b85fa75da182n%40googlegroups.com.

[Joseph Schmidt]

I see an error in the fourth column added be Autocrat.

Also, the link doesn't have the word "thumbnail".

That indicates to me that the formula didn't work.

Are you in a country that uses a semicolon where we use a comma in the United States?

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/f2c94254-9f1c-4c6e-8f7c-653fc9fb391an%40googlegroups.com.

[Luiz Alexandre]

Are you in a country that uses a semicolon where we use a comma in the United States?

Resposta : Sim!! Yes!!

That indicates to me that the formula didn't work.

Resposta: Esta formula não me apresentou nenhum erro.

=arrayformula(iferror(split(if(row(A:A)=1;"ANEXO_1,ANEXO_2,ANEXO_3,ANEXO_4";substitute(trim(T:T);"open?";"thumbail?sz=w300&"));",";TRUE;TRUE);" "))

[Luiz Alexandre]

Na ultima coluna gerada pelo autocrat ele me apresenta o seguinte texto:

Document successfully created; Invalid image URL [https://drive.google.com/file/d/16_uofRYT90lvVis3labTnuiLP7Ke_R3G/view?usp=drive_link], make sure that it is public; Invalid image URL [ https://drive.google.com/file/d/1SidhkOBQwPLlAgtJfXFIJIMfYQpq6hqO/view?

Em domingo, 5 de novembro de 2023 às 21:43:28 UTC-3, Joseph Schmidt escreveu:

[Luiz Alexandre]

Can you share the link created by the formula for one of the photos.

https://drive.google.com/file/d/16_uofRYT90lvVis3labTnuiLP7Ke_R3G/view?usp=drive_link

Do the merge tags for the photos show in the third step?

Não entendi a pergunta. 

[Luiz Alexandre]

I see an error in the fourth column added be Autocrat.

Resposta : Esse aqui?

Document successfully created; Invalid image URL [https://drive.google.com/file/d/16_uofRYT90lvVis3labTnuiLP7Ke_R3G/view?usp=drive_link], make sure that it is public; Invalid image URL [ https://drive.google.com/file/d/1SidhkOBQwPLlAgtJfXFIJIMfYQpq6hqO/view?usp=drive_link], make sure that it is public; Invalid image URL [], make sure that it is public; Invalid image URL [], make sure that it is public; Document successfully merged; Run via time trigger as luij...@gmail.com; Timestamp: Nov 5 2023 7:49 PM

Como corrijo isso?

Em domingo, 5 de novembro de 2023 às 21:43:28 UTC-3, Joseph Schmidt escreveu:

[glua...@gmail.com]

The files were shared with me and Google uses a different format for the URL than it does in the United States.  

The formula had to be adjusted.  Once adjusted, the photo merged.

=arrayformula(iferror(split(if(row(A:A)=1;"ANEXO_1,ANEXO_2,ANEXO_3,ANEXO_4"; substitute( substitute(trim(T:T);"drive.google.com/file/d/";"docs.google.com/thumbnail?sz=w300&id="); "/view?usp=drive_link";"") );",";TRUE;TRUE);" "))