This topic is 1879 days old. Please don't post here. Open a new topic instead.
I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value.
When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great!
But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working.
Any ideas how this can be solved?
By Tony Diaz
The Genre data is already arranged like this:
Genre::ID (Unique Key)
The Platform data is 'simple'. ID and Name. But each item could be multiple platforms. (Example #1 vs. Example #2)
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 this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them.
Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options.
This one has just one sub-option per category.
Example 2: The Gameplay Genre Category has two sub-options related to it.
Example Genre Table content:
Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way.
Would each of those Genre Categories be portals showing only their related category ID?
I presume that I would add fields to the Items::Table so I can pull related records:
But those only support one relationship.
Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
This should be easy, but my brain just won't cooperate!
I'm moving a bunch of stuff and want to inventory what is in each moving container. I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child records describe each piece of equipment in the container. I have a portal with the child records showing for each container, but want to put anatto-entered item number for each piece that has the container number followed by a dash and then followed by a serialized number for each item in that particular container. For example, I would have container 1 labeled "Glassware" and Container 2 labeled "Chemicals". In Container 1's portal I'd like to see:
Item Description Qty
1-1 Beakers, 500ml 4
1-2 Beakers, 250 ml 2
and in Container 2's portal I'd like to see:
Item Description Qty
2-1 Potassium 4 g
2-2 Sodium 26 g
I'd like to auto-fill the item numbers, but can't figure out how to reset the serialization for each parent record.
Any help is greatly appreciated.
Thanks and keep yourselves safe!
By Randy Bennett
Yes, I did say iPhone 5 -
I have a small database i created that has a few portals on different layouts - Everything works fine on my Mac, fine on my iPhone X, even fine on my iPad mini
However, I need it to also work on an old iPhone 5 and the portal data is just blank - nothing. In fact, I really ONLY need it to work on this old iPhone 5 (This particular database will go to a music festival to be used by several other people and I can't give them my iPhone)
I have another layout with different portals that are working on the iPhone 5 - but not this main screen.
I have made sure that all of my fields are small and inside the portal. - So, I am stuck as to why? BTW - It is Filemaker Go 184.108.40.2066 (The latest version that I can install on an iPhone 5)
Who Viewed the Topic1 member has viewed this topic:CatLady001