List of related questions and answers «Working with files and data»
Does not export data to Google Sheets
Congratulations! They made the settings, as if everything is ok. We don't understand what else is needed because the data is not exported to Google...
Formula for calculating the sum of values from an array.
Good day. There is a file in one column of the category in another numeric values. I am looking for a way to get the sum for each value. I tried "V...
How to copy a file to an additional field
I have a file in the attached files and I need to copy it to an additional field. As I understand it, for this there is an action “Find a file from...
Problems with the work of formulas and conditional formatting in the table after deleting the script
After adding a script that controlled the transfer of the number from one sheet to another, and then removing it, the table had problems with the f...
finalize the option "do not update business process and process status after download"
please complete the automatic action "Import data from Google spreadsheets (Google Spreadsheet)" so that when updating processes (the "Search by pr...
Apps Script in Google Sheets for inserting values into empty cells
Please help me create a script for Apps Script in Google Sheets, which inserts a certain value (for example a dot) into empty cells in a certain co...
Export to Google tables depending on the value of the additional field
There was such a problem when I simply export any process fields to Google Sheets, everything works fine. But as soon as I set the condition for wh...
Import from google tables
There was such a problem when I import some non-existent data from google tables, new business processes are created. In the tables for the test, I...
Files give 404 error.
After some time after downloading, the files give a 404 error. Become unavailable for download and viewing. The screenshots showed that the f...
Calculation formula with condition
Hi all! And a huge thank you to whoever helps me tweak the formula. There are several columns, in the first we select the type of payment (cash or ...
Copyright © OneBox 2024
