Here is what I am looking to do. If a user selects 'Add Product' from the combo box list shown below and text field appears along with an 'Add' button. This is to allow the user to add a new product to the list. What I would like to do is differentiate this list item from the others. I'm thinking making it bold, changing the color and positioning it at either the top or bottom(probably top) of the list (which will be sorted alphabetically) would be the way to go. Is this possible?
Thanks @Future_Vision ,
The one that helped you the most is probably best - this closes the item and makes it easier for others to find in the future.
😀🌴
I have no idea which answer to mark as the correct one since it seems like I had the right code the whole time. So odd that it would fail randomly and then start working.
That proves that there should be a table in the field
newThird.'Third Party (cr9c7_thirdparty)'
which should align with the same type of field in your combo box. As you have it working now, no reason to touch it further.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
This is odd. When I switch the sorting code on the combobox back to the code below(the original code which at one time worked) everything works now - The combobox updates with the text field submission and the sorting works.
Sort('Third Parties','Third Party (cr9c7_thirdparty)',Ascending)
What ls odd is that even though this code worked before it stopped working even though it was essentially identical to what is being used in another part of the form. The comobox box in that part of the form sorted correctly AND updated with the submitted value from a similar textbox/button combination.
Why it now works is beyond me. I've had this experience with other functionality as well. It works. Then breaks. Then starts working again.
That is what I thought - as mentioned I was only testing a possibility.
Did you do the second exercise - you really need to find the correct value of the data to be put in the combo box.
If I drop that in a label I get:
'Name isn't valid. This identifier isn't recognized.'
Firstly, there is a bracket missing (it is in your field name)
{'Third Party (cr9c7_thirdparty)':newThird.'Third Party (cr9c7_thirdparty)'.Value}
I was also looking at your screen shot and it appeared that your table could have been multilevel. You will get an error if it is not. The syntax is correct in the DefaultSelectedItems {ComboBoxFieldSelected:Table/Collection.FieldName}. You just have to refer to the second bit correctly. If you put this in a label
First(newThird).'Third Party (cr9c7_thirdparty'
do you see any value in it?
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Is there a typo in your code? I've tried a few iterations of it and ultimately I get a either a 'Name isn't valid. This identifier isn't recognized' or 'Invalid use of '.' '
Could the problem be that the combobox is refreshing after setting the DefaultSelectedItems?
Try
{'Third Party (cr9c7_thirdparty)':newThird.'Third Party (cr9c7_thirdparty'.Value}
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Right. That is what I thought my image was showing. First image below shows the field selected that uses newThird as the DefaultSelectedValue. The second image is from looking at Variables.
WarrenBelz
146,596
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional