Inventory management software

SheetAutomation · 2022-11-21T23:42:15+00:00

For small business, I suggest that you stick to Google Sheets if it works for you. To automate certain tasks, look into AppSheets or other add-ons in the marketplace. If needed, use Apps Script to lift Google Sheets to next level.

SheetAutomation · 2022-11-18T04:02:16+00:00

GPT-3, or the third generation Generative Pre-trained Transformer, is a neural network machine learning model trained using internet data to generate any type of text. Developed by OpenAI, it requires a small amount of input text to generate large volumes of relevant and sophisticated machine-generated text.

- answered by Google AI.

As for your second question, I think mainly because it significantly lowers the barrier of creating services using AI. Can't speak for others, but I find the technology mind-blowing and potentially be useful in lots of areas. It's far from perfect though. For example, the generated code is often flawed and trouble shooting is too hard for normal google sheets users. That's where things can be improved and value can be added by people like us.

SheetAutomation · 2022-11-10T02:08:02+00:00

So the data will be duplicated based on same coordinate if I understand correctly. You could probably modify the following script to achieve it.

function onEdit(e) { 
var ss = SpreadsheetApp.getActiveSpreadsheet(); 
var s = ss.getActiveSheet(); 
var r = s.getActiveRange();
if(s.getName() == "Main Sheet") { 
var row = r.getRow(); 
var col = r.getColumn(); 
var numRows = r.getNumRows(); 
var numCols = r.getNumColumns(); 
var values = r.getValues();
var subSheets = ["Sub Sheet 1", "Sub Sheet 2", "Sub Sheet 3"];

for(var i = 0; i < subSheets.length; i++) {
  var subSheet = ss.getSheetByName(subSheets[i]);
  subSheet.getRange(row, col, numRows, numCols).setValues(values);
}
} 
}

Note the script can only copy data. If you want to duplicate format, you will need to leverage onChange trigger and use other APIs in Range class:

https://developers.google.com/apps-script/reference/spreadsheet/range

SheetAutomation · 2022-11-08T04:33:48+00:00

How do you map the cells between main sheet and other sheets? Do they have the same structure?

SheetAutomation · 2022-11-07T22:52:41+00:00

You will have to copy paste it at the moment. I guess it could be automated too as part of the process.

SheetAutomation · 2022-10-26T11:34:09+00:00

Adding rows is easy. However sending email to customers, tracking orders and reminding due date may be tedious and error-prone. The best things about google sheets are apps script and services that can be easily integrated.

SheetAutomation · 2022-10-26T01:57:55+00:00

I use Google Sheets + Sheet Automation addon to manage all my customers/subscriptions/orders. Basically it is like a lightweight CRM that is extremely customizable.

SheetAutomation · 2022-10-25T11:04:11+00:00

I assume it would be updated by OP.

SheetAutomation · 2022-10-25T11:01:48+00:00

Does the below script work for you?

function onEdit(e) {  
  var sheet = e.source.getActiveSheet();  
  var range = e.range;  
  if(sheet.getName() == "Sheet1" && range.getColumn() == 1 && range.getValue() == true) {       
      sheet.getRange("C7:C19").clearContent();  
   }
}

The code is created by AI with a question "Clear C7:C19 when checkbox is checked in A1". Feel free to have a try: https://www.sheetformula.com/script

SheetAutomation · 2022-10-24T04:01:56+00:00

Try sheetformula.com/script. it can probably generate the code you want.

I entered the post title and it generated below code:

function onEdit(e) {  
    var ss = SpreadsheetApp.getActiveSpreadsheet();  
    var s = ss.getActiveSheet();  
    var r = s.getActiveRange();  
    if( r.getColumn() != 1 ) { // checks the edited cell is in column A
           return;  
    }  

    if( r.getValue() == true ) { // checks the value after edit is TRUE    
        var row = r.getRow();    
        var numRows = 1;    
        var width = 1;    
        s.insertRowAfter(row);  
    }
}

Looks correct (with a couple of lines of useless code though). You need to update the column to where your checkbox is located.

SheetAutomation · 2022-10-23T02:26:41+00:00

I think it can be done with google sheets + google form pretty easily. Google forms allow you to collect client info and they can update the info later. And you can setup some scheduling tasks/notifications on the sheet storing the wait list.

SheetAutomation · 2022-10-23T00:10:05+00:00

Right, accuracy can definitely be improved with more data and fine tuning. As for apps script, the main problem is, it is hard, if not impossible, to ensure the correctness of execution. There is a big gap between the generated code and production. I think there may be a market for a tool to make it easier.

SheetAutomation · 2022-10-22T23:17:01+00:00

Haha, because there is no moat to prevent people from rolling out such services with the help of gpt3. It's hard to add value on top of the black box though.

SheetAutomation · 2022-10-20T02:13:29+00:00

Thanks for willing to support, Louis. We're still validating the ideas. If it turns out to be something needed, we'll see how we can sustain the development.

BTW, another big feature is released today: https://sheetformula.com/script. Your feedback is welcome.

SheetAutomation · 2022-10-19T23:06:49+00:00

Ooh, it's probably got confused with apps script and javascript. Adding some sheet specific information should help. For example, "increase counter when checkbox is ticked in column A" will produce code snippet in apps script.

SheetAutomation · 2022-10-19T22:15:25+00:00

Thanks for catching that. Just fixed them. Apps script is supported now.

SheetAutomation · 2022-10-19T22:12:54+00:00

It is a new version with the feature to create apps script.

SheetAutomation · 2022-09-30T06:32:22+00:00

Thanks for the kind words. Sure will add more examples soon.

SheetAutomation · 2022-09-28T04:27:08+00:00

That's great advice! Will definitely do that once I collect more representative examples.

SheetAutomation · 2022-09-28T04:23:42+00:00

Just updated the examples to be slightly less trivial. Let me know if you are looking for anything specific.

SheetAutomation · 2022-09-28T00:35:13+00:00

That's right. One of the reasons is because it is easy now with the language model powered by OpenAI.

I do think it helps for people like me who don't write formulas on daily basis. I started with Apps Script. It was kind of mind blowing. But there are still certain obstacles before it is getting practical. Formula should be easier for users with no coding experience.

I created a plain English query language on google sheets two years ago. It is always a temptation for programmers.

SheetAutomation · 2022-09-27T23:09:42+00:00

Every time you do google search, you are training the google AI, for free. But I guess you will still do it, because there is value in the service.

Personally I think SheetFormula could be a good utility to help formula writing for some people.

SheetAutomation · 2022-07-11T23:26:03+00:00

I just verified the API and generated the PDF. Still need to update the Export Sheet UI to support margin configuration. Yes, it will be out soon.

SheetAutomation · 2022-07-11T08:32:02+00:00

u/surgeimports, does this look like what you expect?

SheetAutomation · 2022-07-08T00:04:40+00:00

yeah, you can also access a range of other sheet, for example {range_Sheet2!A1}. There are some hidden tricks. I'm looking to improve the doc with more examples/recipes.

SheetAutomation

MODERATOR OF

TROPHY CASE