I am defining some calculations in my database file, everything is ok except one field and i cannot figure out why.
These are the steps:
If [ not IsEmpty( System::input global ) ]
Establecer campo [ Libros::Editorial; Case( IsEmpty( Libros::Editorial ) ; Let([ _json = parseJSON ( System::input global ; "publishers" ; "]" ); _list = Substitute ( _json ; "name" ; "¶" ) ]; GetValue( _list ; 2 ) ) ; Libros::Editorial ) ]
Establecer campo [ Libros::Título; Case( IsEmpty( Libros::${Título} ) ; Let([ _json = parseJSON ( System::input global ; "title" ; "url" ); _list = Substitute ( _json ; "title" ; "¶" ); _listCount = ValueCount( _list ); _title = GetValue( _list ; _listCount ) ]; Substitute( _title ; "," ; "" ) ) ; Libros::${Título} ) ]
Establecer campo [ Libros::Autor; Case( IsEmpty( Libros::Autor ) ; Let([ _json = parseJSON ( System::input global ; "authors" ; "]" ); _list = Substitute ( _json ; "name" ; "¶" ) ]; GetValue( _list ; 2 ) ) ; Libros::Autor) ]
If [ not IsEmpty( System::input global ) ]
Establecer campo [ Libros::cover_small; Let([ _url = parseJSON ( System::input global ; "small" ; "," ) ]; Case( PatternCount ( _url ; "http" ) ; _url ; "No Image" ) ) ]
Establecer campo [ Libros::cover_medium; Let([ _url = parseJSON ( System::input global ; "medium" ; "," ) ]; Case( PatternCount ( _url ; "http" ) ; _url ; "No Image" ) ) ]
End If
End If
The step that I have marked as bold is giving me headaches, i do the same thing but in this case, i getting (Table::${fieldname}) instead of (Table::fieldname ).
Any explanation, thanks, Anna
