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.
bulk_update.mp4
✅ Perform quick arithmetic operations on existing values
✅ Reference the current field value with current
✅ Avoid repetitive manual updates during bulk changes
| 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 |
-
Get the app & Install on your site:
$ bench get-app https://github.com/manavmandli/bulk_edit_formula.git $ bench --site yoursite install-app bulk_edit_formula
-
Add the helper function into your custom app or script
-
Use =your_formula in bulk update — and watch the magic happen 🎉
Have an idea to extend this (like supporting multiple fields, or advanced operators)? PRs and feedback are always welcome ✨
If you find this useful, ⭐ the repo and share your experience — it really helps!