number of rows displayed per page in table report
For some reason I can't find any details for how to change number of rows displayed per page for particular table report (and if it even possible). What makes me more wondering - different reports for the same table may display different numbers of rows: 50, or 100, or 200.Rich Text Field Markdown Cheatsheet
tldr; Rich Text Fields use Markdown I was writing a solution to a User Request problem into our homebuilt ticketing system. It has to do with applying '_curuser_' to a custom Role permission. I noticed that as soon as I hit space after the last underscore, the text changed. This is unexpected behavior and in this case undesireable, I want to maintain the syntax of the custom rule. Today I learned something new and want to share it in case like me you had no idea this would happen. If you type certain characters in a specific order into a Rich Text field, the text changes formatting. Below is a table of all the examples I could find. The left column is preceded and ended by a single quote which causes the text to stay unchanged. The right column is the same syntaxt without the single quotes, note how the formatting is changed. ~ since this Website won't allow some of the characters I inserted an image, sorry to those who like to copy and paste for thier own notes.
Multiselect list some options grayed out and italicized
I'm sure I'm missing something obvious, but I'm stuck. I have a "Cases" table. Many other tables/forms pull from/reference this table using either one-to-many or many-to-many relationships. I recently added three new cases. But in some tables these cases appear grayed out and italicized, but in others they are selectable. It seems that in single-select fields they appear as normal and are selectable but in multiselect fields they are gray, italicized, and not selectable. Any thoughts on how to troubleshoot this? ------------------------------ Paul Easton ------------------------------
Search And Replace to Remove "enters"
I have field where users can enter data and divide them by using Enter: XXXXXX YYYYYY For another field summary I would like to convert this way of entering into: {XXXXXX; YYYYYY} I was thinking to use formula "SearchAndReplace" but I am not sure what to enter in Search for?: SearchAndReplace([1-Step feeder(s) - after AltBOM],"?????","; ") In excel I would search for Char(10) but how to find "Enter" in QuickBase? I tried to Trim, but does not work. I tried to use in formula enter but after save it is converted to "/n " Any ideas how to search and replace "ENTER" between numbers? There might be more then 1 enter. ------------------------------ Adam Krzyzanek ------------------------------
Getting parent records to be related to multiple child record
There is a Master Copy and the Master Copy has a multi select with the master SOP names. I have a document storage app which has a table named Manuals and a table named Supporting Documents. Each has a File Attachment field of the same name. Each Manual has multiple Supporting Documents. This is handled by a standard one to many relationship. I found out today that each Supporting Document could potentially ?support? multiple Manuals. This could be handled by simply uploading the Supporting Document file multiple times, each record being related to a different Manual. Due to storage space and modifications of files I do not want multiple Supporting Document records that contain the same file attachment. I tried to use a multi-select field in the Supporting Documents table that would check off the multiple Manuals, and through a report link field link the Supporting Document to the Manual records. This won?t work because there are over 250 Manual records, and the Multi-select can only handle 100 values and 20 selections. Otherwise it would have worked. I could create a regular text field and manually type in the names of the Manuals that the Supporting Document supports, but I don?t want to do that either. What?s the cleanest way to get one Supporting Document to be able to be related to multiple Manuals?
Hiding Tables in Table Bar
I hide many of my tables from most user roles. However, when I add a new table it defaults to be visible, and I have to manually go through each role and hide the table. Is it possible to default to hide, or to go to the table itself and choose that option? In the table settings, I know I can set access per role, but only permissions, I don't see user interface. Can the user interface per role be set from the table settings? ------------------------------ Mike Tamoush ------------------------------
