ContributionsMost RecentMost LikesSolutionsVirtual Empower: App Library NOW CALLED Application Analyzer Hey all: I have been trying to use the app "Application Analyzer" which Ryan Pflederer demonstrated i n 2020 and continues to maintain. The challenge that I am having is I can't get the YAML to import. I keep getting an authorization error. I followed all of of Ryan's "additonal setup" steps but just can figure it out. I opened a case but its been slow getting a response. I am thinking it is an app token vs user token thing, but just not sure... Anyone else struggle with getting the YAML imported for the pipeline in the application? This app already has been a timesaver but it will be a lifesaver if I can get the pipeline portion to work. ------------------------------ Melissa Freel ------------------------------ Re: "Median" field using the new Query Formula Fields Gary: Thanks, works like a charm and I don't forsee super large data sets as I have "filtered" appropriately. ------------------------------ Melissa Freel ------------------------------ Re: "Median" field using the new Query Formula Fields Mark: Yes, I mean median. I already used a query formula field to come up with an average. Lordsman: I want to come up with a median of one field ACROSS multiple records. So I thought the query fields would help. This formula gives me a textlist of the values I need and sorts them from low to high which is first step of calculating a median. I have two formula check boxes that create a filter in QueryOne. QueryTwo returns the list of values I need from field ID 2393. Now, I just need to have QB tell me what the middle value is: var text QueryOne="{2030.EX.'True'} AND {4462.EX.'True'}"; var textlist QueryTwo=GetFieldValues(GetRecords($QueryOne,[_DBID_CUSTOMERS]), 2393); Thoughts?? ------------------------------ Melissa Freel ------------------------------ "Median" field using the new Query Formula Fields Anyone come up with a simple way to calculate a median of a field. I am thinking of using the "new" query formulas with GetRecords, etc. Anyone solve this already? ------------------------------ Melissa Freel ------------------------------ Jinja Templates to isolate a token Hi: I am trying to build webhook pipline where I need to supply a token that is returned from the request. The token is embedded in a long text string separated with delimiters. When I go to use this token, I am able to use a split jinja template to get at the "front" part of the token. {{b.content.split(':"')[1]}} However, there is another irrelevant text string after the token separated with a ',' Can somone suggest how I nest my jinja templates to do this and do I do another "split" or??? Please and thank you! Melissa ------------------------------ Melissa Freel ------------------------------ Re: create an order of earlies to latest dates from a summary fieldThanks Mark! Works just as intended! ------------------------------ Melissa Freel ------------------------------ create an order of earlies to latest dates from a summary fieldHi all: I have a child table that has many related records to its parent. I transformed that date created field to a text field and then made a SUMMARY field in the parent table so that I could "see all the dates" of all the related records. The challenge with this is that I would like to then manipulate this summary field back into a date/numeric field that lists the dates from earliest to latest. I then want to "extract" different dates to do some formula work in the parent table. So, I have the summary field (its a text field) I want to convert it back to some kind of "numeric" or date field that then lists the dates from earliest to most recent. I know this is a simple thing and I probably have done something in the past, but just have a quickbase mental block on solving this one. Thanks for any help ------------------------------ Melissa Freel ------------------------------ Re: Notifications and having %recLink% open a particular FORMThanks Mark! Appreciate it as always ------------------------------ Melissa Freel ------------------------------ Notifications and having %recLink% open a particular FORMHi all: Probably a simple question, but I have a notification for a table that I have put %recLink% in the notification. Works fine but it links to the DEFAULT form for that table. I want it to use a different form that I have developed for the table as the notification is set for a specific change that is made with the "NON-DEFAULT" form. How do I modify %recLink% or what would be the html that I would need to write out in my notification to have it pick the correct form to display the record? Thanks! Melissa ------------------------------ Melissa Freel ------------------------------ SolvedRe: HTML Table in Rich Text FieldThanks Tammie! It worked. I just put "ToDate" on the var Date variable and it all fired correctly. Seeing that you used "Part" was really helpful. Thanks again. Mel. ------------------------------ Melissa Freel ------------------------------