KarthikSekhar
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Formula refresh button issue
I was able to finally get a solution from QuickBase. The idea is to have a field in the parent that always gets modified when the record is opened. In order to achieve this every time, you must create a formula text field called "Change From" with the formula ToText(Now()) & ToText(MSecond(ToTimeOfDay(Now()))). Then, create another field called "Change to" which will be a regular text field. Then add a form rule like below. The value of Change From will always evaluate to the nearest millisecond. This means that the Change To will always get modified whenever you click the Refresh button. The formula for the refresh button is var text rid = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%"); var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid; "<a class=\"Vibrant Primary SaveBeforeNavigating\" data-replaceRid=\"true\" href=\"" & $url & "\">Refresh</a>" ------------------------------ Karthik Sekhar ------------------------------Re: Formula refresh button issue
Hi Mark, QuickBase finally agreed that this is a bug and provided me with a Bug ID. They did not mention about any timelines as to when they will fix it. This is becoming a major issue for the users in my App. Is there anything we can do to get QuickBase attention so that they can prioritize it. ------------------------------ Karthik Sekhar ------------------------------How to make New Dashboard as the default Home Page for a Role
I have created a dashboard using the New Dashboard feature. I want to set that as the Default Home Page for a Role. The dropdown list that is used to set the default Home Page does not have the New Dashboard as one of the choices for selection. I noticed the QuickBase Code Sample App is doing some redirection to go to the new dashboard. Any help is much appreciated? ------------------------------ Karthik Sekhar ------------------------------Formula refresh button issue
I used to have a refresh button that when clicked will save the record and then open the record in edit mode. This button was using javascript below. "<a class='Vibrant Success' onclick=$('#RedirectURL').val(document.location.href.replace(/&rl=[a-z0-9]*/,''));$('[name=rl]').val('');$('#saveButton').trigger('click'); href='#'>Refresh</a>" An alternative is to use below var text rid = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%"); var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid; "<a class=\"Vibrant Primary SaveBeforeNavigating\" data-replaceRid=\"true\" href=\"" & $url & "\">Refresh</a>" But, the issue is when you are editing a child record that is embedded in the parent and do not make any changes to the parent record the browser displays a pop up that "your changes may not be saved". Is there any alternatives to prevent the browser from displaying the popup and automatically save and open the record in edit mode (without using javascript). ------------------------------ Karthik Sekhar ------------------------------Re: Form Refresh button
Hi Mark, The formula url works fine if we are editing a field within the table and then clicking the button. I get a message that "your changes may not be saved" if the only change I made is on a Child record (embedded in parent edit form). Is there anyway we can avoid getting this message? ------------------------------ Karthik Sekhar ------------------------------Re: Blank Screen QuickBase Issue
Hi Evan, Thanks for the response. The issue is not limited to one QuickBase App. So, I am not sure how the role is going to affect these users. Also, they get a blank screen when they click on any Table Home Page. The issue gets fixed temporarily when they access any URL from another Realm. But, it reoccurs if the user reboots their machine. We cannot be asking our users to click a link to another Realm every time they have this issue. ------------------------------ Karthik Sekhar ------------------------------Blank Screen QuickBase Issue
Several users in our organization are impacted with an issue where they are getting a blank screen when they click any report or Table Home page. QuickBase care mentioned that the issue may be caused by any JavaScript instance within the app. If it was an issue related to JavaScript, it should have affected all users who had access to the app. But, it has only affected a selected number of users. Has anyone else see this issue? ------------------------------ Karthik Sekhar ------------------------------Re: Virtual Empower: App Library
Thanks Ryan for your response. Is there any way we can automate the button click to refresh schema? Currently, we have to manually click the button and enter the User Token to run the refresh. ------------------------------ Karthik Sekhar ------------------------------
