Forum Discussion
BlakeHarrison
5 years agoQrew Captain
I think you'll need to switch around your approach. You'll have to build the formula so that it references the selections in the Text Multi-select field and produces a link/links from that. Use the drop-down on Add/Edit and the formula on View.
In reality, though, I might encourage you to use a different approach altogether and have a child table to both your "fruits" table and the table where the current drop-down is. Your users could just use the embedded child report in Grid Edit to select their options when building the record.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
In reality, though, I might encourage you to use a different approach altogether and have a child table to both your "fruits" table and the table where the current drop-down is. Your users could just use the embedded child report in Grid Edit to select their options when building the record.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- MichaelTamoush5 years agoQrew CaptainIt's funny because essentially I am trying to create something a child table does very easily. One of my users complaints/asks is, can we just select a number of things from a field, instead of adding children. No one likes the 'save and next...save and next...save and next...". They would rather just select a number of items.
I think you may be suggesting not to actually have my users create the children, but use a report link creatively to host the 'links'. Also would work, but I have so many report links on this particular table it's just looking messy, and I like the idea and sleekness of a simple multi select field.
I think I could probably come up with a way as you suggest, to create a formula off my multiselect that hosts the links. But that still gives me extra fields on my page. I'm hoping to clean up the user experience, and thought it would be real nice to use the multi-select, and then simply click on those options in view mode to 'hyperlink' to those records.
Obviously, with so many alternate solutions, this isn't anything holding me up, but now that my tables are getting crowded and messy, every little trick and design maneuver can help the end user experience. I'm currently trying to see what types of creative things I can come up with to reduce the number of report links, which I find a bit obtrusive. I wish I had control over my Report Link to make it just a clean, minimal box (removing grid edit, full report, etc etc). That would help too.
------------------------------
Mike Tamoush
------------------------------- MarkShnier__You5 years ago
Qrew Legend
Mile
I do have a quick select method we could implement where a user launches off a parent record into a report of possible children and then click click click is as fast as they want to add multiple children and then click to return to the parent to see those children added.
If we have not already implemented that technique in one of your apps we could get on a zoom call and do that together.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - BlakeHarrison5 years agoQrew CaptainNo, I'm suggesting that you set the child table's embedded report to "editable" in the form element properties:
This will give your users the ability to enter their selections while building the Parent record and not have to use the 'Add Child' button.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- MichaelTamoush5 years agoQrew CaptainBlake - Gotcha. Yes that would work as well, not a bad idea, maybe I'll give it a whirl.
Mark - I forgot about that trick. I think I have it somewhere in my archives and I'll check it out and contact you offline if I decide to pursue that avenue further.
------------------------------
Mike Tamoush
------------------------------