Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Tony Diaz

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tony Diaz

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Any (6.0.8, 7.6, 8.6, 9.1 etc), OS X, MacOS, macOS
  1. Hmmm... that JSON_cListKeys_Values0 field was because for whatever reason, I kept getting that same error message when I was trying to define the value list, so I thought maybe that it was trying to parse the formula calculation text itself, and not the result. I had the right thought then, at least. The values on the self join table only and the field content is the calculation result. I must have been selecting something wrong in the beginning, before I added that .._Values0 field. 'cause, yes, it's doing nothing. It's working now. Whatever?!?! I swear this is what I was do
  2. I'm trying to make a value based on the content of JSON_cListKeys in this specific record only: The fields involved: I get the "This Value List Won't Work... based on a calculation" message. So I tried to see if looking up the content or calculating the content and using that instead.. um.. no, it's still a calculation. I Tried changing to a calculated text field ... I get no error from the value list creator, but I still don't get actual values in the list. In order to only get the values from the current record, I created a sel
  3. Probably left over clickery from scrambling around with it.. that didn't work 😉 After messing around with this one more, I went back to the previous boilerplate file where I had gotten it to resemble what I was trying to do a bit closer.. and at least now I know how I got to that point with it. I can pick one or more of those "sub-category" genre types and only see the related choices to it as well as select multiple genres from the sub-category. What I was trying to get to with this thread is to have later edits of the Value List items reflect in the exist
  4. That's just it., and whats not working. That's how I drew it on paper, using the fk in Games, but that doesn't seem like it would provide a unique link identifier. The Games table is the one that has the ultimate unique identifier. So I changed it that which seems to push the unique value over to the that.. which yes, seems to work except I'm not sure why. Nor am I sure how to create a "unique" value for that .. so shMaybe that's the part about the relationships I'm still not understanding. I thought both values needed to match. (and they do, but I'm still not sure though, why that
  5. I think I'm in over my head. I drew this out on paper, but I can't get this to work. I'm trying to emulate the behavior below. The column on the right, "Genre, Gameplay, Prospective" .. to where I pick the item by name "Action, Arcade, Chess" etc in the first column of the portal, and it shows the associated sub category next to it. The choice would be entered by either by Genre_ID or Genre_Name and then the genre_category_id & genre_category from the same record would show with it. The unique value being 'genre_ID', and it's related to 'Game_ID' on the main table.
  6. Just want to check before I start: I want to reproduce a web page with tabs in a FileMaker layout to go along with the JSON data that's being imported. Is there some utility or such to utilize any existing markup? ... or do I just do it from scratch within the Layout Editor?
  7. Okay, it makes no sense then. I couldn't work out how it would, I just wanted to make absolutely sure there wasn't some trick voodoo way I didn't know about. That's the way the data is given according to the API docs, as I'm trying to build a local version of their classifications. I don't care about being able to report on records by group. The individual categories are fine. So it sounds like I should break that stuff up into value lists based on those Genre Categories and go with that. Hmm... unless I can make a value list from records using an additional indicator. e.g.: This val
  8. The tables. Items::ID Items::Item Items::Publisher Items::Date The Genre data is already arranged like this: Genre::ID (Unique Key) Genre::Name Genre::Category_ID Genre::Category The Platform data is 'simple'. ID and Name. But each item could be multiple platforms. (Example #1 vs. Example #2) Platforms::ID Platforms::Name An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples. It's supporting the possible multiples that I'm trying to work out. At thi
  9. I get what you're saying, but I wasn't figuring out how to structure it. I also found a custom function which looks like it would have worked right after the substitute / trim that I couldn't seem to get to do anything either: Let ([ searchStringSplit = Substitute(searchString; "*"; ¶); beginString = GetValue(searchStringSplit; 1); endString = GetValue(searchStringSplit; 2); lenBegin = Length(beginString); lenEnd = Length(endString); ptBegin = Position(text; beginString; 1; 1); ptEnd = Position(text; endString; ptBegin + lenBegin; 1) + lenEnd; lenAll = ptEnd - ptBegin; keepText =
  10. Trying to capture text from the web viewer: I want to get "On-Line Systems" Usually this kind of stuff is just right after the "Published by", but since this is a hyperlink it's got varied contents between that and the actual string I want. ;">Published by</div><div style="font-size: 90%; padding-left: 1em; padding-bottom: 0.25em;"><a href="https://www.mobygames.com/company/sierra-entertainment-inc">On-Line&nbsp;Systems</a></div><div With this script I can capture "<div style="font-size: 90%; padding-left: 1em; padding-bot
  11. ✔️ ... and now it works. Funny. Nothing I read about that function in the context of a summary said anything about storage.
  12. As I noted above, and then the post afterwards was speculation that didn't work anyway. So the question still stands. I'd like a running total of amount of Items, Vendors and Developers. Not the found set. The actual amount of rows/records. That can be counted by the ID in the respective table, but how to get them to show all on any layout where that field is placed. I think I even tried merge fields. I can only get the total Items on the Items layout, Vendors on the Vendors layout, etc. Otherwise I get zeros.
  13. ...and that would be a Summary Field... Imagine that! Doh! ...that I'm imagining needs to be assigned to a global variable as each is only working for only the table that is selected for that layout. ...and then a trigger that if that value changes. Or can I do a summary as a calculation so I can then Set Variable $$Name right afterwards?
  14. Good points, yeah- I just figured I'd 'round it out' and make the same work from either approach. So I know I can do something similar from either direction. I won't set something up for someone else like that, rather I'd stick with a single method for consistency and simplicity. But in this case, I actually prefer this over the card window. Because if I type in that field and don't jump to an existing selection within a couple three key entries, or even just using the keyboard to enter something rather than picking from drop down options, I'm likely going to type in new data. This is per
  15. Thanks! Using your example, my Vendors is Parent and Items is Child. (Attached) I see that part of it doesn't depend on scripting at all.. If pick a different Vendor ... (Picking ABC Direct) It will update the Vendor_IDfk field as selected. (Perfect) But if I were to pick a vendor from the ID, if I want to change the yellow field I probably need to have a script trigger on that commit ... The yellow field does not update: This probably requires a script.. (...and a trigger on modify ) ...which I figured out while posting this reply... S
  • Create New...

Important Information

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