I want to create a function for lead follow up. So, thereโs a Table, โTeam and Agentsโ with a row called, โFollow-Up Date.โ There is another table called โFollowupโ, which references to โTeam and Agents.โ Each time the Owner contacts a lead I want to add a row to โFollowup.โ With the addition of a new row, a follow-up date is required, called โNext Follow-Upโ. The owner can pick 30, 60, or 90 representing the number of days from now to follow up on. In the row, Team and Agents(Follow-Up Date), we want to display the latest submission date + the latest submission dateโs โNext Follow-Up.โ
Iโm having trouble figuring this one out. This is all I have so far and I couldnโt get it to work right. Please help.
(LOOKUP(MAXROW(โFollowupโ, โDateโ, ([Agent] = [_THISROW].[Name])),โFollowupโ,"_RowNumber",โDateโ))
+
LOOKUP(MAXROW(โFollowupโ, โDateโ, ([Agent] = [_THISROW].[Name])),โFollowupโ,"_RowNumber",โNext Follow-upโ)
Are you trying to do some sort of Date/Time math here?
Or are you just trying to concatenate 2 date values into 1 text field?
If the former, I think youโll have to describe your situation in more detail.
Are you having trouble adding the 30/60/90 days to your date?
If the latter, try just changing the โ+โ in your expression to a โ&โ. Assuming both of those LOOKUP() expressions are returning the correct value separately.
Yes, I am trying to add days to a date. The problem is trying to pull the two variables in order to do the addition. The lookup functions are not working correctly.
Best,
Do the 2 LOOKUP() expression work correctly by themselves?
Is there any error shown?
Maybe try wrapping the first one inside of DATE(), and the second inside of NUMBER() to force the correct data types.
Yep.
I would actually recommend instead that you add a normal (non-virtual) column to the Followup table with an App formula expression of:
([Date] + [Next Follow-up])
Then you can just query that column directly to get the date.
The expression youโre trying to use is very, very inefficient. You absolutely do not want it in a virtual column if you care about performance.
Iโm struggling.
(LOOKUP(MAXROW(โFollowupโ, โDateโ, ([Agent] = [_THISROW].[Contact Number])),โFollowupโ,"_RowNumber",โNext Follow-Up Dateโ))
This does not return anything.
Have you tried the Test button in Expression Assistant?
The test link gets stuck in loading.
Screenshot, please.
I was using Safari. Chrome displayed it, and I got everything working. Thanks again. You rock!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |