Bulk Edit Formula

Bulk Edit Using Formula

Install Bulk Edit Formula

bench get-app https://github.com/manavmandli/bulk_edit_formula

Add the Frappe Gems badge to your README

Maintain Bulk Edit Formula? Paste this into your README:

[![Listed on Frappe Gems](https://frappegems.com/api/method/frappe_gems.seo.badge?app=manavmandli%2Fbulk_edit_formula)](https://frappegems.com/gems/apps/manavmandli/bulk_edit_formula)

About Bulk Edit Formula

🔢 Formula Based Bulk Update for ERPNext

A handy little extension to make bulk updates in ERPNext more powerful 🚀. Instead of entering only static values, now you can apply formulas directly while updating fields.

https://github.com/user-attachments/assets/32aff3bb-e513-4c82-9165-bcbdb8da5ad3

✨ What You Can Do

✅ Perform quick arithmetic operations on existing values

✅ Reference the current field value with current

✅ Avoid repetitive manual updates during bulk changes

🛠️ Usage Examples

Input Formula Effect Example (if current = 1000)
=*1.1 Multiply current value by 1.1 → 1100
=+500 Add 500 to current value → 1500
=-200 Subtract 200 from current value → 800
=/2 Divide current value by 2 → 500
=%3 Take remainder when dividing by 3 → 1
=(current+1000)*1.05 Custom formula with current reference → 2100

🚀 Getting Started

  1. Get the app & Install on your site:
    ```bash $ bench get-app https://github.com/manavmandli/bulkeditformula.git

    $ bench --site yoursite install-app bulkeditformula

  2. Add the helper function into your custom app or script

  3. Use =your_formula in bulk update — and watch the magic happen 🎉

🙌 Contribute

Have an idea to extend this (like supporting multiple fields, or advanced operators)? PRs and feedback are always welcome ✨

🔗 Connect

If you find this useful, ⭐ the repo and share your experience — it really helps!

Related Other apps for Frappe & ERPNext

  • Erpnext — Free and Open Source Enterprise Resource Planning (ERP)
  • Helpdesk — Modern, Streamlined, Free and Open Source Customer Service Software
  • Print Designer — Visual print designer for Frappe / ERPNext
  • Ctr — CTR模型代码和学习笔记总结
  • Whitelabel — Whitelabel ERPNext
  • Fossunited — fossunited.org
  • Helm — Helm Chart Repository for Frappe/ERPNext
  • Frappe Attachments S3 — A frappe app to upload file attachments in doctypes to s3.