Unusual file formats within your everyday document management and editing processes can create instant confusion over how to edit them. You might need more than pre-installed computer software for effective and quick document editing. If you want to edit sheet in VIA or make any other simple change in your document, choose a document editor that has the features for you to work with ease. To deal with all the formats, such as VIA, choosing an editor that actually works properly with all kinds of files is your best choice.
Try DocHub for efficient document management, regardless of your document’s format. It has potent online editing tools that streamline your document management operations. It is easy to create, edit, annotate, and share any file, as all you need to access these features is an internet connection and an functioning DocHub profile. Just one document tool is all you need. Don’t lose time switching between various applications for different files.
Enjoy the efficiency of working with a tool designed specifically to streamline document processing. See how effortless it is to modify any document, even when it is the very first time you have worked with its format. Register an account now and improve your whole working process.
[Music] in this video were going to cover the on edit function in google apps script the on edit function allows you to automatically do something based on an edit that gets made to a cell in your sheet and in this case what we want to do is perform the on edit function to perform an action when we make an update to a single cell that we specify so what you see here is what were actually going to build today to the left i have a data set of loan records you can see currently it goes down to row 51. to the right we have a place to input new records and in this last cell in this range here once we update this loan amount what the on edit function will do is add this new record to the bottom of our existing data set so in this cell here i have an automatic max function that takes the max of the loan ids in column a and just adds one to it to get the next sequence and in this cell here i just have a drop down to select the branch and drop down to select the loan type so after i key in a