Recent Discussions
Extracting multiple substrings from a text string
I have a text string that contains data similar to the following: Company Name 1 | P25021201 - 4341297 | stp01YWTFMSXKS5f6u2z | $1200.00 | Company Name 2 | P25021201 - 4341112 | stp01RFEQRMDTC5f6u0l | $2400.00 | Wallet I need to extract the data that starts with "stp" and return it in the following format: stpxxxx1, stpxxxxx (i.e. stp01YWTFMSXKS5f6u2z, stp01RFEQRMDTC5f6u0l The problem is the number of "stp" strings in the text is unknown. Does QB support a looping mechanism? If yes, I could simply find the 1st stp string, remove it from the text string and keep looping until no more stp strings are found. Any help with this is greatly appreciated as it is causing an issue with a production app.
Color coding report based on Date Modified
Hi all! I'm trying my hand at color-coding a report based on any records updated in the past 7 days. I found a few similar threads/tried to emulate the formulas, but it's giving me guff because Date Modified is a Date/Time field. My not-working formula is: If( [Date Modified]<=Today()-Days(7),"green" My error says "The operator '<' can't be applied on types datetime, date #SendHelp! Thanks!!
Document creation - Save PDF to field in record
Loving the new Document creation feature, but now I want to expand upon it and save the generated PDF to a file attachment field on the form. The feature just makes an API call and the PDF is returned in the response, so we should be able to build a Pipeline to iterate through the JSON response and save the PDF. I've been trying to set this up for a few days, but to no avail. Has anyone done this yet?Formula - Rich Text field is not displaying zeros after the "."
I have a Formula - Rich Text field that is converting a Currency field "ToText". The value was Rounding the "cents" up to the nearest dollar value which I have solved for. However, now I can't get 0s after the decimal to display. I tried applying Abs (absolute value) but that didn't resolve the issue. Below is my formula...HELP! If(ToText([COR Amount])<>"", "$"&ToFormattedText(Round([COR Amount],0.01),"comma_dot")) ------------------------------ Ashley Solomon ------------------------------Testing for Empty Forms
Hello, Each client within my app has a form/page with centralized information. On this form, there are many sections, including a section for files. Based on our company policy each active client needs to have a consent document signed for us to offer services. We want to be able to flag for our staff if a client form is missing a consent document. I figure I can use the IsNull formula, but I'm not completely sure how to leverage it. We have a checkbox formula set up to indicate whether an uploaded file is categorized as a consent document. Is there some way I could use this checkbox field with the IsNull formula to indicate if a client is missing their consent document? Any other ideas on how to gather this information? Thank you in advance! Abby :)
Form Rule "Show Report" displays No options
I am trying to create a form rule that will show a report when a checkbox is selected in the form. Issue is that when I am creating the rule, I do not have any reports to select from (it's blank dropdown) even though none of my forms are hidden. Attached is screenshot of form rule Can anyone help me?
Summary report w/multi-select field
Hello, First, thank you in advance for any thoughts and suggestions you might offer here. I would like a report for the average hours worked per technician per week. They record the total time on site in each dated work order record. Thus far, I have created a summary report that summarizes the work time order time by average and it is grouped by week and by the assigned technician in the record. However, this field is a multi-select and there are some records with multiple values as some work orders have multiple assigned technicians. The resulting summary report displays each assignment as a value, meaning the assigned technician(s) rather than searching and filtering for each individual technician, and then averaging each of their hours. I am not sure how best to resolve. I really appreciate your input.
