Announcements
ForAll(
CollLang As Lang,
If(
IsBlank(Lang.ID),
// Create new
Patch(
'Languages spoken',
Defaults('Languages spoken'),
{
Language: Lang.Language,
'Language Proficiency': Lang.'Language Proficiency',
'Social Insurance Number': varsocial
}
),
// Update existing
Patch(
'Languages spoken',
LookUp('Languages spoken', ID = Lang.ID),
{
Language: Lang.Language,
'Language Proficiency': Lang.'Language Proficiency',
'Social Insurance Number': varsocial
}
)
)
)
If my answer was helpful and solved your issue, please mark it as the verified answer.
If it helped but didn’t fully solve it, I’d appreciate a like. 😊
And if you’d like to support me, feel free to buy me a coffee.
ForAll(
CollLang As Lang,
If(
IsBlank(Lang.ID),
// Create new
Patch(
'Languages spoken',
Defaults('Languages spoken'),
{
Language: Lang.Language,
'Language Proficiency': Lang.'Language Proficiency',
'Social Insurance Number': varsocial
}
),
// Update existing
Patch(
'Languages spoken',
LookUp('Languages spoken', ID = Lang.ID),
{
Language: Lang.Language,
'Language Proficiency': Lang.'Language Proficiency',
'Social Insurance Number': varsocial
}
)
)
)
ForAll(
CollLang,
If(
IsBlank(ThisRecord.ID),
// Create new
Patch(
'Languages spoken',
Defaults('Languages spoken'),
{
Language: ThisRecord.Language,
'Language Proficiency': ThisRecord.'Language Proficiency',
'Social Insurance Number': varsocial
}
),
// Update existing
Patch(
'Languages spoken',
LookUp('Languages spoken', ID = ThisRecord.ID),
{
Language: ThisRecord.Language,
'Language Proficiency': ThisRecord.'Language Proficiency',
'Social Insurance Number': varsocial
}
)
)
)
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1