Writing a script for self-editing tables in Google Spreadsheet
Posts automatically during publication arrive in the Spreadsheet through the Zapier automation.
on the columns:
1 . Date of publication
2nd Days from the date of publication (today you have to stretch the formula [ =TODAY()-first column ] manually)
Three Signature as a whole
4 . Photo in the form of reference
and 5. Link to post
What is required:
1 . Without changes
2nd Automatically count the days from the date of publication
Three From the signature to leave only @tags (there may be more than one; with keeping order as in the signature)
4 . Automatically turn the link to the formula =IMAGE(...") so that it becomes an image.
and 5. Without changes
And also automatically sort the table by the second column (Days since published) from the freshest to the oldest.
Work results
Client's review of cooperation with freelancer
Writing a script for self-editing tables in Google SpreadsheetThank you ! Fast and adequately
Freelancer's review of cooperation with Vassili B.
Writing a script for self-editing tables in Google SpreadsheetВсе Супер рекомендую!
Была ошибки с моей стороны и заказчик адекватно отреагировал.
Буду рад дальнейшему сотрудничеств
![]()
Current freelance projects in the category Javascript and Typescript
Need a frontend developer / layout designer for a one-time improvement of a website on Magento 2.
285 USD
Website for evaluation: https://copy.eurobrands-shop.de/ Task: fix frontend bugs at the Magento 2 / Amasty theme level: CSS/LESS/JS, mobile, RTL, minicart, language dropdown, layout shift/CLS. Work format: - without local Magento deployment; - work through DevTools + theme… HTML & CSS, Javascript and Typescript ∙ 1 hour 36 minutes back ∙ 15 proposals |
Game Developer Pixi.Js
350 USD
We are looking for a Pixi.js developer to create a series of 12 mini-games. The projects are simple to implement, and with confident work, developing one game takes no more than a week. It is necessary to implement the frontend and game mathematics, without backend development.… Javascript and Typescript, Web Programming ∙ 4 hours 3 minutes back ∙ 29 proposals |
Optimization of Core Web Vitals (OpenCart) for Google PageSpeed — Mobile and PC versionsOrder description: We are looking for an experienced frontend developer/OpenCart specialist to optimize the loading speed of the website (categories and product cards) according to Google Core Web Vitals requirements. About the project: * CMS: OpenCart. * Specifics: The site… Content Management Systems, Javascript and Typescript ∙ 4 days 1 hour back ∙ 23 proposals |
Optimization of WordPress site speed
114 USD
We will send full details in private messages Goal Maximize website loading speed, especially on mobile devices. KPI (mandatory) After the work is completed, the following metrics must be achieved. Mobile Performance 90+ LCP less than 2.2 sec INP less than 200 ms CLS less than… HTML & CSS, Javascript and Typescript ∙ 4 days 20 hours back ∙ 68 proposals |
Looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition.There is a working, well-designed project on Odoo 19 Community — CRM for a Ukrainian hotel, already in production-grade infrastructure. We do not plan to rewrite from scratch. We are looking for one person who will take over the project, maintain the working state, and lead it… Javascript and Typescript, Web Programming ∙ 6 days 22 hours back ∙ 4 proposals |