Exact form Font Size increment for Child table records
Hi, We are using quick base exact forms for one of our application. We are able to increase the font size for header of embedded child table report. However not able to increase the font for records content. can anyone help me in resolving this. We are using below code to get records from child table. updating font size in this script not helping. -------------------------------------------------------------------- <p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:120%'><span style='font-size:11.0pt;line-height: 120%;font-family:"Trebuchet MS","sans-serif";letter-spacing:.2pt'>~=if(f[252]!=0)qdb.GetURL("bgc7px2h4", "API_GenResultsTable^query={'6'.EX.'"+ field["Record ID#"]+"'} AND{24.EX.0}^clist=26.8.17.21.64.57.23.63.13.67.68.69^options=qws.nvw.ned.phd.nfg.sortorder-A^slist=26")~~=if(f[252]==0)qdb.GetURL("bgc7px2h4", "API_GenResultsTable^query={'6'.EX.'"+ field["Record ID#"]+"'} AND{24.EX.0}^clist=26.8.17.21.64.57.23.63.13.67.68.69^options=qws.nvw.ned.phd.nfg.sortorder-A^slist=26")~</span></p> -----------------------------------------------Form Edit/Design Menu
I'm trying to modify the layout of a form, but it's difficult to move elements because of the edit menu/toolbar that appears on the right side of the screen. Every time it appears or disappears it moves the form's columns to a new width. Is there a way to make this menu permanently visible so that my columns will stay still?
Add button in embedded report
Good evening, I have tabs set up in my parent table records, and in one of those tabs the information is a parent to a child table. I want the purple button to not show for certain case types in a drop down field in the parent record, or if the record has meet the outcome of having 2 reviews completed. Is there a way to do this?
Preventing User from creating Records under another person's ID
Hello, I have created a new App that will service multiple departments and a bunch of Users. The issue i am running into deals with the fact that not all users have individual QuicBase accounts. Older accounts use the company login ID as the QuickBase UserName. The newer accounts fall under an Enterprise license and they show up as the company email, not their ID when using a User field in QuickBase. During initial testing we did not realize this was going to be an issue. I created Form Rules that would check against the Current User and make sure the ID they selected matches on their entry Form. If it didn't match the Prevent Save would kick in. I was also able to use similar logic in Report criteria to limit records visible to the ones created specifically by that person. So now that we have broadened our testing participants we are seeing issues because some individuals show up as an email address when I am trying to compare back against the ID. I tried using the ToUser() on the email address in our Auditor Table and then modifying the Form Rule to be either condition. And still no luck allowing those email individuals to be able to create a record. I'm sure there is an easier way to do this, I just have no idea how. Everything I have come up with is not working. It's probably something easy that I am over thinking on. But if anyone has suggestions I am open to trying anything. If you have questions I can elaborate on or need more specific details comment below and I will do my best at explaining. Thanks in advance, and hopefully this will help others in the future.
Forms button
I have made my forms look better and it is easier to enter data. My question is how I can get someone to press a button or tab to bring up these forms in a "New" data entry form? Equipment type I (child table) Tab/Button Agency(table)-------Equipment type II (child table) Tab/Button Equipment type III (child table) Tab/ButtonDisplaying a checklist/questions based on a field?
I'll start by stating while I have gone thru much of the free training and also have taken several paid classes, this is my first app that I'm building from scratch. I am looking to create a small walkaround/audit app for a number of facilities. For the sake of this example let's say I have 4 facilities and 5 locations in each. There will be a "checklist" or "set of questions" assigned to each location in each facility. These checklists may be reused by different locations, but not necessarily. Technically, a single audit will have a single location, and a single checklist/set of questions assigned to it. If I create the new audit, and I choose the Facility and Area, I want the assigned checklist/questions to show up for the auditor to fill out. Is there a way to dynamically add these questions, or dynamically add a new pre made form with these questions to the existing form? I initially thought of just adding ALL the questions to a form and use dynamic form rules to make them visible or not based on the facility/area, but another piece of the puzzle is we would like the power users involved to be able to add their own locations, and their own questions. I wouldn't expect these guys to deal with these rules. Additionally, I am realizing there would be rule for each question for each facility/area for each question. This may still be the way we need to go, at least for a "Version1" of this app, but I have to imagine there is another way. Any suggestions would be appreciated.
