• Tracy Oden 41
  • NEWBIE
  • 30 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 5
    Questions
  • 1
    Replies
I am trying to use External Services with Flow. The schema file includes a body. I do not know how to set the body using variables I have created. The body only allows a single apex defined variable input. There is no body apex defined variable generated by the schema. I am not sure if one is needed.

I am new at this. Any idea how to use flow to set variables to an esternal services body during a Post call out?

I am happy to share my schema file. Any help will be greatly and gratefully appreciated.
Hi, I am simply trying to add a note using the Notes object and relate it to a custom object with flow?
I woud like to simply add 15 minutes to a date and time field. How can I do this?
Hi, I have an existing formula that was working but no longer does because it is receiving an error that the forumla is too long. Can someone please help me with this forumal using CASE. 

IF(
AND(ISPICKVAL(Percent_Complete__c, "5%-9% Reviewed"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "10%-19% Initiated"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "20%-34%: Stage 1"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "35%-49%: Stage 2"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "50%-64%: Stage 3"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "65%-74%: Stage 4"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "75%-94%: Stage 5"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "95%-99%: Stage 6"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 0)), "On Target",
IF(AND(ISPICKVAL(Percent_Complete__c, "5%-9% Reviewed"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "10%-19% Initiated"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "20%-34%: Stage 1"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "35%-49%: Stage 2"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "50%-64%: Stage 3"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "65%-74%: Stage 4"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "75%-94%: Stage 5"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "95%-99%: Stage 6"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c = 1)), "On Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "5%-9% Reviewed"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "10%-19% Initiated"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "20%-34%: Stage 1"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "35%-49%: Stage 2"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "50%-64%: Stage 3"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "65%-74%: Stage 4"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "75%-94%: Stage 5"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Percent_Complete__c, "95%-99%: Stage 6"), ISPICKVAL (Status__c, "In Progress"),(Days_Late__c > 1)), "Red Alert",
IF(AND(ISPICKVAL(Status__c, "Not Started"),(Days_Late__c >= 1)), "Red Alert",

"")))))))))))))))))))))))))

Your help is greatly appreciated. I have to urgently change this formula.
Hi,

I need help with a formula that will display the dates between a start and end date. ie, if start date is June 28, 2019 and end date is July 2, 2019; then the dates in between are June 29, 2019, June 30, 2019 and July 1, 2019.
Hi, I am simply trying to add a note using the Notes object and relate it to a custom object with flow?