Previous and Next Record Buttons
Hello, I have an app used for credentialing information for physicians. I'm using a form as a data card visualization to provide leadership with a quick overview of each physician's profile and credentialing details. There is a section at the top of the screen with arrows for navigating to previous and next records, but they are currently unclickable. It would be incredibly helpful if leadership could simply click through to the next physician instead of having to navigate out and select a new person each time. Is this functionality possible to implement? Thank you! MeagSolved14Views0likes2CommentsQuestion about the limitation of formula fields and dynamic rules.
I have a form that uses dynamic rules to show fields based on a selection from a location box. This is working as expected. I added an additional layer where if I chose a GERMAN location, an additional field would pop up above the field with the German translation of the English field label. I made the translated field a formula fields with no actual formula so it was literally just a label. Once I set up my rules, I found I got a form error stating that there was a limitation of formula fields with dynamic rules. I believe this limitation was 40 and I had 53 (and needed about 10 more) I made some changes and the error is gone, but I also have no translations. I started fiddling around and found that I didn't need to use a text formula, and I could use just TEXT and make it read only and it would only show the label. Does anyone know if this will allow me bypass the limitation on dynamic rules? I am pretty sure the error specifically mentioned formula fields in the limitation, but I wanted to try to confirm before I recreate 50+ fields. Thanks. Brian14Views0likes1CommentMulti-File Upload
I have been using the ole Magic Buttons "Multi-file Upload" with a code page for years, love it, but it does not function correctly with the new forms. It will add the files behind the scenes, but it will not return & refresh. If I use the back-button and refresh, all is good. - messy with new forms. Is there a way to fix the ole Magic Buttons "Multi-file Upload" code pager to work with the new forms? Now moving on to new forms.... Using the lates QB Plugin for drag & drop upload of files, it simply will not save the parent before adding files, which clearly creates a relationship mess if you continue. Removing the button on parent add records creates another mess of users not updating or adding files. Within the button of execution, is there a way to save and go directly to uploading files when clicking the plugin button to add files? save the parent and enforce the upload of file(s).92Views0likes9CommentsDynamic Rule - Or statement?
I have been building a series of dynamic rules this afternoon and hit a snag. Basically, I have a list of questions that need to be filled based on location. Each question COULD be asked in multiple locations. I went thru thinking I could create rules to SHOW the question depending on the location. My problem comes when I have several locations which is basically are the EXACT same rule for a different location. I am finding the question only shows for the highest number rule. I did some googling and confirmed what was happening regarding the rule number. It seems the easiest way to fix this would be the ability to use an OR statement in the condition of the rule. I see several articles mentioning the same thing, but it doesn't seem particularly clear - I can create the initial rule, then choose ALL or ANY for subsequent rules. Is there no way to do an OR here? Should I be looking at this a different way? My example is similar to this: Boston Quest1 Quest2 NY Quest2 Quest3 RI Quest 1 Quest 2. If Location = Boston Show Quest 1 Show Quest 2 If Location = RI Show Quest1 Show Quest 2 I could combine the rule to If Location = RI or Location = Boston or Location = NY Show Quest2 I built it all out without the OR, but got a rule warning: Rules #10 and #11 are both 'show/hide' rules on the same field (Ex - Schutz).Solved31Views0likes2CommentsSimple Dynamic Rule Question
I am having a bit of a problem building a dynamic rule. I have a basic app, 2 tables. LOCATION and WALK. The location table is basically 2 important fields - Site and Area... Site would be the actual location of the walk, where area is a sublocation. So like - Site = Boston_Office Area = Cafeteria. The WALK table is a list of questions that we ask when doing a walkaround. These questions can be slightly different per site/location. There can be multiple area's per Site. In the app, the dropdown is LOCATION where we can choose the combined SITE-AREA. When I select it, it shows both the SITE and AREA in seperate boxes. The relationship is one LOCATION to many WALKS. My question is this. I am trying to show/hide fields based on location. I customize the WALK form, and go to set up a dynamic rule. I can see a SITE field in the list of fields I can use for a rule. I wanted to do a rule IF SITE IS NOT EQUAL TO Boston_Office then HIDE field(s). My options when I try to do this, is "is equal to" and "is not equal to". I assumed I could type in "Boston_Office", but the rule doesn't fire. There is also a field called Location - Site where I if I select it, I get an additional option called BROWSE CHOICES and I can select what ends up being a SITE and AREA combo and by using this, the rule works. This would mean I would need to set up a rule for each Site-Area combo for this to work. Any thoughts what I am doing wrong where I can't just use the SITE field so I can create one rule for all Boston_Office related fields?39Views0likes5CommentsAdding (dynamic) text to a form??
I have a form that is a series of text boxes with a label. 90% of our users all read English, but we have one location in Germany where some users do not. When customizing the form, I can see how I can add a text label. I was thinking I could add one of these text label fields for each text box I have which would be a German translation of the English label. So far, I think this will work for me. However, what I REALLY want to do, is this. I have a location dropdown on the form. I am already using dynamic rules to hide certain text boxes based on location. I would love to be able to hide the text label with the German translation for each text box by default, and then if I select GERMANY in the location dropdown, the dynamic rules would make the German text label visible. From the initial look of things, I can't do this. I am hoping someone can tell me I am wrong and may have an idea on how I can make this work. Thanks! Brian29Views0likes1CommentLookup Field not pulling Data
very new to Quickbase. I believe I have followed all of the instructions on adding a lookup field to a new record form. I have the relationship between the 2 tables established and am trying to add the field to the child table. It gives me the dropdown list the way I would expect but does not show any of the data that is in the parent table.Solved39Views0likes2CommentsPRINTING NEW FORMS?
Is there a way to Print the new forms yet? Would like to put a button on my legacy table on a record id to print that new form style that would show the .jpg of the attachment when printing. If not, is there an easy way to do this with a record that has 5-20 attachments when printing or emailing only?33Views0likes1CommentFORMS as a primary view in a Table?
I have been out of QuickBase for a couple years and a lot has changed. Hence, my return to Empower this year! I am playing around with Forms and want to see if there is a way to integrate this view into my Tables as a primary view instead of a report/ legacy view? It seems this would be a nice view to have within the tool as well instead of just for use in other places? Let me know if I am missing something as I cannot find how to use forms without a link/ email/ etc. Thanks in advance!29Views0likes2CommentsHow do I save a form and continue to another form, importing the newly created RECORDID?
Hi all, I've been trying to sort this out for too long. I have a form (Form A) with a URL link to another form (Form B) for the same Table. When you click the link it should save the form, create the RECORD ID and use that RID to go to Form B. For some reason the "%%rid%%" functionality isn't working for this. Here is the formula I am using: var text recordid = "%%rid%%"; URLRoot() & "db/*********=er&dfid=24&rid=" & $recordid & "&z=" & Rurl() & "&ifv=1" It says: "DRS Record not found". When I look at the URL that it directed me to it still has "%%rid"" in the actual URL instead of the new Record ID. I have tested this url by hard coding in the next RECORD ID that will be created and the URL link works. I just need the new RECORD ID to be in the formula - URL and it's all golden.42Views0likes2Comments