Jump to content

Tony Diaz

Members
  • Content Count

    89
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tony Diaz

  • Rank
    member

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    18

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Any (6.0.8, 7.6, 8.6, 9.1 etc), OS X, MacOS, macOS
  1. As opposed to the way I have it now. This would be a bit simpler I suppose. I store the text descriptions and titles in a table and then in a separate table, I've got just the ID's in records for each record in the main table that they're associated with. If I just let it store those anyway, using the ID as the key field in that table, it will just update an existing one instead of making a duplicate or having to intercept an error because of a non-unique field entry. The script excerpt above isn't the greatest example, though the flow is the same, but if I went by Game_ID and Caption, I'
  2. It's been a little while, but something changed a few months back and now all the posts look like this when reading: I'm sure it's that topic status/metric box on the right.. was there before? I can't find a way to change any of this in the profile settings. This blows for looking at scripts and code settings as you can see, it's heavily in need of side scrolling.
  3. That works .. though I'm not 100% sure why, yet. Or.. why I shouldn't just do them all that way. That is, once it clicks with me what is exactly going on there. (I stepped away from this project for a bit, and am back to it again. )
  4. My JSON data contains dates in one of three formats: YYYY YYYY-MM YYYY-MM-DD The field is: Items::Initial_Release Instead of the text, I would like to have it display that as a proper date based on what's there. 1984: Year Only 1984-08: August, 1984 1984-08-08: 08 August, 1984 Based on the available options for formatting the date, I gather that the FileMaker Date format probably can't deal with less than the full amount of data? Or even changing it, having it be Day first if there is full data, otherwise Year, or Year, Month only.
  5. Also, does it have a time limit on it? .. since it's been a little while now, is it worth messing with? As for HostGator. They use CentOS, so it shouldn't be any issue to do.
  6. A global field ... in the table that is on the layout where the target records are I gather, before the loop happens? Set Field [ Moby_Screenshots_Meta::GlobalField ; JSONGetElement ( $record ; "caption" ) ] ..and something instead of the New Record / Request? I'm not having too much success with finding examples of scripting / updating existing records. I'm having a mental block with it at the moment.. hopefully it will come to me.
  7. I've got this to skip existing records when parsing incoming JSON.. If [ not IsEmpty( $screenshots ) ] Set Field [ Moby_Games_Importer::JSON_VariableView0 ; $screenshots ] Set Variable [ $PLATFORM_ID ; Value: "5" ] Set Variable [ $MOBY_ID ; Value: Moby_Games_Importer::Game_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $screenshots ; "" ) ) ] Freeze Window Go to Layout [ “Moby_Screenshots_Meta” (Moby_Screenshots_Meta) ; Animation: None ] Set Variable [ $existingIDs ; Value: ExecuteSQL ( "SELECT Caption FROM Moby_Screenshots_Meta" ; "" ; "" ) ] Loop Set Varia
  8. I actually don't care about the order of their selection. It was more of a precursor to "They're going to be listed in that order due to the way FileMaker works" so that does not matter to me. On the values being listed from the 2nd field, I don't care what the order is at all. I'm trying to duplicate this kind of display of whatever choices I've selected: Platforms and Genre each have multiple options selected. So they're separated by commas. The others in this example are each single values. Otherwise, right now I'm doing it manually when adding them: Clicking i
  9. If I want to create a new record during a script, I need to select the layout that is associated with that desired table.. (Freeze Window.. create new record .. in the background) .. But if I just want to set fields in a particular table (set field Table::Field), If I do not change the layout, will those changes always be on the same / last record accessed on the non-visible table?
  10. This is a two part question: A Checkbox Field is the selected options from a Value List separated by a return (¶) So if I have a Value List where the options are Alpha, Bravo, Charlie, Delta ... and I've selected three of them, the field will be stored as: Bravo¶Delta¶Alpha Or visibly: Bravo Delta Charlie What I'd like to do is re-format the display of those values as "Bravo, Delta, Charlie" (obviously in the order selected, as the standard way value lists populate the fields) In the sample Filemaker file attached, the blue text are examples of how I'd like
  11. Okay, that takes care of that problem. Though, Generator does help with the repetitive bits of setting up script steps and matching them up with their fields/tables.. (which is actually a pretty cool thing in itself!) but it does come across as over-complicated if you don't know whats going on first. Not looking a gift horse in the mouth at all, but at least in my case, it made -a lot- more sense what it's doing after I understand the steps needed to do what it's doing in the first place. It makes setting up the -next- one an absolute breeze ... because I don't have to do it one field at a
  12. I can pick a file, but then there's never any tables to pick from. If I enter the name of an existing table, it tells me the file isn't open. I'm going through the video again now. Hmm.. yup, I see that. I went over those and still missed that. Interestingly, changing it doesn't change a thing. The line to get the amount of keys works, the proper chunk of code is in the $GENRESARRAY variable.. It's kinda like the layout is acting like a portal showing weird values due to funky relationship values. I can pick the file.. But I never get a list of
  13. I've tried to get Generator to work.. and the BE plugin is installed.. I still get errors.
  14. Here's the way the data is formatted. https://drive.google.com/file/d/1FJCCf0yKNeEoWfVVOVwAILFoZEGhqJ_b/view?usp=sharing The red columns are Single Records, there's 10 red lines. That's the main Array that's being parsed. Set Field [ Moby_Games_Cache::Genres_Array ; JSONGetElement ( $record ; "genres" ) ] # Insert Array for Genres Set Variable [ $GENRESARRAY ; Value: JSONGetElement ( $record ; "genres" ) ] If [ not IsEmpty ( $GENRESARRAY ) ] Set Field [ Moby_Games_Cache::Field 12 ; $GENRESARRAY // JSON_Parse_Sandbox::Game_ID ] Set Variable [ $x ; Value: V
×
×
  • Create New...

Important Information

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