ContributionsMost RecentMost LikesSolutionsGo to login page when clicking on a file I have a file field that I must keep secure (I cannot open to public). A teaming partner has a limited access role, so that they can be logged into our realm in order to access the files. The problem I am having is this: In other scenarios, if you click on a QB link and are not already logged into the realm, it takes you to the realm login page. However, if you click on a file, it just gives you a 404 Error page. To the user, there is no indication that the real issue is that they need to log into the realm. Any thoughts on how to combat this? My instinct is to make a formula rich text field that doesnt take you to the file, but actually takes you to a custom form with only the file field on it. This way they should be sent to the login screen. I don't love that idea though, anyone have any better thoughts where they can still click on the file itself, and if they are already logged in it opens the file, otherwise it asks them to log in? ------------------------------ Michael Tamoush ------------------------------ Any way to find out where a role is used? Is there any way to tell if a role is part of any dynamic form rules, or if it is used in any formula text fields? I am thinking I might be able to use the search schema to look through formula text fields, but is there any way to know where you have used a role for dynamic form rules? ------------------------------ Michael Tamoush ------------------------------ Re: Scroll Down Automatically on Mobile Form Don, I checked with my contact and he said after testing, he does not believe this is possible on mobile, though he says definitely possible on desktop. However, I am checking with him to see if on desktop if he can get it to return to a specific place, if there are multiple tabs, or only on a form with no tabs (or a form with a single tab). ------------------------------ Michael Tamoush ------------------------------ Re: Platform Performance Issues? If you continue to have performance issues, ask Customer Support. I've had the issue where my App gets put into a 'lane' (sharing resources) with another realm, and that realm is hogging resources (usually due to something wrong - a formula query too intense, a bloated app...>) and will slow down your realm. Or, make sure you didn't just recently make a big change that could be causing it. Most likely culprits recently - formula queries. But can be other things. You can ask Customer Support to see if they see anything in your app causing delays. Once they found in my app I had a search widget on a home page, searching like 700 fields at once. When people used it, it would hog all the resources. Simple fix, that I would have never known if I didnt ask. ------------------------------ Michael Tamoush ------------------------------ Still no way to hide 'New App' button? Is there still no way to hide the New App button? It's the first button everyone tries to click, so I receive about 10 requests a week to try to create new apps. Has anyone come up with a way to remove this button?? ------------------------------ Michael Tamoush ------------------------------ Re: Formula Text Field This should get you started on the syntax. It is the first two if statements. Keep adding on with the following in mind: QB evaluates if from top to bottom. As soon as it hits a true statement, it stops and outputs the result. So be sure by the time you get to your last statement, that none of the prior statements could have been true. Use ="" to evaluate if a text field is blank, use isnull or not isnull to evaluate numeric and date fields. Use the or operator for spots where you say 'at least one of the fields is...' Group your conditions in parentheses. See the higlighted parentheses below. If( [Program - HTH] = "" and isnull([RRH Match]) and [nonDHS Program]="", "Phase 1", ( not is null([Date of Match to Program - HTH]) or not isnull([nonDHS Date of Match to Program - Manual])) and isnull([Date Prover Changed - HTH]) and isnull(nonDHS Date Provider Assigned - MANUAL]), "Phase 2", ..... ) ------------------------------ Michael Tamoush ------------------------------ Re: Plot Gallons used when records only have total gallonsThere are a few hundred properties, each with their own water treatment system. They are tracking the flow (amount of gallons) through each treatment system. My current lne of thinking is a summary field to each treatment system, which combined texts all the info i need, then i re-split it apart and use a combination of Part + If statements looking at each part. I think this will work but is a ludicrously long formula, though a repeating formula. Maybe 50 lines so not the worst. I cant think of another way. It's too bad because this is exactly what a query would be perfect for. ------------------------------ Michael Tamoush ------------------------------ Re: Is it possible to trigger a Pipeline when a formula field changes on record update?Oh my gosh the web hook idea to a check box is brilliant. I have spots where I have 4 child tables, thus 4 pipelines to trigger based on each one. Instead, I can have 4 webhooks, and only 1 pipeline! Dang, wish i thought of that years ago lol. ------------------------------ Michael Tamoush ------------------------------ Plot Gallons used when records only have total gallonsHere is my setup: I have a table of Events. Each Event has a date, and a reading of total gallons used. I want to plot on a chart the number of gallons used since the previous reading. Thus, I am trying to make a field that shows the reading from the prior date, and then use formulas to just do the math and subtract. If I can also get the actual prior date, then I can use duration to find the number of days since the prior reading. More math will give me a gallons per day average, which is the ultimate goal. I tried Ranking using formula queries, and then more queries to get my info. Unfortunately, I have too many records and get the 'this query will take too long and screw everything up' warning. Any other ideas on how to get a gallons per day, when the data set I have are records with dates, and total gallons? ------------------------------ Michael Tamoush ------------------------------ Re: How to conditionally show a report on a formQuickbase Junkie has some great videos https://www.quickbasejunkie.com/blog/formula-query-functions?utm_source=qb&utm_medium=r&utm_id=0 So yours might be something like: var text Query = "{15.EX.'" & [User Name] & "'} AND {23.OAF.'" & [Date] & "'} AND {23.OAF.'" & [Date + 60days] & "'}"; ToText(GetFieldValues(GetRecords($Query,"bgrdgy7gg"),23))) So the query above matches the user name in your current record you are scheduling, the field 15 (whatever the field is in the schedule table for user name) and says that field 23 (date field in schedule table) is On or After the Date in your current record, and field 23 is also on or before the date plus 60 days (you can just make this field as well). Then it gets all the values in your foreign table (bgrdg...) from field 23 (your date field). This will just give you a string of dates (2-2-22;2-3-23) and you can use formulas to make that in a prettier list, and another formula to see if your current date is contained within that string. Somethings I am not sure of and dont have time to test: Not sure if you can compare user fields. You might have to make the user fields text (which would be emails) and compare those. Also, not sure if you can return a list of dates. You might have to ToText your date field and return a string of dates that are in text format. ------------------------------ Michael Tamoush ------------------------------