GB_DirectorOfOn
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: WHEN 1 RESULT IN SEARCH, DIRECT TO FORM INSTEAD OF REPORT
Sorry @Danimal, my follow up was meant for @QuickBaseCoach App Dev./Training. Ironically though, I have no idea what you are saying in your reply either, but also have no doubt it would solve my problem. (I come from the business side and am learning the IT coding piece.) You're both great resources in the community. Thanks so much.28Views0likes0CommentsRe: WHEN 1 RESULT IN SEARCH, DIRECT TO FORM INSTEAD OF REPORT
Sure... this is a single table, "MFG SOPs." A single records for each of our suppliers utilized by our Item and Cost Maintenance Group. It's a glorified spreadsheet in that one person on the team has the ability to edit, while the balance of the team can view records only. The initial excel file simply had a tab for the data manager, and another for the team to use in which they entered a MFG Code and a series of vlookups pulled over the data onto the "form." The issue is that over time it has become a very large excel file and was cumbersome to both edit and share. In rebuilding it I'd like to try and keep the easy type in MFG Code interface with the team at large, and from the Dashboard I just use the quick built in table search feature and use an exact match. That brings me right to the data form in view only mode for the team. PERFECT! But if I create a report in which I specify the user to select the MFG Code (from a list of 60k+) it kicks into a report first for them to have to click and view the form. Not a big deal I suppose, but it's an additional step. Additionally, I'd love to embed something like the Dashboard built in search in the form for them to find another without having to exit to the table's default report.28Views0likes6CommentsWHEN 1 RESULT IN SEARCH, DIRECT TO FORM INSTEAD OF REPORT
I'm looking for a way to give my users a faster way to retrieve their search results (fewer clicks.) Right now when creating a report utilizing "ask the user" on a specific field it returns the values in a table instead of directly to the form. Just cumbersome and needless. What I'd like to do is essentially re-create the quick table search on a homepage. When what I'm searching for has a single exact match, the record is presented in form view instead of a table. If there is a quick URL I'm overlooking and could utilize to create a field for and set as the default value right on the form would be great. Allowing them to easily bounce from the current record to another as well. My coding skills are clearly less than optimal. Any ideas?22Views1like10CommentsRe: Is it possible to filter a map report on the mobile version?
I'm having an issue with utilizing "ask the user" filter options on a Calendar report as they should appear as a selection, but instead are asking for text. If my users don't type it in exactly as it is listed, I'm guessing nothing appears. Additionally when I test it, the "GO" on the report doesn't present anything even when I know the text entered is correct (as opposed to the Full Site for which they utilize the drop down selections and there is no concern.) Is this the same known issue and related to above?6Views0likes1CommentHow do I make my formula-URL link to a specific record?
I have a table in which I am storing revision controlled documents, and a table which manages project steps. These documents help guide users through the stepped process with things like negotiation and contract language, and I need them to appear in the respective sections of the project form. The two table are not related, nor do i think they need to be in that only admins will have the ability to update these controlled documents. When I use a simple URL, I can only set a static location in the default value that points to a specific document, not necessarily it's revision, nor does it populate for existing records. What i would love to do is create a button that will direct to say the latest negotiation document (this is a field that will be static while the revision may change.) Any ideas?Breaking out a user list to individuals when creating a chart
I have application in which projects are created by a Project Owner, in addition there may be a small team of users who are in a support role in the project. When looking at workloads it's easy to create a chart by individual Project Owner and stacked by project status as there is a singular project owner. But when I go to create the same chart for Project Support Team it combines all users listed into a single instance instead of breaking out by individuals. Any suggestions on how to overcome this shortcoming?Re: Keeping (or adding) decimal places when converting number to text...
Thanks for your help. I ended up doing what is probably the most basic solution, block non-local currencies at the role level. Note ideal, but it will get the job done in terms of showing in the correct currency as well as being able to total etc.10Views0likes0Comments