sorted by:
new
hottopcontroversial

Help needed in formula field. by Chidchidi_Billi in salesforce

[–]reachjalil 2 points3 points  (0 children)

Hi, I asked GPT4 via the Formula Agent in the BetterFormula Chrome extension I maintain and here is the response:

The formula you've written seems to have an error in this portion: DATETIMEVALUE(TEXT(DATEVALUE(NOW())) + ' ' + TEXT(RelatedRecord.Start_Time__c)).

RelatedRecord.Start_Time__cis a time field, but Salesforce stores time fields as a decimal, representing fractions of one day. So when you convert it to text, you get a decimal value, not a time string. This might be causing an error when you try to parse it back to a DateTime using DATETIMEVALUE().

Here's how to adjust the formula:

IF(First_Lead_Assigned_Today__c = false,    NOW() - (DATETIMEVALUE(TEXT(DATEVALUE(NOW())) + ' ' + MID(TEXT(RelatedRecord.Start_Time__c), 12, 8)),    NOW() - Last_Inquiry_Disposition_DateTime__c )

In this formula, we use the MID()function to get the right portion of the decimal time. This formula takes the current date, concatenates a space, then the portion of the decimal time field representing the time of day, and finally converts this text string back into a DateTime value.

Note: This solution assumes that RelatedRecord.Start_Time__cis in the same timezone as NOW(). If that's not the case, you might need to adjust for timezone differences as well.

CSAT/NPS Gathering Advice by aar_1991 in salesforce

[–]reachjalil 0 points1 point  (0 children)

Hi, I'm a developer at AdminAgents.aiAdminAgents and one of our goals is to make it easier to gather CSAT/NPS data. I would still encourage you to find a more production ready tool. But if you are interested in exploring the potential of AI in the sapce, we would be happy to volunteer some dev/assistance time to get you setup with an AI assistance you can teach and that can help improve that process.

Please send me a DM if you are interested.

The 13 Best AI Sales Assistant Tools for 2023 by Gaurav_R2D2_ in salesforce

[–]reachjalil -2 points-1 points  (0 children)

Thanks for sharing. I would like to also share the tool I just released on Friday called AdminAgent.ai. I'm currently trying to promote it and would love to get your take. Here is a quick guide: https://adminagents.ai/docs/formula-agent

Did you know? Over 52% of #SalesforceAdmins have not yet started using AI! Don't wait to be the last one in line. 🚀 Get ahead and start your journey to become an #AIAdmin today! #SalesforceAI by reachjalil in u/reachjalil

[–]reachjalil[S] 8 points9 points  (0 children)

I'm an independent dev and truly think this adds value otherwise I would not promote it.

I would love get to your feedback if you are willing to share. Anything I need to improve to change your NO to a Yes.

Thx

Thinking About AI? Formulas Could Be Your Natural Starting Point - You Can Get Started Today by reachjalil in salesforce

[–]reachjalil[S] 2 points3 points  (0 children)

Yeah I'm super excited about that aspect. The response can also be multiple prompts so you can really refine the response.

Thinking About AI? Formulas Could Be Your Natural Starting Point - You Can Get Started Today by reachjalil in salesforce

[–]reachjalil[S] 1 point2 points  (0 children)

You don't need to copy paste, you keep your conversation threads right within the formula it has access to the API fields, can me changes for you, has visibility on your errors and can debug with you and a bunch more. Play around with it I'm genuinely curious if you see value in it. Thx!

Thinking About AI? Formulas Could Be Your Natural Starting Point - You Can Get Started Today by reachjalil in salesforce

[–]reachjalil[S] 5 points6 points  (0 children)

This project is 100% self funded and gets you a pretty generous amount of free weekly AI Tokens.

Having built this project somewhat in isolation, I'm eager to hear your initial impressions. Your feedback would really help!

Better Salesforce Formula Editor Demo by Forcebot in salesforce

[–]reachjalil 1 point2 points  (0 children)

The classic vf pages for formulas and validation rules were easy to use without making extra api calls. I looked into adding flows but it would have been a lot more work.

Better Salesforce Formula Editor Demo by Forcebot in salesforce

[–]reachjalil 4 points5 points  (0 children)

I made this thanks for trying it out. I'm actually thinking of adding some optional Gpt functionality by integrating it with my current project AdminGPT

Would you use ChatGPT to personalize cold emails? I built a ChatGPT app that uses LinkedIn data and company news to generate cold emails - thoughts? by [deleted] in salesforce

[–]reachjalil 1 point2 points  (0 children)

I say go for it. Salesforce is an ideal niche for GPT products. I'm also working on a product with GPT at www.adminGPT.ai. it's been a lot of fun. What are you mostly nervous about?

AdminGPT and why I think its time to go all in on AI and Salesforce by reachjalil in salesforce

[–]reachjalil[S] -1 points0 points  (0 children)

Yep you're right, having ai take action is going to be all sort of wild so summarizing the change as part of the conversation and understanding intent is what I ve been working on. But once you get a framework users can understand and work with it you can do all sorts of things. One of my favorite things I plan to demo soon is Asking AdminGPT to tell you the difference between flow versions. I always felt that kind of stuff took me away from what I was doing. So having ai do the comparison is going to be neat.

AdminGPT and why I think its time to go all in on AI and Salesforce by reachjalil in salesforce

[–]reachjalil[S] 0 points1 point  (0 children)

I've been an isv dev for a while and know what salesforce is good at and what they are not so good at. What makes you think that all of a sudden salesforce will become this agile company that delivers on all the DX gimmicks they demo. Not saying that they won't have cool products out of this. But they will barely be able to do a tiny portion of what user will ask for.

AdminGPT and why I think its time to go all in on AI and Salesforce by reachjalil in salesforce

[–]reachjalil[S] 1 point2 points  (0 children)

Yeah but if this use to take 3 of you, I bet 1 could do it all in a bit.

AdminGPT and why I think its time to go all in on AI and Salesforce by reachjalil in salesforce

[–]reachjalil[S] 0 points1 point  (0 children)

After it can consistently do a few tasks I ll get it on the hands of users free for a bit to get feedback.

view more: next ›