DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-" &
If(
IsBlank(
Max(
Filter(
Table,
StartsWith(Column, DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-")
),
Value(Mid(Column, Len(DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-") + 1, Len(TrialCode)))
)
),
1,
Max(
Filter(
Table,
StartsWith(Column, DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-")
),
Value(Mid(Column, Len(DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-") + 1, Len(TrialCode)))
) + 1
)
With(
{
_Year:
Mod(
Year(Today()),
100
) & "-",
_Name: DataCardValue7.Selected.Name
},
With(
{
_Code:
Filter(
'AGTRS Trial Request Tables',
StartsWith(
TrialCode,
_Name & _Year
)
)
},
_Name & _Year &
With(
{
_Max:
Max(
_Code,
Value(
Mid(
TrialCode,
Len(_Name & _Year) + 1,
Len(TrialCode)
)
)
)
},
If(
IsBlank(_Max),
1,
_Max + 1
)
)
)
)
DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-" &
If(
IsBlank(
Max(
Filter(
'AGTRS Trial Request Tables',
StartsWith(TrialCode, DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-")
),
Value(Mid(TrialCode, Len(DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-") + 1, Len(TrialCode)))
)
),
1,
Max(
Filter(
'AGTRS Trial Request Tables',
StartsWith(TrialCode, DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-")
),
Value(Mid(TrialCode, Len(DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-") + 1, Len(TrialCode)))
) + 1
)
With(
{
_Year: Mod(Year(Today()), 100) & "-",
_Name: DataCardValue7.Selected.Name
},
With(
{
_Table:
Filter(
'AGTRS Trial Request Tables',
StartsWith(TrialCode,
_Name & _Year,
)
)
},
_Name & _Year &
If(
CountRows(_Table) = 0
Value(
Mid(
TrialCode,
Len(_Name & _Year) + 1,
Len(TrialCode)
)
),
1,
Max(
_Table,
Value(
Mid(
TrialCode,
Len(_Name & _Year) + 1,
Len(TrialCode)
)
) + 1
)
)
)
)
With(
{
_Year: Mod(Year(Today()), 100) & "-",
_Name: DataCardValue7.Selected.Name
},
With(
{
_Table:
Filter(
Table,
StartsWith(
Column,
_Name & _Year
)
)
},
_Name & _Year &
If(
CountRows(_Table) = 0,
Value(
Mid(
Column,
Len(_Name & _Year) + 1,
Len(TrialCode)
)
),
1,
Max(
_Table,
Value(
Mid(
Column,
Len(_Name & _Year) + 1,
Len(TrialCode)
)
) + 1
)
)
)
)
DataCardValue7.Selected.Name &
Text(Year(Today()) Mod 100) &
"-" &
(
Max(
ForAll(
Filter(
Table,
StartsWith(Column, DataCardValue7.Selected.Name & Text(Year(Today()) Mod 100) & "-")
),
Value(Mid(Column, Len(DataCardValue7.Selected.Name & Text(Year(Today()) Mod 100) & "-") + 1, Len(Column)))
)
) + 1
)
)
DataCardValue7.Selected.Name &
Mod(Year(Today()), 100) &
"-" &
If(
IsBlank(
Max(
Filter(
Table,
StartsWith(Column, DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-")
),
Value(Mid(Column, Len(DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-") + 1, Len(Column)))
)
),
1,
Max(
Filter(
Table,
StartsWith(Column, DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-")
),
Value(Mid(Column, Len(DataCardValue7.Selected.Name & Mod(Year(Today()), 100) & "-") + 1, Len(Column)))
) + 1
)