ContributionsMost RecentMost LikesSolutionsForce Table report to show for Summary Field drilldown even if only 1 recordFor Summary Fields I usually specify a particular table to drilldown to. This works wonderfully but if only 1 record is found, the drilldown does not display as the table I selected and instead brings up the Record Form, which is not what I want. Any way to force it to show the Table I selected instead of the Form even if it's only 1 record in the drilldown results? ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Re: Drilldown reports for Summary have "Temporary" tag on themPer support, "This is a new feature to notify that when selecting a drilldown field creates a report. That report is only live for 14 days if no user access that report. https://help.quickbase.com/user-assistance/quickbase_limits.html It is nothing to worry about and won't cause any issues!" However, I want to know can I force a drilldown to be permanent. I hope the temporary does not show for all users. We use drilldowns heavily and the message seems like a warning so I am hoping we can control the message, or remove the message if we have no control over what is temp and perm. ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Drilldown reports for Summary have "Temporary" tag on themI just noticed this today and put in a Case, but wanted to see if anyone else was experiencing this. In both Realms that I work in, across multiple unrelated Apps and in various tables, for Summary reports, the drilldown is showing in blue text next to the Report Name "Temporary". ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Show most recent entry in Log Edit field that uses Date and TimeI want to parse out the most recent entry from a Text field. Field is set to use Date and Time. a. One version with Date and Time and User and the most recent comment b. Another version with just the most recent comment. I used the Trim function (shared by Mark Shnier) which works. However, I also want to take into account the time, so if multiple entries made with the same date, it will pull the most recent "timed" entry. Thanks. ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------Re: Multi-select fields max 100?Hi David, I had to setup a separate new Table Buildmaps just to hold the values that I want the user to select from. The new Table is stand alone, no relationships needed. In there is a simple Text field, called Buildmap, set to Unique. I imported all my choices into this Text field. Then in the Fieldmaps field - the field that I want the users to enter their Multi-Select choices, I set type as Multi-Select Text. Then Input "From another field". Select shared field option which then pops up a list of Apps. I selected the same App that Fieldmaps is in because the Table containing all the Buildmaps is also in this same App. The table of values can be in the same App or a different App. Then another window asks you to pick the fieldname and you would select the fieldname that contains all your choices, in my case Buildmaps. I entered 116 choices in Buildmaps and it shows them in my Fieldmaps field and user can select them. I will end up with over 400 values eventually. User cannot add new choices in Fieldmaps, so I set up a button that takes them to "Add a new Buildmap" if they need to update the Buildmap list. I put the button on the form and also in the Table they use for Grid Edit, for convenience. Hope this helps. ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Re: Multi-select fields max 100?Disregard, I setup a separate table for values ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Multi-select fields max 100?I thought Multi-Select fields would allow more than 100 choices in the list, but its seems there is a max. Is this a change from prior? I feel like it used to allow many more in the list with a max of 20 selections. Does anyone have any ideas on how to get around this if I want a multi-select situation for the same field? I know I can create several Multi-select fields and distribute among those but was looking for a one field solution if possible. Thanks. ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Re: New Table as Parent or Child or Both?Hi Mark, I tried the join concept which I have done for other systems- maybe I'm getting tangled in my own head. If I add the Assignments as Child to Build and Map, or even as Parent, I still can't figure out how to make the pieces fit. With the join, then each Assignment will have 1 Related Build and 1 Related Map (if Assignment is child) or 1 Build will have a Related Assignment and 1 Map will have a Related Assignment (if Assignment is parent). a. A Build can select any number of maps. b. A Map can be chosen over and over again in any combination with other maps for a Build. Build 1 has Map A, B, C, D Build 2 has Map A, C Build 3 has Map C, D etc I want to make it easy for user to select multiple maps for a Build with behavior as a Multi-Select field Plus bring over the URL link associated with the map. Build 1 has Map A, B, C, D and will also show MapA_url, MapB_url, MapC_url, MapD_url Reporting is being done at the Build level. What concept am I missing here? Thanks for all the help. ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ Re: New Table as Parent or Child or Both?Thanks Mark! I'll give it a try ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------ New Table as Parent or Child or Both?Build Table has records that must capture a number of maps used in that Build. Maps Table has fields Map Name, URL Link, File Upload file attachment field. On the Build Table, I want to be able to multi-SELECT the Maps and then based on this selection, ALSO bring over the URL Links for the maps selected. I tried setting Build as Parent and then as Child and then as Both with the Maps Table, but nothing seemed to work. Any ideas? ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------