New

Joomla-Daten in Formulardaten von Exceltabellen implementieren

Thursday, April 20 2023

3 Replies

118 Visits

Hallo,

wir haben eine Exceldatei, in der per Formel URLs mit URL-Parametern generiert werden. Ein Teil der generierten URL enthält Artikel-IDs von Joomla. Am Ende wird also eine URL generiert, die in etwa so aussieht: https://www.domaintld/page?t=12&r=54&m=75&utm_medium=offline&coupon=XMAS. Kann ich in der Exceldatei anhand der generierten IDs in der generierten URL für die Parameter t, r und m die entsprechenden Artikel-ID-Inhalte in bestimmte Zellen geladen werden? Also Content der Artikel-ID 12 in eine Zelle, Content der Artikel-ID 54 in eine Zelle etc.

Vielen Dank vorab!

Viele Grüße
Thomas

Assistance

1 year ago

#18821

Hi,

Thanks for contacting us here about this extension.

It is possible to sync an Excel sheet to Droptables extension, but only the resulting data will be synced.
The function cannot be viewed in Droptables. For more information, please refer to the attachments I have provided.

Cheers,

gdirect

1 year ago

#18822

Thank you very much, the formula doesn't need to be synced, only the results. We hosting our sites by ourselves and using proxy server. Is it possible to with that setup and does that work with Microsoft Teams Excel online?

greets

Assistance

1 year ago

#18826

Hi,

Thanks for your response.

the formula doesn't need to be synced, only the results. We hosting our sites by ourselves and using proxy server. Is it possible to with that setup and does that work with Microsoft Teams Excel online?

Unfortunately, Droptables supports Google Sheets only at the moment.
We will consider this in the future version.

Thanks a lot!
Cheers,

Page :
1

There are no replies made for this post yet.