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

 

 

 

 

 

That's what FileMaker does when you convert a FileMaker file from an older file format and it encounters illegal characters in field names. I'm not sure what the issue is here, I wonder if it's the accented "i" in the field name. Everything should still work normally as is, but try renaming the field and see if that fixes it.

Welcome to the forums.

(Most questions are answered faster, it might have been the Spanish that scared people off, or possibly the big wall of text.)