Copy Attachment
Hello,
Ok so i have a table called line items. Each line item has a record specific attachment. There is a need to create copies of these line items. I know that when you use the master copy record function, attachments dont come along for the ride. So i tried approaching it a different way. Here is what i am doing
1. Using the ToText function to convert the attachment to text
2. Using the part function to pick out the URL of the file attachment
3. Using a QuickBase action to take the URL and copy it into another field.
4. Using a formula URL field to create a button of the field in step 3.
This works. When a record is copied and all of the upstream attachment data is lost, the link lives on and keeps pointing to the attachment in the original record.
The problem i am running into is with the QuickBase action criteria.
I only want the action to fire when the original record is made but not when the record copy is made. If it fires when the record copy is made then all field end up being blank [ because the field in step 2 is blank and the rest just follows ]
My question is
1. Is there a better way to do this?
2. Is there a way you can think of for me descriminate between these two cases?
Thanks a lot for your help!
Ok so i have a table called line items. Each line item has a record specific attachment. There is a need to create copies of these line items. I know that when you use the master copy record function, attachments dont come along for the ride. So i tried approaching it a different way. Here is what i am doing
1. Using the ToText function to convert the attachment to text
2. Using the part function to pick out the URL of the file attachment
3. Using a QuickBase action to take the URL and copy it into another field.
4. Using a formula URL field to create a button of the field in step 3.
This works. When a record is copied and all of the upstream attachment data is lost, the link lives on and keeps pointing to the attachment in the original record.
The problem i am running into is with the QuickBase action criteria.
I only want the action to fire when the original record is made but not when the record copy is made. If it fires when the record copy is made then all field end up being blank [ because the field in step 2 is blank and the rest just follows ]
My question is
1. Is there a better way to do this?
2. Is there a way you can think of for me descriminate between these two cases?
Thanks a lot for your help!
