AdamKrzyzanek
Qrew Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Add data to Multi-select field
What I did in my app was: 1. Create Relationship and lookup field which will give you option to select 1 option at the time - [Brand] (Text lookup field pulled from a separate table) 2. Create Field which will Capture all values selected in field Lookup field Brand - Example: [Brand_Text] 3. Create formula field which will check for already selected values and add new selected from [Brand] to [Brand_Text]. Example: [Brand_Formula] with code If(Contains([Brand_text],ToText([Brand])), ToText([Brand_text]), ToText([Brand_text])="",ToText([Brand]), ToText([Brand]) & ";" & ToText([Brand_text])) 4. Create From rule which will copy value from selection to [Brand_Text] (See Below) 5. If you want to still have "Multi-select field" then you can use Pipeline to copy value from field [Brand_Text] to "Multi-select field"Re: Formula Field Caching: When A Rich Text Display Lies to You
Thanks for sharing it, I already used it to some of my complex formulas :) The problem of my App Users was, that in some reports they saw [Task Status] value "Good to Go" while when using different report they saw "Wait". Background: "Good to Go" should show up only when All related actions are completed. "Wait" when at least 1 was not completed. When using report which should filter to show only "Good to Go" sometimes they received false-positive result which cause consusion. I hope your solution will trigger for recalculation and will prevent us from seeing it :)Re: Relationship Condition Dropdown stopped to work after formula update
I found that other relationships stopped working as well even if field is filled in by action performed via Button click o add record and populate this field. Still I need to remove value and re-select it again. I will report it as User Case to QB. I checked in other applications where I haven't performed above mentioned change to SMO fields and all conditional dropdowns are not working.Relationship Condition Dropdown stopped to work after formula update
Team, I have a challenge to my relationship update. For my relationship I was using "Formula Field" [SMO_Predecessor_Key] which was selected to create conditional dropdown based on its value. [SMO_Predecessor_Key] used in formula another field [SMO CPS Template] which had some logic in it based on field [SMO]. I no longer need this logic so I decided to rewire [SMO_Predecessor_Key] directly to field [SMO]. After I did it I have problem that my Relationship PROXY field does not work in Legacy Form. It ask to choose [SMO_Predecessor_Key] even if this is already selected. I notice that if I re-select value in field [SMO] in form (i.e. remove value, select it again, even without saving, this starts to work. So problem is with data which are already filled in. [QUESTION] - is there a way to force such refresh to all records and to not need to do it 1 by 1 in form? What I tried: I tried to Import records ID# and field SMO but during Import No update to records (as SMO does not change). Tried to create new field [SMO_Predecessor_Keyv2] and update Conditional Value to it and back. But not working as well. This is how dependency of fields looks line (Blue changed to Green) Current workaround but not well seen by users 😢
