This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,I'm trying to find MAX value from the PID column where the first 6
digits of the PID match with the Start Date. MAX( SELECT( Plan[PID],
LEFT([PID], 6) = TEXT([Start Date], "YYMMDD") ) ) am I missing
something?
I'm using LINKTOFORM() to add a new record with some fields pre-filled
from the existing row. The new record is not copying "Book ID" from the
existing row, instead, it is generating a new value using the formula
present in the Initial Value.LINKTOFO...
Hi Steve,I think I got this working by adding [_THISROW] in front of
[Start Date]MAX( SELECT( Plan[PID], LEFT([PID], 6) =
TEXT([_THISROW].[Start Date], "YYMMDD") ) ) but it started breaking my
LINKTOFORM() function as described in Solved: LINKTOFORM(...
I don't think so but when I tried to verify it, I couldn't figure it out
how to do it. Could you please help? PID type is Number so it doesn't
show the List.
