Formula to view display an unlinked piece of information
I have a table named Icons, with a field within Icons named Image.
I have an unlinked table, where I would like to display the a image, for id 5 (for example)
What would my formula be? I cant semm to figure it out. I tried popupRecord, but that just would open the id, not only display the Image.
8 replies
-
Hmm.. perhaps I am not following you.. Using the sample Iconset database as an example.. I have an Iconset table.. and an "Unlinked Table". When I enter an Icon Name .. on the unlinked table.. The after update trigger pops up the associated Iconset row. Is this what you are asking?
-
Yes! Only, when I say icon, I mean actual images of icons I uploaded. But the formula used in Unlinked Table should bring up the images!
-
here is the after update trigger..
-
If you are simply wanting to display the image from a specific record in another unconnected table the the following should work in a formula:
record(Icons,5).Image
Of course I may have misread what you're trying to do...?
-
Beat me to it
. I wish the Ninox Team would add upvoting. -
@sean.. Ahh.. I misunderstood when he said only showed the ID.. I thought he meant it showed the default edit form..
And. Yes.. I would go for "upvoting" .. not only here.. but in the Change Request database as well. :)
-
@Mconneen.. I wasn't trying to disparage and it looks like you accomplished what S Moore wanted. There's usually more than one way to accomplish a computing task. I do think the record() function is underrepresented in the documentation though.
In this thread I would have simply upvoted instead of commenting if it was available.
-
@Sean.. I would have actually up voted yours.. :) As a genarl rule...the documentation is a bit light.. :)
Content aside
- 5 yrs agoLast active
- 8Replies
- 2512Views