基本信息

更新日期:
版本:
最新版
类型:
套件
平台:
Chrome
评分:
322
发布日期:
2020-08-10
价格:
免费
开发者:
New Visions Cloudlab

插件截图

【图】Copy Down(截图 0)

插件简介

Copy Down adds functionality to Form-fed Google Sheets — the ability to have row 2 formulas auto-copied into form submission rows.

copyDown adds a simple but revolutionary functionality to Google-Form-fed Google Sheets — the ability to have formulas and cell formats carry into new form submission rows.

With this ability, any Google form submission can auto-calculate subtotals, perform a vertical lookup against another sheet, include conditional formats or data-validation lists in new form rows, or calculate a count or countif tied to a cutoff threshold — and these are just a few examples — don’t get us started!

Use in combination with the autoCrat or formMule Add-ons for Sheets to bring calculated values and formatted numbers and dates into your form-triggered document and email merges.

IMPORTANT: Due to limitations of Apps Script, copyDown is NOT COMPATIBLE WITH SPREADSHEET FILTERS on the form response sheet.

Learn more about…

autoCrat Add-on
http://cloudlab.newvisions.org/add-ons/autocrat

formMule – Email Merge Utility Add-on
http://cloudlab.newvisions.org/add-ons/formmule-email-merge-utility

更多...

相关插件

插件下载

插件商店

插件评论

用户

it's better that can support muti sheets

用户

good support

用户

I think this happens when you sort the rows by other columns different from the TimeStamp Column

用户

Good

用户

weird but cool

用户

It's great...when it works. CopyDown provides a solution for a very common problem. The only issue is that it does not always work properly. For some reason, it skips rows randomly and won't paste the formulas there. Disappointed that there seems to be no reasoning for or solution to this problem. Going to try something different instead.

用户

Very good

用户

Parece que não funciona se a tabela estiver filtrada...

用户

Estoy Probando esta aplicación

用户

Algum problema com o complemento??? parou de funcionar e não está mais aparecendo no menu complementos para poder configurar ele, porém aparece como instalado.

用户

BUEN BUENA

用户

J'avais besoin de cet additif pour reconnaître des informations issues de plusieurs google forms dans mon tableur Sheet afin de les publier dans plusieurs dossiers dans mon DRIVE avec Autocrat sous forme Google Doc. Cela fonctionne superbement à l'aide de la fonction RECHERCHEV qui s'active automatiquement dès qu'un nouveau formulaire arrive sur une ligne de mon tableur Sheet (ce qui n'est pas le cas sans utiliser CopyDown). Le problème est que Copydown ne fonctionne que sur une seule feuille (onglet). J'ai vérifié cette information dans la foire aux questions du développeur. Comme j'ai plusieurs Google Forms publiés dans le même classeur Sheet, je dois trouver une autre solution :-(

用户

Muy buena, la recomiendo

用户

can't work. i have edit rights "Oops! It appears you don't have edit rights on the attached form. copyDown can only work with Forms that you have editing rights on."

用户

Copy Down Add on not highlighted in Google Sheet. Whats the issue?

用户

Just stopped working and now all I have in a spinning wheel

用户

MMMMMMMMMMM CREO QUE

用户

Great when it works. Will just stop functioning and need to be reset. Pretty bad as their is no indication that it stopped unless you manually look as the add on still says "on"

用户

La he usado varias veces y funciona perfecto, Sin embargo la use con otra cuenta y empezó a suceder lo que algunos usuarios comentan. No funcionaba, o no cargaba. Lo que hice, no se si a todos les funcione, es que cerré sesión de otras cuentas de Gmail que tenía habilitadas y solo deje abierta la cuenta que necesitaba habiliatr el complemento. Lo descargue nuevamente, lo configuré, y quedo funcionando. Después ya pude abrir el resto de mis cuentas. No se si crea un conflicto con las demás cuentas que uno tiene.... pero me funcionó. Les dejo por si alguien más le puede servir

用户

It works as expected with automatically copying formulas down the column, but I'm seeing some unusual formatting issues with the spreadsheet after using Copy Down. Some cells become bold, other cells fill color or text color gets changed. And sporadically the Timestamp column format is changed to some long number with a decimal.

用户

Dear expert Im having serious issue with this addon .. it's difficult to explain .. but I could share a video of what's happening but not sure how to link it back to this page. Suggestions.?? Stuart

用户

al dia de hoy no funciona se queda cargando???? muy buena herramienta, la uso en otros archivos y es muy buena

用户

A día de hoy, no funciona.

用户

This function is very good, but it can only detect the first Form sheet, when my project have 2 form sheet inside, the second one can't be detected. Hopefully someday can solve this problem, however, many thanks !

更多...