Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

estudio contable ¿como puedo sincronizar un calendario de vencimiento de impuestos y clientes?

Tengo un calendario de vencimientos por impuestos de distintos clientes que me salen por una aplicación(errepar), como puedo adaptarlo a trello sin estar copiando uno por uno de los clientes a cada fecha del calendario de trello? graciasCaptura.PNG

1 answer

0 votes
Iain Dooley Community Leader Mar 08, 2019

@pablo corvalan From Google Translate:

Puede copiar y pegar desde filas en una hoja de cálculo a una lista de Trello y automáticamente creará una tarjeta para cada fila:

https://www.laptopmag.com/articles/create-trello-cards-from-a-spreadsheet

Pero esto no establecerá las fechas ni hará nada más con los datos. Si desea importar la hoja de cálculo y establecer automáticamente las fechas de vencimiento en la tarjeta, eso es algo que debería hacer usando la API.

Creé una biblioteca para automatizar Trello con un script de Google Apps llamado Trellinator que se adapta bastante bien al propósito de importar datos de hojas de cálculo a Trello, pero necesita conocimientos de codificación para que funcione:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

English original for reference:

You are able to copy and paste from rows in a spreadsheet into a Trello list and it will automatically create a card for each row:

https://www.laptopmag.com/articles/create-trello-cards-from-a-spreadsheet

But this won't set the dates or do anything else with the data. If you wanted to import the spreadsheet and automatically set due dates on the card, thats something you'd need to do using the API.

I created a library for automating Trello with Google Apps Script called Trellinator that is pretty well suited to the purpose of importing spreadsheet data into Trello, but it needs some coding knowledge to make it work:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

261 views 8 16
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you