02-07-2024 10:29 AM
Hello,
I have a Dashboard that has an attachment button, setup as "File Upload" to the Application Database. We want the client to be able to attach files (this part is working).
Due to the number of attachments, every file that is attached, will have to be tagged to a Text field for a specific Member. We'd like to tag multiple files on a single text line, separated by commas.
Has anyone done something similar? How did you go about this?
Thank you for your time.
Solved! Go to Solution.
02-08-2024 12:01 PM
As @RobbSalzmann said, this doesn't seem like a good idea.
If you don't want to go to the trouble of managing a custom table, why don't you simply organise the files in folders, each folder being named after a Member? Then, instead of looking up a Text property, your code will just go to that specific folder and retrieve all the files it finds.
02-08-2024 09:42 AM - edited 02-08-2024 09:43 AM
Hi @FM
While you could go through the api layer to update the text value in each member every time a file is uploaded,.
This presents some risks:
Consider another approach that uses a custom table to index and store this information. This approach will
02-08-2024 12:01 PM
As @RobbSalzmann said, this doesn't seem like a good idea.
If you don't want to go to the trouble of managing a custom table, why don't you simply organise the files in folders, each folder being named after a Member? Then, instead of looking up a Text property, your code will just go to that specific folder and retrieve all the files it finds.
02-12-2024 04:41 PM
Thank you to the both of you, I think that I am going to go with Jack's idea and setup a business tule that does that.