MattMakris
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
How to extract the URL value from a File Upload field
I'd like to get the actual file URL of a file uploaded to a File Upload field. How can I do this and display the URL in a form? My use case: Users can upload an image file. I want to display that image in an <img> tag in a rich text field in the form.How to create a Combined Text summary field using a relationship field
I need to display the field value for each child record of the parent table in a report in a Combined Text summary relationship field. I'm getting this error when trying to create the combined text summary field: "That summary function cannot be applied to this field..." The field I need to create a summary of is being pulled from yet another child table (SEO Bucket Rate Card) (grandchild) related to the 1st child table (SEO Deliverables) of the parent table (SEO Deliverable Cycle) Table Name / Relationship `SEO Deliverable Cycles` = Parent `SEO Deliverables` = Child `SEO Bucket Rate Card` = Grandchild I'm stumped - any way around this? ------------------------------ Matt Makris ------------------------------Creating a 'foreach' style loop in pipelines
Is there a way to do create a loop in Pipelines that runs a set number of times? For example, I want to run it x times based on user input: When a record is updated, it will make X copies of it based on a "clone quantity" field in the updated record. Thanks! ------------------------------ Matt Makris ------------------------------Re: Pipelines not running due to Mixed Encoding issues
We subscribe to other big platforms, and Quickbase is the only one that continually has these issues. I spend more time working around clunky UI/UX stuff than actually building apps these days. It's too expensive of a platform to make their users do this with little to no support. ------------------------------ Matt Makris ------------------------------Pipelines not running due to Mixed Encoding issues
Some pipelines all of the sudden stopped working for certain tables last month. Support said it's due to a mixed encoding issue and that I'd have to run the Mixed Encoding Scanner. It uncovered over 5,700 rows with issues across dozens of fields - trademark symbols, curly single quote characters, and other basic characters tripping the errors. I don't have the ability to manually fix these or even do find/replace on each table/field. Is there any way around this? This seems crazy that the platform cannot support a trademark symbol. ------------------------------ Matt Makris ------------------------------Help with creating a multidimensional chart
I was tasked with creating a chart with the following information. How would you recommend displaying this in one chart? Is it possible? Show profit/revenue assigned to any Account Manager over time (how does their profit and revenue compare to 6 months ago?) Show total number of Client records they are assigned to (how does this compare over same period of time) Show total number of products they are assigned to that are paused/cancelled (how well do they retain clients) Topology Parent: Clients table (contains Assigned AM field, status=active) - Child: Products table (contains current profit, current revenue, current # of products, status=paused or cancelled) - Child: Products History table (contains historical info (same fields as Products table) ------------------------------ Matt Makris ------------------------------Use table contents as source for multi-select dropdown field in different table?
Is it possible to use table contents as source for multi-select dropdown field in different table? For example, I have a Locations table and a Categories table in my app. In the Locations form, I want users to have the ability to add multiple categories from the Categories table (specifically a list of values from the Category Name field in the Categories table) to the Location record. The goal is more about defining categories than it is relating records. Is this possible? ------------------------------ Matt Makris ------------------------------Re: Creating a record change log table displaying the old/new values of fields from an updated record.
Is there a way to write the actual field name to a column in the table so that we can see the field that was changed in the row? For instance, if there are 100 fields in the form and only the phone number was changed the row/record would reflect something like this: Field Changed | Old Value | New Value "Phone" | "1234567890" | "0987654321" ------------------------------ Matt Makris ------------------------------How to auto-fill a User (lookup) field in a form with the current user.
I've been trying to create a rule in the new form rule editor that auto-fills the current user into a User (lookup) field when the form is loaded. Is there a way to do this? Thanks! ------------------------------ Matt Makris ------------------------------
