How to create clickable File Auto-fill Lookup

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
User avatar
zibrahim
Veteran Member
Posts: 137
Joined: 2020-01-28 18:30
Location: Malaysia

How to create clickable File Auto-fill Lookup

Post by zibrahim » 2021-07-03 01:30

Good morning to all appgini community,
I have created 3 tables (alarm_list, document & alarm_doc).
alarm_list table is to store all the alarms information.
document table is to store all the documents.
alarm_doc table is to store the link between alarm and the documents related to it.
I have also created an auto-fill lookup field in the alarm_doc table hoping that I can click to view the document.
Screen Shot 2021-07-03 at 9.11.44 AM.jpg
Screen Shot 2021-07-03 at 9.11.44 AM.jpg (198.33 KiB) Viewed 1149 times
However, what I see in the child table view is only the filename.

How can I make it a clickable link or icon instead of just a filename.

Thank you and have a nice day. and stay safe.
Attachments
Screen Shot 2021-07-03 at 9.09.27 AM.jpg
Screen Shot 2021-07-03 at 9.09.27 AM.jpg (138.27 KiB) Viewed 1149 times
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.

pfrumkin
Veteran Member
Posts: 157
Joined: 2020-02-18 17:58
Location: Albuquerque, New Mexico USA

Re: How to create clickable File Auto-fill Lookup

Post by pfrumkin » 2021-07-07 20:06

Hi Zala,

I have done this without a specific correlation table. The document table is a child of my primary table, so there is a reference to the primary ID in each record of my document table. Perhaps the real issue though is the configuration of your File column. My document (column) is configured as a File Upload on the Media tab, I think that is what makes it a clickable link.

~Paul

User avatar
zibrahim
Veteran Member
Posts: 137
Joined: 2020-01-28 18:30
Location: Malaysia

Re: How to create clickable File Auto-fill Lookup

Post by zibrahim » 2021-07-09 10:36

Hi Paul,
Thanks for the explanation. I understand that if I make the document table as the child, it will make life easy.
However, if most of the parent items are having the same document as their child, it will consume storage space and updating the documents will be an endless process. That is why I have decided to have a correlation table.
Hope to find a good solution soon.
Thanks again Paul.
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.

Post Reply