Jump to content

Strange things on calculation


Anna
 Share

This topic is 2194 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

 

 

 

 

 

Link to comment
Share on other sites

  • 5 weeks later...

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.)

 

Link to comment
Share on other sites

This topic is 2194 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.