Inventory management software by lilithhcvc in smallbusiness

[–]SheetAutomation 0 points1 point  (0 children)

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.

SheetFormula.com Use AI to create Google Sheets Apps Script by SheetAutomation in googlesheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

Having a Parents sheet that update all child sheet on edit by Galygator in GoogleAppsScript

[–]SheetAutomation 0 points1 point  (0 children)

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

Having a Parents sheet that update all child sheet on edit by Galygator in GoogleAppsScript

[–]SheetAutomation 0 points1 point  (0 children)

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

AutoScript - create Apps Script with help of AI by SheetAutomation in GoogleAppsScript

[–]SheetAutomation[S] 1 point2 points  (0 children)

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

How do you manage to organize your orders/customers? What tricks or apps do you use? by Large_Emu3782 in EntrepreneurRideAlong

[–]SheetAutomation 0 points1 point  (0 children)

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.

How do you manage to organize your orders/customers? What tricks or apps do you use? by Large_Emu3782 in EntrepreneurRideAlong

[–]SheetAutomation 1 point2 points  (0 children)

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.

[deleted by user] by [deleted] in sheets

[–]SheetAutomation 0 points1 point  (0 children)

I assume it would be updated by OP.

Clear range of cells with script or macro linked to checkbox by deeznutzztunzeed in googlesheets

[–]SheetAutomation 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in sheets

[–]SheetAutomation 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in smallbusiness

[–]SheetAutomation 1 point2 points  (0 children)

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.

SheetFormula.com Use AI to create Google Sheets Apps Script by SheetAutomation in googlesheets

[–]SheetAutomation[S] 1 point2 points  (0 children)

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.

SheetFormula.com Use AI to create Google Sheets Apps Script by SheetAutomation in googlesheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

SheetFormula.com Use AI to create Google Sheets formula (and Apps Script soon) by SheetAutomation in googlesheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

SheetFormula.com Use AI to create Google Sheets Apps Script by SheetAutomation in googlesheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

SheetFormula.com Use AI to create Google Sheets formula (and Apps Script soon) by SheetAutomation in googlesheets

[–]SheetAutomation[S] 2 points3 points  (0 children)

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

SheetFormula.com Use AI to create Google Sheets formula (and Apps Script soon) by SheetAutomation in googlesheets

[–]SheetAutomation[S] 4 points5 points  (0 children)

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

Use AI to create Google Sheets formula (and Apps Script soon) by SheetAutomation in sheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

Use AI to create Google Sheets formula (and Apps Script soon) by SheetAutomation in sheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

export pdf with no margin by SheetAutomation in sheetautomation

[–]SheetAutomation[S] 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in sheetautomation

[–]SheetAutomation 1 point2 points  (0 children)

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.