Hello, I'm trying to create a duration panel for a subscription related data fields. There are three fields Subscription Duration (Dropdown Field) Subscription Start Date (Date Field) Subscription End Date (Date Field) Wherein: Subscription Duration has the following dropdown options: 1 Month 2 Months 3 Months etc What I'm trying to setup:(Sample Scenario) Subscription Start Date = June 15, 2021 IF Subscription Duration = 1 Month, 2 Months, etc THEN add days to Subscription End Date Expected Result: Sample A Subscription Duration: 1 Month Subscription Start Date: June 15, 2021 Subscription End Date: July 15, 2021 Sample B Subscription Duration: 3 Months Subscription Start Date: June 15, 2021 Subscription End Date: September 15, 2021 Does anyone know the Sugar Logic Formula to do this?

Hello Jean Pierre Rojas , Using SugarLogic you could try something like this formula on the subscription end date field: addDays($subscription_start_c,number($subscription_duration_c)) To have this working your ' Subscription Duration ' will need to have the number of days for each value, something like this: This would be the end result: Does this work for you?

I’d probably do this with a business rule that was triggered with a simple process, or a simple field change in a business process.

How To Add Days Based On Another Date Field?

Jean Pierre Rojas over 3 years ago

Hello, I'm trying to create a duration panel for a subscription related data fields.

There are three fields

Subscription Duration (Dropdown Field)
Subscription Start Date (Date Field)
Subscription End Date (Date Field)

Wherein:

Subscription Duration has the following dropdown options:
- 1 Month
- 2 Months
- 3 Months
- etc

What I'm trying to setup:(Sample Scenario)

Subscription Start Date = June 15, 2021
- IF Subscription Duration = 1 Month, 2 Months, etc
- THEN add days to Subscription End Date

Expected Result:

Sample A

Subscription Duration: 1 Month
Subscription Start Date: June 15, 2021
Subscription End Date: July 15, 2021

Sample B

Subscription Duration: 3 Months
Subscription Start Date: June 15, 2021
Subscription End Date: September 15, 2021

Does anyone know the Sugar Logic Formula to do this?

Parents

+1 Bud Hartley over 3 years ago

I’d probably do this with a business rule that was triggered with a simple process, or a simple field change in a business process.

Bud Hartley | Cape Foulwind, NZ (and Oregon, USA)
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel
0 Jean Pierre Rojas over 3 years ago in reply to Bud Hartley

Hi Bud, I also tried re-reviewing our options for the setup, and we tried the Process Definition setup, and it also works!

For reference for everyone who will come across the same issue.

You can create a Change Field action and then configure for date field to be updated with the following formula:

{{subscription_start_date}} + 1m*

* 1m is a constant. You can create it via Constants > Timespan > Select from the available options.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jean Pierre Rojas over 3 years ago in reply to Bud Hartley

Hi Bud, I also tried re-reviewing our options for the setup, and we tried the Process Definition setup, and it also works!

For reference for everyone who will come across the same issue.

You can create a Change Field action and then configure for date field to be updated with the following formula:

{{subscription_start_date}} + 1m*

* 1m is a constant. You can create it via Constants > Timespan > Select from the available options.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Bud Hartley over 3 years ago in reply to Jean Pierre Rojas

Hi Jean Pierre,

I apologize for my slow response. Yes! The change field trigger and the formula will do what you want. I'm so glad you have the solution! Cheers.

Bud Hartley | Cape Foulwind, NZ (and Oregon, USA)
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel