ContributionsMost RecentMost LikesSolutionsRe: Multi-Select Fields with Commas in Pipelines Thanks for the suggestion and confirming this is a repeatable issue! The Make Request step has always been a bit over my head but with the example you provided I was able to get it to work. Thank you so much! Now to hope they address the bug... Multi-Select Fields with Commas in Pipelines I have a text field in one table that I need to use to populate a multi-select text field in another table via Pipelines. The text field contains a semi-colon-delimited list of people, including their name and title separated by a comma (Person 1, AA; Person 2, BB). This format is required for our purposes and cannot be changed. I have already created a multi-select formula helper field in my original table using the Split() function to translate these values to the correct format prior to using Pipelines to copy them to the other table. In my original table, the formula multi-select values appear correctly: Person 1, AA Person 2, BB However, once Pipelines copies the value, it seems to be exploding and recreating the multi-select options and now also considering the commas to be a delimiter, so my resulting values look like: Person 1 AA Person 2 BB I assume this is a bug and not intended behavior so I will submit a support ticket, but in the meantime, does anyone have a workaround for how to get the result to populate correctly without seeing the comma as a delimiter? SolvedRe: Display Thumbnail Image When I run into these issues I try to first break down my formula into parts to figure out which part is causing the problem. Have you double checked that your file attachment field id is in fact 30? If you remove the style attributes entirely but leave the rest of the formula, does your image show up (albeit full size)? If so, your file access URL is at least correct. If so, and you remove the style attributes and just use "src = '...' width='200px'" (not inside of style) does it work? If not, try '200', '200pt', etc. (Probably just me not knowing how to use HTML properly, but I've sometimes found success with changing units). If that works, your max-height/max-width attributes may be causing the problem (I've had this happen before, but I ended up resolving it by hardcoding in the aspect ratio for scaling properly). If the image does not appear after removing the style attributes, try checking the "allow open access" box on the File Attachment field settings. This is necessary if you are wanting to insert the image into an Exact Forms Plus document or similar, but I've found it sometimes seems necessary within the application itself, too. Re: Moving Files to a Google Folder and Subfolder I agree with Chayce's approach. One word of caution from recent experience is that the system might not recognize the new folder being created for 10-15 minutes. I was using Box instead of Google Drive, but I imagine the refresh rates are similar across the systems. I spent hours trying to figure out why my Pipeline kept saying the folder I just created didn't exist until I finally realized it was a timing issue. I'd suggest keeping your folder creation and document upload Pipelines separate and running your folder creation one well in advance to ensure it sees the new folders where the documents are to be uploaded. This can be frustrating from a user perspective though, so I'd love to hear if anyone has found a way around the delay. ------------------------------ Oana Whalen ------------------------------ Re: Create Linked Assignments from Multi-Select Field Prashant, this is a brilliant solution! It may be a little more complex of a setup than we want to implement for this application, but will definitely use it to resolve some similar needs. Thank you for sharing! One question - is there a way to delete selected options with this approach while you are still adding to the list? Is this the reason for the editable text box? I know you could delete the records created via the Pipeline after saving, but wondering if there's a way to remove items before saving the record. ------------------------------ Oana Whalen ------------------------------ Re: Create Linked Assignments from Multi-Select Field Thanks, Chayce. I hadn't considered making the reports directly editable through grid edit, but that is a good thought and would serve the purpose here, if not the cleanest looking. Was hoping there might be a cleaner solution that I wasn't seeing but I had many of the same thoughts you mention about the challenges with each of the different options. Good points on the need for additional maintenance/checks if we do pursue the multi-select approach. ------------------------------ Oana Whalen ------------------------------ Create Linked Assignments from Multi-Select Field We are creating an app that is intended to track various types of presentations given by our employees. Each presentation can have multiple presenters and multiple reviewers, but also the same person may present/review multiple other presentations. It's a classic many-to-many relationship scenario, but I am not sure the usual intermediate join table is the correct approach for our current challenge. We have an Employee List table and a Presentations table. For any given presentation, we would like to have a multi-select field fed from the Employee List to select all applicable presenters, and a similar multi-select field for reviewers. Each person should then have the presentation "assigned" to them and be visible on the Employee List record, preferably as a child table or similar report link. On the Presentations table, we'd then like to have each name link to the applicable Employee record as if it's the reference field, but with multiple names in the same field. I know I could create a Rich Text field to parse out the names and create the links, but this does not assign the presentation to the employee. Is there a straightforward way to accomplish this, or do we need to abandon the multi-select approach and go with a conventional many-to-many join table? We'd like to keep the multi-select if possible as it is much quicker to enter information. Also note the listed Employees are not necessarily QB users. ------------------------------ Oana Whalen ------------------------------ Redirect/Trigger Pipeline After Closing Pop-up I currently have a formula rich text button in an app that I am using to open an Import window in a pop-up, then using the data-refresh option to refresh the page after the pop-up is closed. Is there any way without a code page to have the page be redirected to another URL after closing the pop-up instead of just refreshing? My use case is that I want to automatically trigger a Pipeline after the import process is complete. If I just trigger the Pipeline based on individual records being added, I'm running into issues of the Pipeline running multiple times simultaneously and creating conflicts and duplicate records. So my plan is to have the button open the Import window, let people run the full import, then use an API call to check a box on the form, which will subsequently trigger my Pipeline. I have a second button I can use for the API_EditRecord, but ideally would like to avoid the additional click. ------------------------------ Oana Whalen ------------------------------ Re: Using Look Up and Search in PipelinesI believe Look Up only allows you to search by Record ID, so if you have a different key field you want to use for the look up, you need to use the Search Records tool. You can cap the search results at 1 record to allow it to move on once it finds the one record you are looking for rather continuing the search. ------------------------------ Oana Whalen ------------------------------ Re: Connected Table pulling strange charactersDid you happen to enter the information on an iPhone/iPad? We've had a lot of issues with importing text entered on iOS apps into QB, as most special characters (including some spaces, tabs, even some normal letters occasionally, etc.) are encoded differently on iOS. Our typical solution has been a long string of SearchAndReplace functions to swap out the odd characters (must copy paste, not retype them) for the intended ones. There is also an option under App Properties to toggle UTF-8 encoding, we've had some limited success with changing this setting in the past, but I vaguely recall it causing other issues for us as well. ------------------------------ Oana Toma ------------------------------