ContributionsMost RecentMost LikesSolutionsRe: Pipeline to Concatenate Text and Increment Numbers I didn't realize I could concatenate text with a summary field. I will look into that. No to back fill records at this point but still good to consider the relationship approach. ------------------------------ James Carr ------------------------------ Re: Pipeline to Concatenate Text and Increment Numbers Thank you, Chayce. That may be all I need. I will try to explain in more detail just in case. Emails for purchases are captured in a connected table. Another table is used to capture specific details from each purchase email. Names for the purchase are included. So, person A makes a purchase > email is captured > a pipeline creates a record with the desired details from the email. Person A makes another purchase. Rather than create a whole new record, I want to update the previously created record for person A with the additional names and an increment of the number of items. The names may or may not be given but, if they are, concatenate the 2nd purchase names with the first purchase names. Does that make sense? ------------------------------ James Carr ------------------------------ Pipeline to Concatenate Text and Increment Numbers I want a pipeline that, when a record is created in table A, it will look to see if the record exists in Table B. If it doesn't exist, create a new record in Table B. If it does exist, concatenate the text from the new record in Table A with the existing record text in Table B separated by a comma. I also want to add a value from a field in the new record from Table A with the corresponding value from the existing record in Table B. For example, the new record is created with "some text" in field 5 and the number 3 in field 8. The existing record in table B currently has "a message" in field 2 and the number 1 in field 5. After the pipeline runs, I want the existing record in table B to read "a message, some text" in field 2 and the number 4 in field 5. I can create the pipeline, search for the existing record, setup the condition to determine whether or not the record exists, etc. I'm assuming I need jinja expressions to concatenate the text and increment the number. If so, what is the jinja I need for each? Hopefully, the solution is something simple for me to do. ------------------------------ James Carr ------------------------------ Re: PayPal JavaScript SDK To the point of someone being able to right click and view the backend of the site for credentials, is there a way to prevent this or maybe secure retrieve the credentials from another table in the app that is not open to the public? ------------------------------ James Carr ------------------------------ Re: PayPal JavaScript SDK Yup. The drop down, quantity, and any comments about the purchase are all fields provided by the PayPal code as well. The standard integration instructions reference their JavaScript SDK and involves saving some js to a file and another js to a file for their back end stuff. A code page can be saved as a .js, right? I was thinking, instead of "creating folders and saving files", I could save multiple code pages and reference those accordingly but, I am not sure. ------------------------------ James Carr ------------------------------ Re: PayPal JavaScript SDK The end goal is to show PayPal buttons and fields for people to make a purchase with. While also showing a flyer and/or any other relevant details or instructions. Nothing else from PayPal is needed. ------------------------------ James Carr ------------------------------ Re: PayPal JavaScript SDK Thanks for the response. I get the gist of what you're saying, but to actually begin to do that work is beyond my understanding. I will have to see if I can find a developer in my budget or something. ------------------------------ James Carr ------------------------------ PayPal JavaScript SDK Greetings, Has anyone successfully utilized this? I have looked at their documentation and was just recently directed to their integration builder. I envisioned using a code page(s) but after reviewing everything, I don't know if this is doable in QuickBase or if it's just my limited knowledge getting in the way. Any input/direction would be greatly appreciated. ------------------------------ James Carr ------------------------------ Re: Pipeline Incorrect Template Error To give a clearer picture on what I was attempting to do, I wanted to trigger a pipeline when a record from table A is updated, search for records in table B that are related, then search for records in table C that have a matching email address from the table B search OR have a specific checkbox in table C checked. The error in question was due to me trying to use related member from a Search records action without a Loop. For the solution, my pipeline is setup as follows: Record updated > prepare bulk record set > search records (table B) > Do loop > search records (table C) with matching email address from B and designated checkbox not checked > update record > end loop > end loop > commit upsert > prepare bulk record set > search records (table C) with checkbox checked > loop > update records > end loop > commit upsert I know that each search result from table B will only return one match from table C (if any) and it's a matter of whether or not that result will have the checkbox in question checked or not. I went with not checked for the sake of this nested loop, so I can do a separate search for those that are checked and update them accordingly. Updating table C, in this case, triggers a notification and I did not want to notify people multiple times off one pipeline run. So, focusing on the error, you have to use the search results inside a Loop or you will get this type of error. Thanks, again, Doug, for reminding me of that, which allowed me to come up with this solution for my pipeline. Let me know if there are questions, and I will do my best to answer. ------------------------------ James Carr ------------------------------ Re: Pipeline Incorrect Template Error I have figured out my solution. I need to take care of some business so, it will be a couple of hours (maybe tomorrow) before I post what I had to do. Meanwhile, thank you, everyone, who chimed in. Especially you, Doug. Had you not chimed in and made me rethink what I need to do with your suggestion, I may not have figured out how my pipeline needed to be setup. ------------------------------ James Carr ------------------------------