ContributionsMost RecentMost LikesSolutionsRe: Duplicate Record with attachementsIt is possible to have the a link to the attachment but I was trying to avoid having another table just for attachments. And yes it is the same file and the expectation is that the file attachment could be edited with a new versions as certifications do get updated. ------------------------------ Russel Ndip ------------------------------ Duplicate Record with attachementsI have an application that is tracking regulatory approvals for several of our products. An approval can be applied to several products within the same family. Currently, multiple records have to be created manually with the same information and file attachment but a different product name. I am trying to automate this so that the user will be able to select multiple product names from a multi-select field and with the corresponding information and attachment and multiple records get created for each one of the products selected. I understand this is possible but how do I do this where I can get the document attached as well? Aprreicate any help! ------------------------------ Russel Ndip ------------------------------ Re: URl button to show report in a different applicationWhen you say create an ask the user report to ask questions about the filter. Do you mean create a report within the table I want to filter the report on or create another table to do this? I guess my problem or question is I'm not sure how generate a report from user input from within one application in the first place. ------------------------------ Russel Ndip ------------------------------ URl button to show report in a different applicationI have two applications that connected and I would like to create a url button in a table in one application that shows a filtered report from another table in a different application based on some criteria entered, I'm not well versed in formula urls, is this possible? ------------------------------ Russel Ndip ------------------------------ Re: Create Automation that adds value to multi select field if it doesn't existHaving done this method, the dynamic filter lists all the possible values instead of each values separately. For example 1. US ; Mexico 2. US 3. Mexico unlike the filter for a regular multi-select field that would just list US and Mexico separately whether or not a record had both values selected. Is there a way to fix that?Re: Create Automation that adds value to multi select field if it doesn't existThanks you! this helps!Re: Create Automation that adds value to multi select field if it doesn't existThe reason I wanted to try and avoid this method is that I need that field to still be a dynamic filter, and I've noticed that summery text fields don't have that ability.Create Automation that adds value to multi select field if it doesn't existI have a product table and a certification report table. They have a one to many relationship where products can have many certification reports. In my product table there is a field "Product certifications" that is a multi-select field. This field is populated by a list that is identical to a multiple choice field in certification report table called "certification name". So essentially "Product certifications" should be an aggregate for all the certification names in the certification report table for that specific product. I want to automate this process I want a way to automate that for every record I add or modify in the certification reports table, I want thecertification name from the record to the "Product certifications" field to add (not replace) to that field if it doesn't already exist.One field that can be a reference field for multiple tablesI have 3 tables that I'm trying to link device1 device2 approval Two of my tables are different kinds of devices each of these devices can have an "approval" which is my third table. I've linked device1 to the approval table using device name as a reference field in approval table. However I want to know if I can use device name again as a reference field for device2 table? i want that field to be populated with input from several tables.