• RD@SF
  • SMARTIE
  • 1108 Points
  • Member since 2016

  • Chatter
    Feed
  • 36
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 332
    Replies
Hello,

I have a custom object where an record can have child and in turn child can have one more child ,could any one help me with the logic to retrieve all the child records give the id of the parent record
Hi All

I have a scenario like 

If Active checkbox is checked on Class record then
Create 7 Child Future (Date >= today) coaching session records 
The Date range will determine the class date for Coaching Session record
The Date range will be generated from First Class Date field on the Class Record
For e.g. if an active Class record is created with a First Class Date of 1/9/2017
Then generate a date range with +7 days from this date
So the date range will be 1/9/2017 to 1/16/2017
Loop through this date range 
check if the date is in future
if yes then create a Coaching Session Record with class id pointing to the newly created or update class
1. I want to generate a receipt into excel by clicking a "generate reciept" button on a custom object
2. I want a second button "send email" to send an email from a custom object. The email will be sent using email template I created. 

Any ideas?
I'm trying to create a validation rule in order to get an error message if at least one of my all picklists' is blank. I tried to create it with AND() connector instead of the fact that this connector only support two conditions :
 
AND(AND(AND(ISPICKVAL( Visite_Effectu_e__c ,"Oui"),ISBLANK( Dur_e_Visite_Minutes__c )),ISBLANK( Interlocuteur_Pr_nom_Nom_1_del__c)),AND(AND(ISPICKVAL(Fonction_1__c ,""),ISPICKVAL( Pr_sence_d_un_rayon_libre_acc_s__c,"")),ISPICKVAL( Pr_sence_borne_anti_vol__c ,"")))
The logic behind this formula is :
 
AND ( AND ( AND (A,B) , C ), AND ( AND (D,E) , F ) )
If one of A, B, C, D, E or F picklists' is blank, you can't end the report and get an error.

If it's not clear, i can re-explain my problem or my formula ! 

Thank you for your help ! 
 
I would like to build a query where i can combine the follwoing three in to on query that is used for  record types prospect and member. any advice?

AND(
(RecordType.Name = "Prospect"),
OR(
ISBLANK( PersonMailingCity),
ISBLANK( PersonMailingStreet ),
ISBLANK( PersonMailingPostalCode )),
(NOT($User.BypassVR__c) && 
 
NOT( OR( ISBLANK(Phone ), REGEX( Phone ,"(\\D?[0-9]{3}\\D?)[\\s][0-9]{3}-[0-9]{4}"))))
 
NOT($User.BypassVR__c) && ($RecordType.Name = "Member" || $RecordType.Name = "Prospect") && ISBLANK( FirstName)
Hello,

I created a flow and a button to launch it.
The flow was debuged and works perfectly. But when I try to launch it using a custom button I receive an error:

"We can't launch this flow because of a variable error. Send this error message to your admin. The value 19/12/2019 is being provided for variable TermEndDate but isn't compatible with the variable's data type (Date)...
As you can see the value is Date type. I doubled checked that the field referenced is indeed Date type.

Can anyone please direct me to how to solve this?

Thanks,
Tal
I created a button "Send Email" that starts a Flow on an Opportunity. 

I created a Record Lookup element in the flow and created variables for the Opportunity field I want to capture. I created 30 variables.

Is there a way to display only the Opportunity fields that are ISBLANK on another Screen element? If yes, how would I accomplish this? Do I need to create a formula? I currently have 30 Opportunity fields I want to check. 

I created the Flow to ensure a user could check to see if they entered information in all fields.

Any help will be greatly appreciated. 

 

Hi there

I am looking to create a flow that updates a coupon code field with a coupon code based upon a sales price field.

There are 700 coupon codes and I need to create a formula or some flow that will update the coupon code field with the correct code based upon the value in the sales price field.

SAMPLE:

 Coupon value Coupon code
 £         100.00  u01ya
 £         110.00  qujrz
 £         120.00  44i77
 £         130.00  l4kua
 £         140.00  wdxk1
 £         150.00  5hotf

could someone help me with creating the formula logic to update a flow variable with the coupon code or advise on the best way to get this to work?  I tried process builder but it gets very flow and unusable as the size grows.
Hello,

I have a scenario, I have a parent object 'A' with fields DateTime, User(Lookup),Address and child object 'B' with same fields.
How to restrcit user to create only one record per day? User can create multiple records for the same parent for the same day.


Welcome to youe suggestions!

Thanks,
Nilesh
I have a visual flow where I am adding screen choice feilds together in a formula.  It allows me to add them together as long as the screen choices are answered in the flow. The flow skips questions depending on answers though.  How do I get a flow formula to add all of my screen choices together even if a screen choice is bypassed?
I am trying to display a list of records that contain a keyword in my flow (variable assigned in the previous screen). I know that I need to use a Sobject Collection but I am unsure how to display those results. Can someone please help point me in the right direction?
Thanks!
Hi
I have the following text field value in excel file:
20170320

I would like to convert it to a date field value when uploading files using Apex class & Visualforce Page:
03/20/2017

Thanks

 
Hi Everyone. I have a requirement where I need to use a Workflow time trigger to fire after 24 hours (1 day) of the criteria being met. But, this needs to consider Holidays and exclude them when executing the time trigger, for e.g. when the next day (since time trigger is set for 1 day, so next day) is a Holiday, it must fire after 2 days.

Note: We do not need to exclude weekends (Saturdays and Sundays) but only the Holidays must be excluded.

I have come accross some articles that talk about using a custom formula field and the time trigger to execute based on that formula field but most cases exclude weekends (which I do not want) as well and/or do not consider excluding Holidays.

Any ideas around how to acheive this will be largely helpful.

Thanks,
Sharique
Hi Folks,
I have created a Custom field(abc__c) in Case object. This field will have a unique value per case just like the Case ID.
I want to construct a URL which uses this custom field abc__C, and not the record id of the Case. When the user clicks on the URL the case record should open as per users permissions. 
I have a VF page. There is a Link called Add Contact on VF page. When user clicks on Add contact, it should redirected to standard contact form page,. Then user enter some data and clicks on save. When he clicks on save, it should return Recordid. How i can acieve this. Is there any possibilities. Please help me on this.
I need reccomendations and if possible price indication for someone to develop an Apex code to handle the above requirement