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.
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.
How to create clickable File Auto-fill Lookup
How to create clickable File Auto-fill Lookup
- Attachments
-
- Screen Shot 2021-07-03 at 9.09.27 AM.jpg (138.27 KiB) Viewed 1155 times
Zala.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.
Re: How to create clickable File Auto-fill Lookup
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
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
Re: How to create clickable File Auto-fill Lookup
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.
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.
Appgini 24.10.1579, MacOS 14.3.1 Windows 11 on Parallels.