How to add days in current date for mysql

[ankitbat]

Hello Team,

I want to give 10 days free trial to my software to the user who made the payment of some amount in Razorpay. But I am not getting how to add 10 days in local date variable kindly help me on that.

 

[Pabblymember11]

Hey @ankitbat

Could you kindly provide the URL of the workflow in which you attempted the same process? This will allow us to assess the feasibility of replicating the action within that specific workflow.

 

[ankitbat]

Here is the link of my workflow

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

I want to insert the value into mysql but my date is showing current date but I want to add current date + 10 days.

 

[Pabblymember11]

To address your concern effectively, the Date Time Formatter action step provides a solution by allowing you to effortlessly add a period of 10 days to the current date.

 

[ankitbat]

Hello, Thanks for the help. It is working properly into my system now.

But I have another issue kindly suggest for that too.

Problem Statement : I have a pabbly workflow where I want to generate the password based on the email address let say if the email address is [email protected] I want the password to be abc@1234 suggest how to achieve it.

 

[Pabblymember11]

Utilizing the Code action step along with JavaScript code enables you to accomplish the desired outcome. Please consult the provided screenshot for reference on how to proceed.

function generatePasswordFromEmail(email) {
// Extracting the username part from the email address
const username = email.split('@')[0];

// Generating the password by appending '@1234' to the username
const password = `${username}@1234`;

return password;
}

// Example usage:
const emailAddress = '[email protected]';
const generatedPassword = generatePasswordFromEmail(emailAddress);
return(`${generatedPassword}`);