Filter Table Entries In Another Table
I thought this would be relatively straightforward but I am running into multiple roadblocks. I have a table set up in a relationship with another table with a pipeline between the two, where the parent table has a list of all employees in the plant with a field for department they are in. The child field is set up to trigger a pipeline when the corresponding department is selected from a dropdown to check off that those employees were present that day in the other table. My question with this is I would like to display the people that will be checked off in the child table when that department is selected, so they can see who they will be marking as present that day without blindly telling them everyone is present. Is this possible? I played around with embedding reports (which doesn't show the entries until the form is saved, I would like it to appear while completing the form) and formulas that I couldn't get to work quite right. Any help would be greatly appreciated!
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/Button
