• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Need help to add a number in a spreadsheet

Status
Not open for further replies.

Carlos Melo

Member
Hello,

I have a question that I can't find a solution to.
I need to add a number in column A of a spreadsheet, every time this spreadsheet receives new data in the next empty row. This is data that arrives via the JotForm form.
The column A will be the only one that will not receive data from the form, precisely so that I can insert a number in it.
This number must always correspond to the line number where that new data enters.

1720650313713.png




I've already tried using the Code app, searching for the code on Open Ai, but I don't know how to ask the chatbot, and so it always sends me something that doesn't work.

On the other hand, if you can configure the spreadsheet to add this number automatically, through a simple formula in the column (e.g.: value of the number in line 2 + 1 = insert the number 3 in line 3) perhaps is the simplest way, but I don't know how to do that either.

Thanks for any help.
 
Last edited:
P

Pabblymember11

Guest
Ok, but in my case should I use the step 3 of your sample (Extract Pattern) too ?
Yes, that will be required to pass in the Range and in the Value field to update the cell value. Please review the shared workflow again for your better understanding.
 
Status
Not open for further replies.
Top