DEV Community: Explorer

🎁 Microsoft Rewards in India: How to Earn ₹500 Gift Cards with Minimal Effort

Explorer — Wed, 13 May 2026 08:41:59 +0000

Can you really earn free gift cards just by using Bing?

Yes—but only if you understand how Microsoft Rewards actually works. In this guide, I’ll break down exactly how much you can realistically earn, how to maximize your points, and whether it’s truly worth your time based on my personal experience.

💡 Quick Summary:

Daily Earnings: ~100–120 points possible.
Monthly Average: 3,000–3,500 points.
Payout: ₹500 reward every ~3 months.
Best Method: Daily consistency + Mobile search + Streaks.

🧠 How It Works

Microsoft Rewards follows a simple, repeatable cycle:
Search → Earn Points → Redeem Rewards

Search with Bing: Earn points for every search on your PC or mobile device.
Daily Activities: Complete quick tasks like the "Daily Set," trivia, or polls on your dashboard.
Level Up: Earn 500 points in a month to reach Level 2, which increases your daily search limits and offers better redemption rates.

💰 Realistic Earning Potential

Based on current rates in India, here is the breakdown:

Daily Search Earnings: Up to 60 points per day via Bing.
Daily Dashboard Tasks: Adding another 40 to 50 points per day.
Monthly Reality: For a consistent user, this averages out to 3,000–3,500 points per month.

💡 My Personal Proof:

I have personally earned around ₹3,000 using Microsoft Rewards so far. In my experience, it takes almost exactly 3 months of consistent daily effort to reach the ₹500 gift card milestone. This translates to roughly ₹2,000 per year for just a few minutes of "work" each day.

🚀 How to Maximize Your Points

✅ The "Hidden" Mobile Edge: Most users earn 50% less than they could because they forget to do searches on the Bing Mobile App. You must do both PC and Mobile to hit the cap.
✅ Maintain Your Streak: Missing just one day resets your "Daily Set" streak. This is a common mistake that costs you massive bonuses, like the 1,000-point milestone for 12 stamps.
✅ Use Microsoft Edge: Browsing through Edge often unlocks "Browser Bonus" points that aren't available on Chrome or Safari.

👥 Boost Your Balance: Refer and Earn

While individual searching is the foundation, the referral system is the fastest way to bridge the gap to your next reward.

Mutual Benefit: When you invite friends via your unique link, you both earn points once they start using the platform.
Bonus Promotions: Keep an eye out for occasional "double referral" months where rewards are significantly higher.
Get Started: You can Join Microsoft Rewards here to start building your first ₹500.

⚠️ Security & Common Mistakes

To ensure you actually get to spend the points you earn:

⚙️ Avoid VPNs: Using a VPN to "farm" points from other countries (like the US) will get your account banned instantly.
⚙️ Human Searches Only: Don't use automated bots. Microsoft’s detection is highly sophisticated.
⚙️ Stick to One Account: Microsoft policies are strict; using multiple accounts on one device often leads to redemption issues.

🤔 Is It Worth It?

If you expect to get rich or replace a job, no. However, if you spend a lot of time online anyway, it is a "no-brainer."

The Unique Insight: Most users fail because they treat it like a chore. The secret is to spend just 2–3 minutes every morning while having your coffee to clear the dashboard. If you do that, you get a "free treat" like a Starbucks coffee or an Amazon discount every few months for zero cost.

🧾 Final Thoughts

Microsoft Rewards is about making your existing digital habits work for you. It’s a simple, honest way to get a little extra back from the web.

Ready to start? Set Bing as your default search engine today and watch those points accumulate!

🛠️ Developer's Guide: Mastering Programmatic Row Injection in Joget Advance Grid

Explorer — Mon, 11 May 2026 13:39:27 +0000

Overview

For developers building complex Joget applications, the Advance Grid (based on PQGrid) offers immense flexibility. While standard data entry is straightforward, there are scenarios—like generating monthly timesheets or project schedules—where you need to programmatically inject dozens of rows and perform real-time calculations. This guide dives deep into using JavaScript, Moment.js, and the PQGrid API to automate grid management.

How It Works

The technical implementation centers on a few core developer concepts:

Date Iteration: Using moment.js to loop through a range.
PQGrid DataModel Manipulation: Accessing the grid's internal dataModel to read and write cell values.
Asynchronous Row Handling: Because UI triggers (like adding a row) take time to reflect in the DOM, we use Promises and setTimeout to ensure data is only written once the row exists.
PQGrid Refresh: Manually updating the .pq-td-div and the underlying hidden textarea that Joget uses to persist grid data to the database.

Where to Use in Joget

Form Builder: Add a Custom HTML element to your form.
Dependencies: Ensure your Joget environment has access to jQuery (standard) and include the Moment.js library via CDN as shown in the code.

Full Code

<input value='Apply' type='button' id="apply" class="form-button" style="float: right;" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js"></script>

<script>
  $(document).ready(function () {
    /**
     * Programmatically sets a value in a specific cell of the Advance Grid
     * @param {Object} grid - The jQuery object of the grid field
     * @param {number} rowIndx - Row index (starting from 0)
     * @param {number} colIndx - Column index (mapping to the columnKey array)
     * @param {string} colValue - The value to be set
     */
    function setValue(grid, rowIndx, colIndx, colValue) {
      return new Promise(resolve => {
        setTimeout(() => {
          var DM = $(grid).find(".pq_grid").pqGrid("option", "dataModel");
          var data = DM.data;

          // Access the hidden JSON string stored in the last column of the row
          var json = data[rowIndx][data[rowIndx].length - 1];
          var obj;
          try {
            obj = JSON.parse(json);
          } catch (e) {
            console.error('Error parsing JSON:', e);
            resolve();
            return;
          }

          var colKey = DM.columnKey[colIndx];
          obj[colKey] = colValue;

          // Update dataModel
          json = JSON.stringify(obj);
          DM.data[rowIndx][colIndx + 1] = colValue; // Index + 1 because column 0 is the row index
          DM.data[rowIndx][data[rowIndx].length - 1] = json;

          // Sync with the hidden table (Joget's persistence layer)
          var indexKey = DM.data[rowIndx][0];
          var tbl = $(grid).find('.table_container table');
          tbl.find("tr.key_" + indexKey).find("[column_key=" + colKey + "]").text(colValue);
          tbl.find("tr.key_" + indexKey).find("textarea").val(json);

          // Update visual UI cell
          var colCell = $(grid).find("tr[pq-row-indx=" + rowIndx + "] .pq-grid-cell[pq-col-indx=" + (colIndx + 1) + "]");
          $(colCell).find(".pq-td-div").html('<div class="subform-cell-value"><span>' + colValue + '</span></div>');

          resolve();
        }, 100);
      });
    }

    $("#apply").click(async function () {
      var gridWidget = $(FormUtil.getField("statusgrid")).find(".pq_grid");

      // 1. Clear existing data and UI rows
      gridWidget.pqGrid("option", "dataModel.data", []);
      $(FormUtil.getField("statusgrid")).find('.table_container table tbody tr.grid-row').remove();

      // 2. Business Logic Validation
      var BillNo = $('select[name="if_bill_exist"]').val();
      if (BillNo !== null) {
        alert("This TimeSheet bill is already Created");
        return;
      }

      var advgrid = FormUtil.getField("statusgrid");
      var fromDate = $('input[name="from_date"]');
      var toDate = $('input[name="to_date"]');
      var newFromDate = moment(fromDate.val(), 'DD-MM-YYYY');
      var newToDate = moment(toDate.val(), 'DD-MM-YYYY');

      var normalHours = $('select[name="normal_hours"]');
      var WeekendOverTimeH = $('[name="weekend_overtime_hour"]');
      var overTimeHour = $('#overtime_hours');

      var selectedCheckboxValues = [];
      $("input[name='select_overtime_hour_type']:checked").each(function () {
        selectedCheckboxValues.push($(this).val());
      });

      var rowIndex = 0;
      var promises = [];

      let sum_of_Normal_working_hours = 0;
      let sum_total_days = 0;
      let sum = 0;
      let weekendsum = 0;
      let publicsum = 0;

      // 3. Row Generation Loop
      for (var date = moment(newFromDate); date.isSameOrBefore(newToDate); date.add(1, 'days')) {
        var dayOfWeek = date.format('dddd');
        var isWeekHoliday = $('#week_holiday_chosen ul li:eq(0)').text().toLowerCase().split(';').includes(dayOfWeek.toLowerCase());

        var hour = (isWeekHoliday || !selectedCheckboxValues.includes('Normal Hour')) ? '' : normalHours.val();
        var day_calc = (isWeekHoliday) ? '' : 1;
        var weekend_overtime_hour = (isWeekHoliday && selectedCheckboxValues.includes('Weekend OverTime')) ? WeekendOverTimeH.val() : '';
        var overtime_hour = (!isWeekHoliday && selectedCheckboxValues.includes('OverTime Hour')) ? overTimeHour.val() : '';

        // Add row via Joget's native icon trigger
        advgrid.find(".ui-icon-circle-plus").trigger("click");

        // 4. Batch Updates via Promises
        promises.push(setValue(advgrid, rowIndex, 0, date.format('MMM'))); // Month
        promises.push(setValue(advgrid, rowIndex, 1, date.date()));        // Day
        promises.push(setValue(advgrid, rowIndex, 2, dayOfWeek);          // Weekday
        promises.push(setValue(advgrid, rowIndex, 3, date.year()));       // Year
        promises.push(setValue(advgrid, rowIndex, 4, date.format('DD-MM-YYYY'))); // Full Date
        promises.push(setValue(advgrid, rowIndex, 5, hour));
        promises.push(setValue(advgrid, rowIndex, 6, day_calc));
        promises.push(setValue(advgrid, rowIndex, 7, overtime_hour));
        promises.push(setValue(advgrid, rowIndex, 8, weekend_overtime_hour));
        promises.push(setValue(advgrid, rowIndex, 14, date.format('YYYYMMDD'))); // Unique ID

        // Aggregate totals for the parent form
        sum_of_Normal_working_hours += parseFloat(hour) || 0;
        sum_total_days += parseFloat(day_calc) || 0;
        sum += parseFloat(overtime_hour) || 0;
        weekendsum += parseFloat(weekend_overtime_hour) || 0;

        rowIndex++;
      }

      await Promise.all(promises);
      Calculate({
        sum_of_Normal_working_hours,
        sum_total_days,
        sum,
        weekendsum,
        publicsum: 0 // logic to be added based on public_holiday field
      });
    });

    function Calculate(obj) {
      $('[name=total_normal_working_hours]').val(obj.sum_of_Normal_working_hours);
      $('[name=total_days]').val(obj.sum_total_days);
      $('[name=total_overtime_hour]').val(obj.sum);
      $('[name=total_weekend_overtime_hour]').val(obj.weekendsum);
    }
  });
</script>

Example Use Cases

📅 Timesheet Automation: Generate a row for every day of the month based on a selection.
📊 Financial Projections: Populate a grid with 12 months of empty rows for budgeting.
✅ Inventory Audits: Generate rows for all items in a specific category to be checked.

Customization Tips

⚙️ Column Keys: Ensure the column keys in the PQGrid dataModel match the order of your setValue calls.
⚙️ Masking/Placeholders: If using database-linked data, replace statusgrid with your specific grid ID.
⚙️ Timeout Duration: The 100ms delay in setValue is a safe buffer; for large grids (50+ rows), you may need to optimize the injection logic.

Key Benefits

✅ Developer Control: Bypass manual entry constraints and manipulate data directly in the grid's memory.
✅ Rich UX: Instant feedback for users with automatic summaries.
✅ Standardization: Enforces date formats and calculation logic client-side.

🔒 Security Note

Since this is a client-side script, developers should treat this as a UX Enhancement only. Always implement Server-Side Validation (BeanShell) to verify that the submitted totals match the grid data, as client-side values can be modified by end-users via the console.

🛡️ Stock Open and Closed Validation in Joget

Explorer — Mon, 11 May 2026 13:24:59 +0000

Overview

Managing stock levels across multiple branches requires strict controls to prevent data duplication. This script provides a validation layer that ensures business rules are followed before a new entry is saved.

How It Works

The script acts as a BeanShell Validator that executes two primary database checks:

Open Status Check: It queries the database to see if any entry for the selected branch is currently marked with a status of 'Open'.
Daily Duplicate Check: It verifies if a record has already been generated for the branch on the current calendar date using the CURDATE() SQL function.

Where to Use in Joget

Form Builder: Attach this script to the Branch Selection field (or the primary identifying field) using the BeanShell Validator plugin.

Full Code

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.apps.form.model.Element;
import org.joget.apps.form.model.FormData;
import org.joget.commons.util.LogUtil;
import org.joget.apps.form.service.FormUtil;

public boolean validate(Element element, FormData formData, String[] values) {
    boolean validationPassed = true; 
    Connection conn = null;
    PreparedStatement preparedStmt = null;
    ResultSet rs = null;

    // Masked Table Name for Security
    String tableName = "app_fd_your_table_name"; 

    try {
        String elementId = FormUtil.getElementParameterName(element);
        DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
        conn = ds.getConnection();

        // 1. Check if a record is already 'Open'
        String query = "SELECT COUNT(*) FROM " + tableName + " WHERE c_status = 'Open' AND c_branch_name = ?";
        preparedStmt = conn.prepareStatement(query);
        preparedStmt.setString(1, values[0]);
        rs = preparedStmt.executeQuery();

        if (rs.next() && rs.getInt(1) > 0) {
            formData.addFormError(elementId, "Validation failed: A register is already open for this branch. Please close it first.");
            validationPassed = false;
        }

        // 2. Check for daily duplicate creation
        String checkAlreadyCreated = "SELECT COUNT(*) FROM " + tableName + " WHERE c_branch_name = ? AND DATE(dateCreated) = CURDATE()";
        preparedStmt = conn.prepareStatement(checkAlreadyCreated);
        preparedStmt.setString(1, values[0]);
        rs = preparedStmt.executeQuery();

        if (rs.next() && rs.getInt(1) > 0) {
            formData.addFormError(elementId, "A record has already been created for today.");
            validationPassed = false;
        }

    } catch (Exception e) {
        LogUtil.error("Validation Script", "Error occurred during execution.");
        validationPassed = false; 
    } finally {
        try {
            if (rs != null) rs.close();
            if (preparedStmt != null) preparedStmt.close();
            if (conn != null) conn.close();
        } catch (Exception e) {
            // Resource cleanup
        }
    }
    return validationPassed;
}

return validate(element, formData, values);

Customization Tips

⚙️ Table Name: Update the tableName variable at the start of the script with your actual Joget Table ID.
⚙️ Status Match: If your application uses 'Active' or 'In-Progress' instead of 'Open', update the SQL string accordingly.

🔒 Security Note

Table Masking: By using a variable for the table name, we prevent leaking the database schema in the logic description.
SQL Injection: We use PreparedStatement with ? placeholders to ensure that user input is handled safely.
Managed Connections: The script uses the Joget setupDataSource bean, ensuring credentials are never exposed in the script.

📬 Lazy Approval in Joget: Complete Workflows via Email Polling (BeanShell)

Explorer — Mon, 11 May 2026 12:29:50 +0000

Overview
Allowing users to approve or reject workflow requests directly from their email client—without logging into the portal—massively accelerates turnaround times. This implementation, commonly known as Lazy Approval, uses a comprehensive BeanShell script to poll an IMAPS inbox, parse incoming replies for intent (e.g., "Approved" or "Rejected"), authenticate the sender, and programmatically complete the corresponding Joget workflow assignment.

How It Works
The script acts as an automated, secure bridge between your mail server and the Joget Workflow Manager API:

Secure Connection: It reads connection properties (host, port, credentials) from a dedicated listener configuration form (#form.j_ave_listener...#) and establishes a secure connection via the IMAPS protocol.
Message Polling: It retrieves unread emails using Flag.SEEN, false, parses plain text, HTML, or multipart contents using Jsoup, and extracts the clean message body.
Intent & ID Extraction: Using regex patterns, the script identifies the target Process ID from the subject line (e.g., looking for ID:...) and evaluates keywords in the body (APPROVE, REJECT) while filtering out standard email signatures or history blocks.
Impersonation & Execution: It maps the sender's email address back to a valid Joget user account via the Directory Manager, temporarily binds that username to the current execution thread using setCurrentThreadUser, and calls workflowManager.assignmentComplete so the audit trail accurately records the true approver.

Where to Use in Joget
To deploy this automated polling mechanism, follow these standard navigation paths:

💡 For Scheduled Workflow Polling: Workflow Builder --> Design Process --> Add Tool --> BeanShell Tool (configure this tool to run on a recurring SLA deadline or automated system trigger).
💡 For Custom Background Schedulers: System Backend --> Manage Plugins --> Custom Scheduler (pointing the logic to pull from your listener configuration form).

Full Code

import java.util.Collection;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import javax.mail.BodyPart;
import javax.mail.Flags;
import javax.mail.Flags.Flag;
import javax.mail.Folder;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.Multipart;
import javax.mail.Session;
import javax.mail.Store;
import javax.mail.event.MessageCountAdapter;
import javax.mail.event.MessageCountEvent;
import javax.mail.internet.InternetAddress;
import javax.mail.Address;
import javax.mail.search.FlagTerm;

import com.sun.mail.imap.IMAPFolder;
import com.sun.mail.imap.IMAPStore;

import org.joget.commons.util.LogUtil;
import org.joget.commons.util.StringUtil;
import org.joget.apps.app.model.AppDefinition;
import org.joget.apps.app.model.PackageActivityForm;
import org.joget.apps.app.service.AppUtil;
import org.joget.apps.app.service.AppService;
import org.joget.apps.form.model.FormData;
import org.joget.directory.model.User;
import org.joget.directory.model.service.DirectoryManager;
import org.joget.workflow.model.WorkflowAssignment;
import org.joget.workflow.model.service.WorkflowManager;
import org.joget.workflow.model.service.WorkflowUserManager;
import org.joget.plugin.base.ApplicationPlugin;
import org.joget.plugin.base.Plugin;
import org.joget.plugin.base.PluginManager;
import org.joget.plugin.property.model.PropertyEditable;
import org.joget.apps.form.model.FormRow;
import org.joget.apps.form.model.FormRowSet;
import org.apache.commons.lang3.StringUtils;

import java.sql.*;
import java.util.Calendar;
import java.io.UnsupportedEncodingException;
import java.util.Date;
import javax.activation.DataHandler;
import javax.activation.DataSource;
import javax.activation.FileDataSource;
import javax.mail.Transport;
import javax.mail.internet.MimeBodyPart;
import javax.mail.internet.MimeMessage;
import javax.mail.internet.MimeMultipart;
import javax.mail.Authenticator;
import javax.mail.PasswordAuthentication;
import java.util.ArrayList;
import java.lang.String;
import java.util.Arrays;
import java.util.Scanner;
import org.apache.commons.lang3.ArrayUtils;
import java.util.stream.*; 

public FormRowSet activitiesLog = new FormRowSet();

public void pollEmail() {
  Properties properties = new Properties();
  if ("true".equals("#form.j_ave_listener.debug_imap?java#")) {
    properties.put("mail.debug", "true");
  }
  properties.put("mail.store.protocol", "imaps");
  properties.put("mail.imaps.host", "#form.j_ave_listener.host?java#");
  properties.put("mail.imaps.port", "#form.j_ave_listener.port?java#");
  properties.put("mail.imaps.timeout",(#form.j_ave_listener.timeout?java#*1000));

    Session session = Session.getInstance(properties);
    IMAPStore store = null;
    Folder inbox = null;

    int messageCount = 0;
    String errors = "";
    try {
        debug("Connect to IMAP for #form.j_ave_listener.email?java#");
        store = (IMAPStore) session.getStore("imap");
        store.connect("#form.j_ave_listener.email?java#","#form.j_ave_listener.password?java#");

        debug("IMAP connected for #form.j_ave_listener.email?java#");

        inbox = (IMAPFolder) store.getFolder("#form.j_ave_listener.folder?java#");
        if (null == inbox) {
            throw new Exception(" no  folder [#form.j_ave_listener.folder?java#] for user [#form.j_ave_listener.email?java#] on host [#form.j_ave_listener.host?java#]");
        }

        // opening found folder in read/write
        inbox.open(Folder.READ_WRITE);

        messageCount = inbox.getUnreadMessageCount();
        debug("Unread Messages: " + messageCount);
        debug("Filter email by exact subject text: #form.j_ave_listener.subject_filter?java#");
        debug("Filter email by regex subject text: #form.j_ave_listener.subject_pattern?java#");

        int count = 0;

        Message[] messages = inbox.search(new FlagTerm(new Flags(Flags.Flag.SEEN), false));
        for (Message message : messages) {
            try {
                if (count > #form.j_ave_listener.max_email?java#) {
                    debug("Email checking reach max email per check(#form.j_ave_listener.max_email?java#).");
                    break;
                }

                // get email details
                String subject = message.getSubject();
                if(!matchFilter(subject)) {
                    continue;
                }

                Object[] fromCollection = message.getFrom();
                String sender = fromCollection[0].toString();

                String content = "";
                String data =  getTextFromMessage(message);
                content=data;
                debug("multipart content: " + data);

                debug("--- Mail " + count + ": " + subject + " --- ");
                debug("Sender: " + sender);
                debug("Mail Content: " + content);

                // reset read flag
                message.setFlag(Flags.Flag.SEEN, true);
                content=content.replaceAll("<[^>]*>", "");
                content=content.replaceAll("[^}]*}", "");

                debug("Mail Content after removing HTML: " + content);
                // check for approval message
                parseEmail(sender, subject, content);

                count++;
            } catch (MessagingException e) {
                errors += e.getMessage() + "\n";
                LogUtil.error("App: eas - Poll Email tool", e, e.getMessage());
            }
        }

    } catch (Exception e) {
        errors += e.getMessage() + "\n";
        LogUtil.error("App: eas - Poll Email tool", e, "");
    } finally {
        try {
            if (inbox != null && inbox.isOpen()) {
                inbox.close(false);
            }
        } catch (Exception e) {
            // ignore
        }

        try {
            if (store != null && store.isConnected()) {
                store.close();
            }
        } catch (Exception e) {
            // ignore
        }
    }
    if (!errors.isEmpty()) {
        addError(messageCount, errors);
    }
    storeFormData("j_ave_log", "log", activitiesLog);
}

public void parseEmail(String sender, String subject, String content) {
    String processId = null;
    String activityId = null;
    Map variables = new HashMap();
    FormData formData = new FormData();
    String[] approvedcond={"Approved","approved"};
    String[] rejectedcond={"Rejected","rejected"};

     Pattern r = Pattern.compile("ID:(.*)");

      // For Process id
      Matcher m = r.matcher(subject);
      if (m.find( )) {
         String result=m.group(1);
         debug("processId =" + result);
         processId=result.trim();
      }else{
         System.out.println("NO Process id Found");
      }
      String[] contentParts=content.split("From:");
      String content1 = contentParts[0];
      content1 = content1.replace("_","");
      content1 = content1.toUpperCase();
      debug("Mail Content After splitting: "+content1);

       String value="";

       String[] ApproveKey = {"APPROVE","APPROVED","DONE","FINE","OKAY"};
       String[] RejectKey = {"REJECT","DECLINE","DECLINED","DENIED","DENY","REJECTED"};

       if(content1.indexOf("PAYMENT DETAILS")!=-1){
        content1=content1.substring(0,content1.indexOf("PAYMENT DETAILS"));
       }
       else if(content1.indexOf("SYSTEM ADMIN-JOGET")!=-1){
        content1=content1.substring(0,content1.indexOf("SYSTEM ADMIN-JOGET"));
       }

        for (String element: ApproveKey){
           if(content1.contains(element)){
            if(content1.contains("NOT APPROVE")|| content1.contains("NOT APPROVED")||content1.contains("REJECT")|| content1.contains("REJECTED")){
                value="Rejected";
                break;
            }else{
            value="Approved";
            break;}
           }else{
            for (String element1: RejectKey){
                if(content1.contains(element1)){
                 value="Rejected";
                 break;
                }else{
                    value="invalid response";
                }
             }
            }
        }

                    debug("approvalStatus="+value);
      formData.addRequestParameterValues("approvalStatus", new String[] {value});

      // For Approver Name
      User user = null;

    InternetAddress ia = new InternetAddress(sender);
    String email = ia.getAddress();
    DirectoryManager directoryManager = (DirectoryManager)AppUtil.getApplicationContext().getBean("directoryManager");
    Collection users = directoryManager.getUserList(email, null, null, 0, 1);
    if (!users.isEmpty()) {
        user = (User)users.iterator().next();
        String ApproverName=user.getFirstName() + " " + user.getLastName();
       variables.put("approverName",ApproverName); 
       debug("Approver Name Is "+ApproverName);
    }

    if(value=="Approved"){
       variables.put("LazyApprovalStatus","Approved by Lazy Approval"); 
    }else if (value=="Rejected"){
        variables.put("LazyApprovalStatus","Rejected By Lazy Approval");  
      }

    if (processId != null || activityId != null) {
        completeActivity(sender, processId, activityId, formData, variables, subject, content);
    }
}

public boolean matchFilter(String subject) {
    String filter = "#form.j_ave_listener.subject_filter?java#";
    if (!filter.isEmpty() && !filter.startsWith("#form.j_ave_listener.subject_filter")) {
        try {
            debug("Subject filter for ("+subject+").");
            if ("true".equals("#form.j_ave_listener.subject_filter_regex?java#")) {
                if (subject.matches("#form.j_ave_listener.subject_filter?java#")) {
                    debug("Found a match using regex subject filter");
                    return true;
                }
            } else if (subject.contains("#form.j_ave_listener.subject_filter?java#")) {
                debug("Found a match using exact subject filter");
                return true;
            } else {
                debug("No match found on subject filter.");
            }
        } catch (Exception ex) {
            debug("Subject filter error for ("+subject+"). " + ex.getMessage());
        }
        return false;
    } else {
        return true;
    }
}

public void completeActivity(String sender, String processId, String activityId, FormData formData, Map variables, String subject, String message) {
    String username = getUsername(sender);
     debug("Inside Complete Activity Method");
     debug("Username"+username);
    if (username != null) {
        AppService appService = (AppService)AppUtil.getApplicationContext().getBean("appService");
        WorkflowManager workflowManager = (WorkflowManager)AppUtil.getApplicationContext().getBean("workflowManager");
        WorkflowUserManager workflowUserManager = (WorkflowUserManager)AppUtil.getApplicationContext().getBean("workflowUserManager");
        String currentUsername = workflowUserManager.getCurrentUsername();
        debug("currentUserName: "+currentUsername);
        try {
            // set current user
            workflowUserManager.setCurrentThreadUser(username);

            // find assignment
            WorkflowAssignment assignment = null;
            if (activityId != null) {
            debug("is activity id null");
                assignment = workflowManager.getAssignment(activityId);
            }
            if (processId != null) {
                debug("is process id null");
                assignment = workflowManager.getAssignmentByProcess(processId);
                debug("Assignment ="+ assignment);
                debug("process id ="+ processId);
            }

            if (assignment != null) {
                AppDefinition currentAppDef = AppUtil.getCurrentAppDefinition();

                try {
                    String assignmentId = assignment.getActivityId();
                    AppDefinition appDef = appService.getAppDefinitionForWorkflowActivity(assignmentId);

                    activityId = assignment.getActivityId();
                    processId = assignment.getProcessId();

                    //if has form data to submit
                    if (!formData.getRequestParams().isEmpty()) {
                        PackageActivityForm activityForm = appService.viewAssignmentForm(appDef, assignment, formData, "", "");
                        if (activityForm != null && activityForm.getForm() != null) {
                            debug("Submit Form for assignment: " + assignmentId + " " + formData.getRequestParams());
                            appService.submitForm(activityForm.getForm(), formData, false);
                        }
                    }

                    debug("assignmentComplete: " + assignmentId + " " + variables);
                    if (!assignment.isAccepted()) {
                        workflowManager.assignmentAccept(assignmentId);
                    }
                    workflowManager.assignmentComplete(assignmentId, variables);

                    sendAutoReply(sender, subject);
                } finally {
                    AppUtil.setCurrentAppDefinition(currentAppDef);
                }

                addActivityLog(sender, processId, activityId, subject, message, variables, formData.getRequestParams());
            } else {
                debug("assignment not found for process(" + processId + ") or activityId(" + activityId + ")");
            }

        } finally {
            workflowUserManager.setCurrentThreadUser(currentUsername);
        }
    } else {
        debug("No user found for sender : " + sender);
    }
}

public String getUsername(String sender) {
    User user = null;
    InternetAddress ia = new InternetAddress(sender);
    String email = ia.getAddress();
    DirectoryManager directoryManager = (DirectoryManager)AppUtil.getApplicationContext().getBean("directoryManager");
    Collection users = directoryManager.getUserList(email, null, null, 0, 1);
    if (!users.isEmpty()) {
        user = (User)users.iterator().next();
        return user.getUsername();
    }
    return null;
}

public void sendAutoReply(String sender, String subject) {
    if ("true".equals("#form.j_ave_listener.auto_reply?java#")) {
        sendEmail(sender, "Re: " + subject, "#form.j_ave_listener.smtp_message?java#");
    }
}

public void sendEmail(String email, String subject, String message) {
    PluginManager pluginManager = (PluginManager) AppUtil.getApplicationContext().getBean("pluginManager");
    Plugin plugin = pluginManager.getPlugin("org.joget.apps.app.lib.EmailTool");
    Map propertiesMap = new HashMap();
    propertiesMap.put("pluginManager", pluginManager);

    propertiesMap.put("host", "#form.j_ave_listener.smtp_host?java#");
    propertiesMap.put("port", "#form.j_ave_listener.smtp_port?java#");
    propertiesMap.put("from", "#form.j_ave_listener.smtp_email?java#");
    propertiesMap.put("username", "#form.j_ave_listener.smtp_email?java#");
    propertiesMap.put("password", "#form.j_ave_listener.smtp_password?java#");
    propertiesMap.put("security", "#form.j_ave_listener.smtp_security?java#");
    propertiesMap.put("toSpecific", email);
    propertiesMap.put("subject", subject);
    propertiesMap.put("message", message);

    ApplicationPlugin emailTool = (ApplicationPlugin) plugin;
    ((PropertyEditable) emailTool).setProperties(propertiesMap);
    emailTool.execute(propertiesMap);
}

public void addError(int messageCount, String errors) {
    FormRowSet rows = new FormRowSet();
    FormRow row = new FormRow();
    row.setProperty("listener_id", "#form.j_ave_listener.uid?java#");
    row.setProperty("count", Integer.toString(messageCount));
    row.setProperty("errors", errors);
    Date now = new Date();
    row.setDateCreated(now);
    row.setDateModified(now);
    rows.add(row);

    storeFormData("j_ave_log_error", "errorLog", rows);
}

public void addActivityLog(String sender, String processId, String activityId, String subject, String message, Map variables, Map formData) {
    FormRow row = new FormRow();
    row.setProperty("listener_id", "#form.j_ave_listener.uid?java#");
    row.setProperty("sender", sender);
    row.setProperty("processId", processId);
    row.setProperty("activityId", activityId);
    row.setProperty("subject", subject);
    row.setProperty("message", message);
    row.setProperty("variables", "Variables: \n" + variables.toString() + "\n\nData: \n" + formData.toString());

    Date now = new Date();
    row.setDateCreated(now);
    row.setDateModified(now);

    activitiesLog.add(row);
}

public void storeFormData(String tableName, String formId, FormRowSet rows) {
    AppService appService = (AppService) AppUtil.getApplicationContext().getBean("appService");
    appService.storeFormData(formId, tableName, rows, null);
}

public void debug(String msg) {
    if ("true".equals("#form.j_ave_listener.debug?java#")) {
        LogUtil.info("App: Approval Via Email System", msg);
    }
}

public String getTextFromMessage(Message message) throws MessagingException, IOException {
    String result = "";
    debug("message is "+message.getContentType());
    if (message.isMimeType("text/plain")) {
        result = message.getContent().toString();
    } else if (message.isMimeType("multipart/*")) {
        MimeMultipart mimeMultipart = (MimeMultipart) message.getContent();
        result = getTextFromMimeMultipart(mimeMultipart);
    }
    else if (message.isMimeType("text/html")) {
           String html = (String)message.getContent();
           result = result + "\n" + org.jsoup.Jsoup.parse(html).text();
            debug("text/html "+message.getContentType());
        }
    return result;
}

public String getTextFromMimeMultipart(MimeMultipart mimeMultipart)  throws MessagingException, IOException{
    String result = "";
    int count = mimeMultipart.getCount();
    debug("Total count is "+count.toString());
    for (int i = 0; i < count; i++) {
        BodyPart bodyPart = mimeMultipart.getBodyPart(i);
        if (bodyPart.isMimeType("text/plain")) {
           result = result + "\n" + bodyPart.getContent();
            debug("text/plain => "+bodyPart.getContentType());
           break; 
        } 
        else if (bodyPart.isMimeType("text/html")) {
           String html = (String)bodyPart.getContent();
           result = result + "\n" + org.jsoup.Jsoup.parse(html).text();
            debug("text/html "+bodyPart.getContentType());
        }
        else if (bodyPart.getContent() instanceof MimeMultipart){
             debug("Multipart "+bodyPart.getContentType());
             result = result + getTextFromMimeMultipart((MimeMultipart)bodyPart.getContent());
        }
    }
    return result;
  }

pollEmail();

Example Use Cases

💡 Executive Requisitions: C-level executives completing urgent purchase order approvals via a quick "Approved" reply directly from their mobile devices.
💡 Field Service Sign-offs: Off-site team managers confirming task completions without needing to launch a corporate VPN or log into the web interface.
💡 Helpdesk Escalations: Support agents resolving or reopening tracked items straight from their email correspondence.

Customization Tips

⚙️ Keyword Dictionaries: Adjust the ApproveKey and RejectKey string arrays in the parseEmail method to include custom local phrases or organizational shorthand (e.g., "AGREED", "PROCEED").
⚙️ Truncation Rules: Ensure custom email footers, legal disclaimers, or ongoing thread titles (like "PAYMENT DETAILS") are properly accounted for in the string truncation logic so they do not trigger false rejections.
⚙️ Thread Context Reset: Always guarantee that workflowUserManager.setCurrentThreadUser(currentUsername) executes inside the finally block to securely revert thread ownership after completing the assignment.

Key Benefits

✅ Frictionless UX: Completely removes portal login friction, dramatically reducing task stalling.
✅ Accurate Auditing: By dynamically resolving the sender's address to their registered Joget username, the system enforces compliance and maintains accurate approval records.
✅ Robust Content Parsing: Handles plain text, rich HTML, and complex multipart MIME attachments seamlessly using Jsoup.

🛡️ Security Note
Because this implementation authenticates users based on their incoming email headers, your organization's mail server must enforce strict SPF/DKIM validation to prevent sender address spoofing. Maintain generic mapping placeholders as shown (#form.j_ave_listener...#) to prevent hardcoding plain-text credentials in your scripts.

Final Thoughts
Integrating email-driven actions shifts your workflow engine from a passive queue into an active, responsive platform. Mastering this programmatic bridge ensures critical business transactions continue moving forward effortlessly.

🛡️ Custom Screen Security in Joget Using BeanShell

Explorer — Mon, 11 May 2026 12:23:15 +0000

Overview

Standard Joget security often relies on broad role mapping. By using a custom BeanShell script, you can implement granular Screen Security that cross-references specific user roles against allowed screens stored in a database table. This ensures that even if a user has a general role, they only see functional screens (like Dashboards or Vendor Management) explicitly assigned to them.

How It Works

The script performs a real-time check against your Joget database (jwdb). It retrieves the roles assigned to the current user for the specific application and then verifies if any of those roles are authorized to view the requested "Screen Name" by querying a custom management table (app_fd_tbl_app_roles).

Where to Use in Joget

To implement this, follow these navigation paths within the Joget App Center:

💡 For Menu Visibility: Userview Builder --> Select Menu Element --> Properties --> Permission --> BeanShell Permission
💡 For Category Visibility: Userview Builder --> Select Category --> Properties --> Permission --> BeanShell Permission
💡 For Form Access: Form Builder --> Properties --> Advanced --> Permission --> BeanShell Permission

Full Code

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.joget.commons.util.LogUtil;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;

public boolean isUsernamePresent(String username) {
    Collection roles = new ArrayList();
    boolean access = false;
    ResultSet resultSet = null;
    Connection con = null;
    String myDriver = "com.mysql.jdbc.Driver";
    // Update port and DB name as per your environment
    String myUrl = "jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8";

    try {
        Class.forName(myDriver);
        con = DriverManager.getConnection(myUrl, "root", "");
        String User = "#currentUser.username#";
        String screenName = "Dashboard"; // Change this for each specific screen/menu
        String AppID = "#appDef.appId#";

        if(!con.isClosed()) {
            PreparedStatement stmt = con.prepareStatement("SELECT c_roles FROM app_fd_tbl_app_user_role WHERE c_applicationId='"+AppID+"' and c_user = '"+User+"' and c_active='yes'");    
            resultSet = stmt.executeQuery();
            while (resultSet.next()) {
                String str = resultSet.getObject(1).toString();
                String[] arr = str.split(";"); 
                for(String text : arr) {
                    roles.add(text);
                }
            }
        }

        for (String role : roles) {
            if (hasScreenInRole(role, screenName, con)) {
                access = true;
                break;
            }
        }
    } catch (Exception e) {
        LogUtil.error("Screen Security", e, "Error checking security for " + username);
    } finally {
        try {
            if (resultSet != null) resultSet.close();
            if (con != null) con.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    return access;
}

public boolean hasScreenInRole(String roleName, String screenName, Connection con) throws SQLException {
    String sql = "SELECT COUNT(*) AS count FROM app_fd_tbl_app_roles WHERE c_roleName = ? AND c_screens like '%"+screenName+"%'";
    PreparedStatement stmt = con.prepareStatement(sql);
    stmt.setString(1, roleName);
    ResultSet rs = stmt.executeQuery();
    rs.next();
    return rs.getInt("count") > 0;
}

// Admin bypass: Admins always see everything
String UserRole = "#currentUser.roles#";
return UserRole.contains("ROLE_ADMIN") ? true : isUsernamePresent("#currentUser.username#");

Example Use Cases

💡 Executive Dashboards: Restrict sensitive financial dashboards only to users with the "Finance_Lead" role.
💡 Vendor Portals: Ensure vendors only see the "Manage New Bid" screen if their specific account is active and mapped.
💡 Shared Portals: Control which business modules (e.g., HR vs. Procurement) appear in a single unified Userview.

Customization Tips

⚙️ Screen Names: Update the screenName variable to match the specific menu item you are securing (e.g., "Manage New Bid").
⚙️ DB Credentials: Ensure the myUrl and database credentials match your local or server environment.
⚙️ Database Table IDs: Ensure your custom management tables (app_fd_tbl_app_user_role and app_fd_tbl_app_roles) are created and populated correctly.

Key Benefits

✅ Centralized Management: Manage permissions through a Joget form/table instead of hardcoding roles in the builder.
✅ Scalable Security: Easily add new screens or roles without needing to redeploy the application.
✅ Granular Visibility: Show or hide specific menus dynamically based on business logic.

Final Thoughts

Using BeanShell for screen-level security provides the flexibility required for complex enterprise applications. By guiding the logic through the Userview Builder --> Menu --> BeanShell path, you ensure that security is enforced at the very first point of user interaction.

📁 Bulk Import & Export Excel Data for Joget Form Grids

Explorer — Mon, 11 May 2026 12:17:10 +0000

Overview

Manually entering large volumes of data into a Form Grid or Spreadsheet element is a common bottleneck in enterprise workflows. This guide provides a professional-grade solution using the SheetJS (XLSX) library to allow users to upload an Excel file and instantly populate a Joget Form Grid. It also includes a "Clean Export" feature to download the grid data back into Excel.

How It Works

The integration acts as a client-side bridge between your local file and the Joget UI:

Parsing: When a user selects a file, the FileReader API reads the content, and SheetJS converts the binary data into a JSON object.
Mapping: The script scans the Excel header row to find specific columns (e.g., "Item Name", "Quantity"). This makes the import flexible—users don't have to have columns in a rigid, fixed order as long as the names match.
Injection: The script uses Joget’s internal JavaScript API—specifically the [FieldID]_add function—to programmatically "click" the add button and fill the fields for every row found in the Excel sheet.
Async Processing: To prevent the browser from freezing during a 500-row import, the script uses async/await to process rows in small batches.

Where to Use in Joget

✅ Form Builder: Place this logic inside a Custom HTML element positioned above your Form Grid.
✅ Procurement/Finance Apps: Ideal for Bids, Expense Claims, or Inventory lists where line items are usually prepared in Excel first.

Full Code

Ensure you have the SheetJS library added to your App (via Userview Settings > Custom JavaScript or a script tag in the Form).

<div class="excel-import-container" style="padding: 15px; border: 1px solid #ddd; border-radius: 5px;">
  <input id="file_upload" type="file" accept=".xlsx" style="display:none;">
  <button type="button" class="form-button" onclick="$('#file_upload').click();">📁 Select Excel File</button>
  <button type="button" class="export_excel form-button">📥 Export Grid</button>
  <button type="button" class="delete_all form-button-destructive">🗑️ Clear Grid</button>
  <div style="margin-top: 10px;">
    <a href="/jw/web/app/E_procurement/resources/BidTemplate.xlsx" style="font-size: 0.9em; color: #007bff;">📥 Download Required Excel Template</a>
  </div>
</div>

<script>
  $(document).ready(function () {
    // Clear Table Logic
    $('.delete_all').on('click', function () {
      if(confirm("This will remove all entries from the grid. Proceed?")) {
        $('[name=Uploaded_bids] tbody tr:not(:first-child)').empty();
      }
    });

    // Export Logic
    $('.export_excel').click(function () {
      var originalTable = document.querySelector(".tablesaw");
      var clonedTable = originalTable.cloneNode(true);

      // Remove Action/Delete columns from the export
      $(clonedTable).find(".grid-action-cell, th:last-child, td:last-child").remove();

      var wb = XLSX.utils.table_to_book(clonedTable, { sheet: "Sheet1" });
      XLSX.writeFile(wb, "Grid_Export.xlsx");
    });

    // Import Logic
    $('#file_upload').change(function (e) {
      var files = e.target.files;
      var reader = new FileReader();

      reader.onload = function (e) {
        var data = e.target.result;
        var workbook = XLSX.read(data, { type: 'binary' });
        var sheet = workbook.Sheets[workbook.SheetNames[0]];
        var range = XLSX.utils.decode_range(sheet['!ref']);

        // Convert to JSON (Header: 1 returns an array of arrays)
        var jsonData = XLSX.utils.sheet_to_json(sheet, { header: 1 });

        addItemsToBid(jsonData);
      };
      reader.readAsBinaryString(files[0]);
    });
  });

  async function addItemsToBid(jsonData) {
    // Loop through rows (index 0 is header)
    for (let i = 1; i < jsonData.length; i++) {
      let row = jsonData[i];
      if (!row || row.length === 0) continue;

      await new Promise(resolve => {
        setTimeout(() => {
          var field = FormUtil.getField("Uploaded_bids");
          var gridAddFunction = window[field.attr("id") + "_add"];

          if (typeof gridAddFunction === 'function') {
            gridAddFunction({
              'result': JSON.stringify({
                "item_Name": row[0] || "",
                "item_UOM": row[1] || "",
                "quantity": row[2] || "",
                "description": row[3] || "",
                "technical_requirement": row[4] || ""
              })
            });
          }
          resolve();
        }, 30); // 30ms stagger to keep UI responsive
      });
    }
    alert("Data import successful!");
  }
</script>

Example Use Cases

💡 Tendering: Vendors uploading their entire technical proposal and pricing list in one click.
💡 Bulk User Updates: HR administrators uploading a list of employee adjustments to a processing form.

Customization Tips

⚙️ Target Field IDs: Replace Uploaded_bids in the code with the actual ID of your Form Grid.
⚙️ Security Note: This script processes data entirely in the user's browser. No Excel data is sent to external servers for parsing, ensuring data privacy.
⚙️ Template Matching: Ensure the row[x] indexes in the addItemsToBid function match the column order in your "Sample File Format" download.

Key Benefits

✅ Better UX: Transforms a tedious data entry task into a simple file upload.
✅ Data Integrity: Automates the mapping of Excel data to Joget fields, reducing transcription errors.
✅ Performance: Handle hundreds of rows smoothly using asynchronous row injection.

Final Thoughts

Providing an Excel-to-Form bridge is one of the most requested features in enterprise environments. By leveraging SheetJS and Joget's internal grid functions, you provide a seamless, high-performance experience that makes your application feel truly professional.

🖼️ Picking Data from Iframe Popups in Joget

Explorer — Mon, 11 May 2026 12:13:12 +0000

Overview

Standard data selection in Joget often relies on simple pickers, but complex business logic sometimes requires a custom multi-select interface. This guide explains how to open a Joget list in a popup iframe, select multiple rows, validate them against existing data, and inject them into a Form Grid or Subform using JavaScript.

How It Works

The solution uses a parent-child window relationship. A JavaScript trigger opens a popup containing an <iframe> that loads a specific Joget Userview list. When the user clicks "Submit" on the popup, the script scrapes the checked rows from the iframe, checks for duplicates against the main form’s current table entries, and programmatically calls Joget's internal _add functions to populate the data.

Where to Use in Joget

✅ Form Builder: Inside a Custom HTML element to add advanced "Bulk Add" functionality.
✅ Userview: Within a custom page to facilitate data transfer between different application modules.

Full Code

⚙️ Iframe Selection Script
Place this code in a Custom HTML section of your form. It handles the window creation and the data bridge.

<input type="button" value="Select Vendors" id='openBtn' class="form-button">

<script>
  $(document).ready(function () {
    $('#openBtn').on('click', function () {
      // 1. Define the Joget List URL (use embed=true for a clean look)
      var url = '/jw/web/userview/E_procurement/v/_/54E1E4C5D136428A971012E7F4DEC71E?embed=true';
      var options = 'width=900,height=700';
      var popupWindow = window.open('', '_blank', options);

      // 2. Build the Popup Content
      popupWindow.document.write(`
        <div style="padding:10px; font-family:Arial;">
          <button id="submitBtn" style="margin-bottom:10px; padding:10px 20px; background:#2196F3; color:white; border:none; cursor:pointer;">
            Add Selected Rows
          </button>
          <iframe id="popupIframe" src="${url}" frameborder="0" style="width:100%; height:600px;"></iframe>
        </div>
      `);

      // 3. Logic for the Submit Button in the Popup
      popupWindow.document.getElementById('submitBtn').addEventListener('click', function () {

        // Collect existing IDs from the main form to prevent duplicates
        let existingIds = [];
        $("[name=vendor_adding_form]", parent.document).find('.tablesaw tr:not(:first-child)').each(function () {
          let id = $(this).find('td:eq(0) #vendor_adding_form_vendor_id').text();
          existingIds.push(id.trim());
        });

        // Identify checked rows inside the Iframe
        var iframeDoc = popupWindow.document.getElementById('popupIframe').contentWindow.document;
        var checkedRows = $(iframeDoc).find('#list_New_Vendor tbody input[type="checkbox"]:checked').closest('tr');

        // Target the Joget Form Grid add function
        var field = FormUtil.getField("vendor_adding_form");
        var addFunction = window[field.attr("id") + "_add"];

        if (typeof addFunction === 'function') {
          checkedRows.each(function () {
            var col1 = $(this).find('td:eq(1)').text().trim(); // Vendor ID

            // Duplicate Validation
            if (!existingIds.includes(col1)) {
              var args = {
                'result': JSON.stringify({
                  "vendor_id": col1,
                  "vendor_org_name": $(this).find('td:eq(2)').text().trim(),
                  "vendor_category": $(this).find('td:eq(3)').text().trim(),
                  "vendor_email": $(this).find('td:eq(6)').text().trim()
                })
              };
              addFunction(args);
            } else {
              console.log("Skipped: " + col1 + " already exists.");
            }
          });
          popupWindow.close();
        }
      });
    });
  });
</script>

Example Use Cases

💡 E-Procurement: Selecting multiple vendors from a master list and adding them to a "Tender Invitation" grid.
💡 Project Management: Picking team members from a global directory to populate a specific project task.
💡 Inventory: Selecting multiple parts from a warehouse list for a "Material Request" form.

Customization Tips

⚙️ Selectors: Ensure #list_New_Vendor matches the ID of the list data table inside your iframe.
⚙️ Column Index: td:eq(1) refers to the second column. Adjust these numbers based on your list's layout.
⚙️ Grid Function: Joget naming convention for adding rows is [FieldID]_add. Always ensure your script correctly identifies the field.attr("id").

Key Benefits

✅ UX Excellence: Users can browse and filter a full Joget list before selecting data.
✅ Data Integrity: Prevents duplicate entries in your Form Grid with real-time array checking.
✅ High Speed: Allows users to add dozens of records with a single click rather than one-by-one.

Final Thoughts

Bridging data between a popup iframe and a parent form is a powerful way to extend Joget's UI capabilities. This method provides a "Shopping Cart" style experience for data entry, making your application feel much more professional and enterprise-ready.

📧 Sending Emails Programmatically in Joget via BeanShell

Explorer — Mon, 11 May 2026 12:07:14 +0000

Overview

While Joget provides a built-in Email Tool, there are scenarios where you need to send notifications dynamically within a complex script. Whether you are looping through a list of unique recipients or triggering alerts based on conditional logic, using BeanShell to invoke the Email Tool plugin gives you the flexibility to send emails exactly when and how you need them.

How It Works

Instead of reinventing the SMTP connection, this script leverages Joget's existing Email Tool plugin. It programmatically retrieves the plugin, injects the necessary server configurations (SMTP host, port, etc.) from the App Definition, and executes the send command. This ensures your script uses the global email settings already configured in your Joget platform.

Where to Use in Joget

✅ Workflow Builder: Within a BeanShell Tool to send custom alerts during process transitions.
✅ Form Builder: In a Form Post-Processor to notify stakeholders immediately upon data submission.
✅ Userview: Inside a BeanShell Menu to trigger manual email blasts.

Full Code

⚙️ Programmatic Email Script
This script identifies the org.joget.apps.app.lib.EmailTool and executes it using your system's default properties.

import java.util.Map;
import java.util.HashMap;
import org.joget.apps.app.model.AppDefinition;
import org.joget.apps.app.service.AppPluginUtil;
import org.joget.apps.app.service.AppUtil;
import org.joget.plugin.base.ApplicationPlugin;
import org.joget.plugin.base.Plugin;
import org.joget.plugin.base.PluginManager;
import org.joget.plugin.property.model.PropertyEditable;
import org.joget.commons.util.LogUtil;

public Object sendEmail() {
    LogUtil.info("EmailScript", "Email transmission started...");

    // 1. Setup Environment
    AppDefinition appDef = AppUtil.getCurrentAppDefinition();
    PluginManager pluginManager = (PluginManager) AppUtil.getApplicationContext().getBean("pluginManager");

    // 2. Define Recipients (Add your logic here to pull from a form or database)
    String[] emails = new String[]{"recipient@example.com"}; 

    // 3. Initialize the Email Tool Plugin
    Plugin plugin = pluginManager.getPlugin("org.joget.apps.app.lib.EmailTool");
    Map propertiesMap = AppPluginUtil.getDefaultProperties(plugin, null, appDef, null);
    propertiesMap.put("pluginManager", pluginManager);
    propertiesMap.put("appDef", appDef);

    ApplicationPlugin emailTool = (ApplicationPlugin) plugin;

    // 4. Loop through recipients and send
    for (String email : emails) {
        propertiesMap.put("toSpecific", email);
        propertiesMap.put("subject", "Automated Notification: Action Required");
        propertiesMap.put("message", "This is a programmatically generated email from Joget.");

        // Set properties and execute
        ((PropertyEditable) emailTool).setProperties(propertiesMap);
        emailTool.execute(propertiesMap);

        LogUtil.info("EmailScript", "Successfully sent to: " + email);
    }

    LogUtil.info("EmailScript", "Email transmission completed.");
    return null;
}

// Execute the method
return sendEmail();

Example Use Cases

💡 Dynamic Batching: Sending individual emails to a list of users selected in a Checkbox or Multi-Select field.
💡 Custom Attachments: Using script logic to determine which files from a File Upload field should be attached.
💡 API-Triggered Alerts: Sending an email notification after a successful (or failed) external API call.

Customization Tips

⚙️ Recipients: You can replace the emails array with a query that fetches user emails from a Joget User Directory or a specific DataList.
⚙️ HTML Content: Ensure your message body uses valid HTML if you want to include links, tables, or professional branding.
⚙️ Logging: Keep the LogUtil calls during testing; they are your best friend for verifying that the loop is executing correctly in catalina.out.

Key Benefits

✅ Zero Redundancy: Reuses the SMTP settings already defined in your App, avoiding hardcoded passwords.
✅ Granular Control: Send emails based on data values that a standard Workflow Email Tool cannot easily parse.
✅ Scalability: Easily handle one recipient or one hundred within the same logic block.

Final Thoughts

Invoking plugins via BeanShell is a "power user" move that bridges the gap between standard configuration and custom coding. It keeps your app clean by utilizing Joget's core engine while giving you the surgical precision needed for specialized notifications. Always test with a single email address before running the script on a live production dataset!

🚀 How To Increase Heap Memory in Joget

Explorer — Mon, 11 May 2026 11:49:39 +0000

Overview

Heap memory is the portion of memory allocated to the Java Virtual Machine (JVM) where Joget runs. When your application handles large datasets, complex workflows, or heavy concurrent traffic, the default memory settings might result in java.lang.OutOfMemoryError. Increasing the heap memory ensures the Joget server remains stable and responsive under heavy loads.

How It Works

The JVM uses the -Xmx parameter to define the maximum heap size. By modifying the Joget startup script (typically joget-start.bat or startup.bat), you tell the system how much physical RAM it is allowed to consume. For example, setting -Xmx16384M allocates 16GB of memory to the Joget instance.

Where to Use in Joget

✅ System Installation: Modifying the root startup files in the Joget installation folder.
✅ Server Administration: Optimizing performance for enterprise-level deployments.

Full Code

⚙️ Modified Startup Script (joget-start.bat)
Update your batch file by adjusting the set JAVA_OPTS line as shown below:

@ECHO OFF
chcp 65001

REM Start MariaDB
ECHO == Starting MariaDB ==
CALL .\mariadb-start.bat

REM Start Tomcat
set JAVA_HOME=.\jre11.0.18
set CATALINA_HOME=.\apache-tomcat-9.0.71

REM Increase memory by adjusting the -Xmx value (e.g., 16384M for 16GB)
set JAVA_OPTS=-Xmx16384M -Dfile.encoding=UTF-8 -Dwflow.home=./wflow/ -javaagent:./wflow/wflow-cluster.jar -javaagent:./wflow/aspectjweaver-1.9.7.jar -javaagent:./wflow/glowroot/glowroot.jar

ECHO == Starting Tomcat from %CATALINA_HOME% ==
%CATALINA_HOME%\bin\catalina.bat run

Example Use Cases

💡 Large File Processing: When users frequently upload or process large documents through Joget forms.
💡 High Concurrency: When a high volume of users are accessing the Userview simultaneously.
💡 Complex Reporting: Generating heavy reports using BeanShell or SQL that require significant temporary memory storage.

Customization Tips

⚙️ Available RAM: Never allocate more than 70-80% of your total physical RAM to the JVM to leave room for the Operating System and Database.
⚙️ Unit Conversion: You can use G for Gigabytes (e.g., -Xmx16G) or M for Megabytes (e.g., -Xmx16384M).
⚙️ Initial Heap: You can also set the starting memory using -Xms (e.g., -Xms4G -Xmx16G) to prevent the JVM from constantly resizing the heap.

Key Benefits

✅ Stability: Eliminates "OutOfMemory" crashes during peak usage.
✅ Speed: Reduces the frequency of Garbage Collection (GC) pauses.
✅ Scale: Allows the application to handle more complex scripts and larger datasets.

Final Thoughts

Increasing heap memory is a quick and effective way to scale your Joget environment. Always monitor your server's performance after an upgrade to ensure that the hardware can support the new memory allocation.

🔍 Cracking the Code: Enabling Detailed Persistence Debugging in Joget

Explorer — Mon, 11 May 2026 11:28:38 +0000

Overview

When troubleshooting Joget workflows, standard error logs sometimes lack the specific details needed to pinpoint which activity or tool is failing. By enabling Persistence Debugging, you can track exactly which process IDs and activity definitions are being handled by the engine in real-time. This is essential for identifying the "where" and "why" behind workflow bottlenecks or silent failures.

How It Works

Joget uses Log4j2 for its logging framework. By adding a specific logger for Persistence at the DEBUG level in the system configuration, the server begins outputting granular details about activity persistence events. This reveals the internal IDs that link a running process to its specific configuration in the Workflow Builder.

Where to Use in Joget

✅ System Backend: Accessing the Joget installation directory.
✅ Workflow Builder: Identifying the definitionId and activityId shown in the logs.

Full Code

⚙️ Log4j2 Configuration Update
Locate and edit the file at /apache-tomcat-x.x.x/webapps/jw/WEB-INF/classes/log4j2.xml. Add the following block within the <Loggers> section:

<ThresholdFilter level="debug" />
<Logger name="Persistence" level="debug" additivity="true">
</Logger>

Note: Restart your Joget server for these changes to take effect.

Example Use Cases

💡 Stuck Processes: Finding the exact activityId that failed to persist during a transition.
💡 Tool Failures: Identifying which "BeanShell Tool" or "Email Tool" was active immediately before a database error.
💡 Audit Trail: Verifying that a process actually reached the database state-change phase.

Customization Tips

⚙️ Log to File: You can redirect these specific persistence logs to a separate file by defining a new AppenderRef within the Logger tag.
⚙️ Specific Classes: If "Persistence" is too broad, you can target specific Joget libraries like org.joget.workflow.model.

Key Benefits

✅ Precision: See the exact definitionId (e.g., tool5) causing issues.
✅ Real-time Tracking: Watch process movements as they happen.
✅ Faster Root Cause Analysis: Reduces guesswork when analyzing catalina.out.

🛡️ Security & Performance Note

Do not enable debug logs in a production environment, as excessive logging may impact application performance. Always revert the level to INFO once troubleshooting is complete. Additionally, ensure you perform regular backups of your .jwa files and database.

Final Thoughts

Enabling persistence logs turns the workflow engine into a transparent map. Once you have the activityId and processId from the debug logs, you can easily find the offending element in the Workflow Builder and fix it.

Dynamic BeanShell Hash Invocation in Joget

Explorer — Sun, 26 Apr 2026 12:00:09 +0000

1. Why This Is Useful

When you need to call another BeanShell helper dynamically, hash invocation keeps your main script small and reusable.

This pattern builds a hash string at runtime, executes it with AppUtil.processHashVariable, and captures the output for reuse.

2. Where to Use in Joget

Workflow Tool scripts that need reusable helper logic.
Form/Post-processing scripts that call another BeanShell utility.
Notification-related scripts where output from another function is needed first.

3. Core Idea

Build the hash string with required parameters.
Execute it through AppUtil.processHashVariable(...).
Use returned value in logs, payloads, or downstream logic.

Example hash format used:

#beanshell.captureResponseNotification[process_id=YOUR_PROCESS_ID]#

4. Full Working Code

import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;
import org.joget.apps.app.model.AppDefinition;
import javax.servlet.http.HttpServletRequest;
import org.joget.workflow.model.WorkflowAssignment;
import org.joget.apps.app.dao.UserReplacementDao;
import org.joget.apps.app.model.UserReplacement;
import org.joget.directory.model.User;
import org.joget.directory.model.service.DirectoryManager;
import org.joget.workflow.model.WorkflowProcess;
import org.joget.workflow.model.service.WorkflowManager;
import org.joget.workflow.util.WorkflowUtil;
import java.util.HashSet;
import java.util.Collection;
import org.json.JSONObject;
import org.json.JSONArray;
import java.net.HttpURLConnection;
import java.net.URL;
import java.io.OutputStream;
import java.nio.charset.StandardCharsets;
import java.io.InputStreamReader;
import java.io.BufferedReader;
import java.io.File;
import java.io.IOException;
import org.joget.apps.form.service.FileUtil;
import java.util.Base64;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;


/*
// c_code #variable.branch_code# and locale
public String getBranchName(String locale){
    String callHashToInsertResponse = 
    "#beanshell.getComplaintDetailsForEmail[c_code=" + "#variable.branch_code#" + "&locale="+ locale + "]#";

    // Evaluate hash
    String result = AppUtil.processHashVariable(callHashToInsertResponse, null, null, null);

    return result;
}
*/

String ProcessID = "process id value";

// build valid hash format
String callHashToInsertResponse = 
    "#beanshell.captureResponseNotification[process_id=" + ProcessID + "]#";

// Evaluate hash
String result = AppUtil.processHashVariable(callHashToInsertResponse, null, null, null);

LogUtil.info("Email Integration - API", "Evaluated Hash = " + result);

5. Quick Validation Checklist

Verify the target BeanShell function name is correct.
Confirm all required parameters are included in the hash.
Log output once to validate returned value.
Test with safe sample process IDs before production use.

6. Security and Publishing Note

Replace real process IDs, variable names, and function names with placeholders in public content.
Avoid exposing internal workflow naming conventions.

7. Final Note

This is a strong pattern for reusable Joget scripting: one script orchestrates, another script handles details, and hash invocation connects both.

Follow-up topic: Building a shared BeanShell utility library for multi-process reuse.

Convert Joget Signature Field to Image (Generic Dynamic Table, Field, and ID)

Explorer — Sun, 26 Apr 2026 11:55:35 +0000

1. Why This Is Useful

Joget signature fields store stroke data (JSON), but many use cases need a real image output.

This script converts signature JSON into a PNG image and returns it as a Base64 data URL.

The best part is that it uses dynamic table, field, and id parameters, so you can reuse the same code anywhere without rewriting logic.

Use this when you need to:

preview a signature directly in a form or report,
embed signature image in email/PDF templates,
avoid custom external conversion services.

2. Where to Use in Joget

Form Builder: BeanShell script in a formatter/element that needs image output.
Userview/Report: render returned data URL as image source.
Workflow tools: generate signature image before notifications or documents.

3. Required Input Parameters

Pass these parameters to the script:

table: form table name
field: signature field column
id: record ID

Because these are dynamic inputs, the same script can work across multiple forms and modules.

Example usage pattern:

#beanshell.generateSignature[table=your_table&field=your_signature_field&id=your_record_id]#

4. Full Working Code

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;

import java.awt.BasicStroke;
import java.awt.Color;
import java.awt.Graphics2D;
import java.awt.RenderingHints;
import java.awt.image.BufferedImage;
import org.json.JSONArray;
import org.json.JSONObject;
import javax.imageio.ImageIO;
import java.net.URLDecoder;
import java.util.Base64;

import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;

// --------------------------------------------------
// Input parameters
// #beanshell.generateSignature[
//   table=app_fd_cpa_comp_question&
//   field=c_consumer_signature&
//   id=UUID
// ]#
// --------------------------------------------------


public String generateJSON(String table, String fieldName, String recordId){
    String callHashToInsertResponse = 
    "#form." + table + "."+ fieldName +"["+ recordId +"]?url#";

    // Evaluate hash
    String result = AppUtil.processHashVariable(callHashToInsertResponse, null, null, null);

    return result;
}



String tableName = table[0];
String fieldName = field[0];
String recordId  = id[0];

LogUtil.info(
    "generateSignature",
    "Params -> table=" + tableName + ", field=" + fieldName + ", id=" + recordId
);

LogUtil.info(
        "Image URL : ",
        generateJSON(tableName, fieldName, recordId)
    );


//Here defines the signature image size
int width = 200;
int height = 80;

try {
    String jsonstr = URLDecoder.decode(generateJSON(tableName, fieldName, recordId), "UTF-8");
    JSONArray jarr = new JSONArray(jsonstr);
    BufferedImage offscreenImage = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
    Graphics2D g2 = offscreenImage.createGraphics();
    g2.setColor(Color.white);
    g2.fillRect(0,0,width,height);
    g2.setPaint(Color.black);
    g2.setStroke(new BasicStroke(2));
    g2.setRenderingHint(RenderingHints.KEY_ANTIALIASING, RenderingHints.VALUE_ANTIALIAS_ON);
    for (int i = 0; i < jarr.length(); i++) {
        JSONObject jobj = jarr.get(i);
        g2.drawLine(jobj.getInt("lx"), jobj.getInt("ly"), jobj.getInt("mx"), jobj.getInt("my"));
    }

    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    ImageIO.setUseCache(false);
    ImageIO.write( offscreenImage, "png", baos );
    baos.flush();
    byte[] imageInByte = baos.toByteArray();
    baos.close();   
    String base64bytes = Base64.getEncoder().encodeToString(imageInByte);
    String src = "data:image/png;base64," + base64bytes;

    return src;
} catch (Exception e) { }

5. Quick Validation Checklist

Signature exists in selected record.
Script returns value starting with data:image/png;base64,.
Image renders correctly in form/userview/report.
Empty/invalid signature JSON is handled safely in your UI.

6. Security and Publishing Note

Replace real table names, field IDs, and record IDs with placeholders in public posts.
Do not publish internal schema naming conventions if they reveal business context.

7. Final Note

This is a practical conversion pattern when your workflow needs image output from Joget signature strokes without adding external services.

Follow-up topic: Auto-attach generated signature images in Joget email notifications.