QB Variable Save and Keep Working Button - Unsupported and Deprecated
Based on the community feedback in this Quick Base Community post: https://bit.ly/2ZtUg4A I have been using a technique that involves using a QB variable defined as... <a class='Vibrant' style='font-size:12px; color:black; background:#33ff33; white-space:nowrap;' onclick='$("#saveAndKeepWorkingMenuOption").click();'>Next</a> ...and referencing it in a formula rich text field to create a save and keep working button that i can place on a form. It works great on desktop, but not at all on mobile. I was advised to open a user support ticket. This is an easy way to create the record Here is the feedback from the support ticket: The function being called cannot be used in a formula field. Furthermore, the features that are being taken advantage of are not intended for public use and will eventually be deprecated. All said, this is a browser/mobile discrepancy that we do not plan on addressing as the functionality being invoked is generally unsupported. I just wanted to give a heads up for anyone using this technique so you can find a different solution before the functionality ceases.
Issues with Dynamic Form Rules after Sunday's Rich Text Update
I am posting this in a new post as the current one addressing this is hard to find. In the latest release this Sunday, 12/17/2017, QB support confirmed to me that they automatically updated various text fields whereby the "Allow HTML" checkbox was checked to Rich Text fields. This affected most Text fields and Formula Text fields. Among other possible effects which are not known, one effect of this change that I can confirm in my apps is that it has broken the functionality of some Dynamic Form Rules. Specifically confirmed is when you have a Form Rule that is supposed to update a Field (now Rich Text) with values. For instance, I have a what was once a Text Field with the "Allow HTML" checkbox checked that is now a Rich Text field through QB's wisdom. My former Text (Multi-Line) field on the form page no longer updates when someone checks a box that is supposed to populate it with certain text data, as per my Form Rule. My resolution was to go into the field properties and change it back to Text (Multi-Line). If I change it back to Rich Text again, it still does not work. In my case, this field doesn't need to allow HTML, but for some people this is broken and I am not sure of the resolution if you need html in the field to be read as html. Please feel free to provide any additional information you may know in this thread.
Unique Values
I have two tables with a relationship. Table A provides the unique value of Tree_GPS_Coordinates to Table B. Table B uses the lookup value of Tree_GPS_Coordinates and collect data for fields Year and Height. Goal: I want to prevent any duplicate entries for trees in a given year. (e.g. Tree1 cannot have two 2017 measurements) Problem: Year field cannot be marked as unique because many trees will be marked as 2017, 2016, 2015 etc. Tree_GPS_Coordinates is a lookup field. Question: How do I create field formula to ensure there are not duplicate entries? I continually receive the message "This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.
Cannot use formula and have a summary field using this relationship.
I am getting the following error when trying to use summary fields in a relationship. We are sorry -- at this time, you cannot use this formula and have a summary field using this relationship. I know from previous posts that I can click through error and it will still work. Unfortunately it randomly stops working from time to time and all the values are blank. I have to then delete the formula and recopy and save it. It is very frustrating that Quickbase cannot make this work. I have over 400,000 records in a linked table that updates each night. I need to concatenate the date, location, and customer information. I do not think a form rule will work because the data is updated through the link. Is there any work around to this? I just need that concatenated value automatically copied over to a text field, but I cannot figure out how to do it.
Quickbase Sync error: ""Received unexpected error: The operation has timed out
Hi, I get this error semi-occasionally when an automatic refresh occurs in my table. It'll sometimes succeed, but other times fail randomly with this message. Unless I'm completely oblivious, I can't find a reference to this error anywhere. The error reads simply reads: "Received unexpected error: The operation has timed out" Is there anything I can do to debug this further?
Error : Object Reference Not Set to Instance of an Object
I have run into this error a number of times. When I am trying to import an Excel file into QB, I receive this error. Object Reference Not Set to Instance of an Object I am referencing an Excel file that has been saved and in the correct file path that I provided to Quickbase. This problem seems to occur in files that I am importing that are small, so my solution to this has been to include irrelevant data in the Excel file and then leave the data out of the import. Any ideas why this would be happening and does anyone have a more elegant solution to solving this problem?Has there been a change or an issue with Roles lately?
This morning I was told from our production staff that they no longer have permission to view the app I created for them. When they open the app, they are asked to request permission. The production staff is set to "participant" role. Everything worked find for 2 years until this morning. No setting have been changed, the settings currently look like they should have access. Has there been an update or is there a known issue with the Roles settings? Currently the only way I can get them to have access to the app is to give them administrative privileges - not ideal since there is confidential information about all employees within the app.How to limit a field ""Phone Number"" to only contain 10 digits?
I have a field "Phone Number", I need the user to enter 10 digit phone number in the field. If the user enters digits less than or more than 10, it should display an error message. Is this possible using native functionality or needs some custom coding? I tried using Phone filed data type but it accepts any number of digits in the field. Any suggestions?
Create 12 records in another table
Hi all, I need to create a process that when a new record is added in a table will add 12 new records in another table. I was able to create a process using automations that works by incrementing a counter on the initial record, which creates a new record in the second table which in turn increments the number in the first table until the counter reaches 12. The problem is that at times, I have multiple records that have to be processed, and at that point, I get a 429 error: Webhooks are exceeding the rate threshold. Any thoughts on how I can overcome this?
