I have a form with rows of data. All I want to do is say that if a given field in a row "description1" is not Null, then populate another field with a specified value.
otherFieldName.rawValue = "value you want to give it";
}
If there are multiple rows of this information you will have to add the row subform to the expression as well as an occurance number so it wil know which one you want . I will use i to indicate the occurance:
if (Row(i).descriptionFieldName.rawValue != null){
Row(i).otherFieldName.rawValue = "value you want tto give it";
otherFieldName.rawValue = "value you want to give it";
}
If there are multiple rows of this information you will have to add the row subform to the expression as well as an occurance number so it wil know which one you want . I will use i to indicate the occurance:
if (Row(i).descriptionFieldName.rawValue != null){
Row(i).otherFieldName.rawValue = "value you want tto give it";
The following has evaluated to null or missing:
==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41]
----
Tip: It's the step after the last dot that caused this error, not those before it.
----
Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
----
----
FTL stack trace ("~" means nesting-related):
- Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5]
----
