Expand my Community achievements bar.

SOLVED

First time IF user - the lessor of two choices

Avatar

Level 1

Hey everyone -

I need your help.

Field1 - Allowance

Field 2 - TotalReceipts

Field 3 needs to show:

IF Field1 < Field2 then show Field1's amount

IF Field1 > Field2 then show Field2's amount

I've read the LCD Scripting Basics for ver 8, but I still can't get it right. I've tried so many things my head is spinning.  Can someone please help me?

Thanks

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

Assuming you are using Javascript:

if (Allowance.rawValue < TotalReceipts.rawValue){

     Don't know what you mean by show ....but this is where that code woudl go

} else {

     show field 2 amount

}

You have not taken into account if th etwo fields are equal.

Paul

View solution in original post

2 Replies

Avatar

Correct answer by
Former Community Member

Assuming you are using Javascript:

if (Allowance.rawValue < TotalReceipts.rawValue){

     Don't know what you mean by show ....but this is where that code woudl go

} else {

     show field 2 amount

}

You have not taken into account if th etwo fields are equal.

Paul

Avatar

Level 1

Thank you pguerett. This worked perfect.

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] ----