Berto2002 Posted March 9, 2023 Share Posted March 9, 2023 On 3/7/2023 at 7:58 PM, samwoo said: I also struggle with remembering what field is being used for what across all services @samwoo bite the bullet as I did: create a spreadsheet, list all your BPMs down the left and all the possible custom fields as columns and go through every BPM and capture the values. Honestly, since I have done that, I use this resource every time I edit a BPM and it has significantly reduced my error and rework rate. As an alternate suggestion, if Hornbill were to allow the existing fields to be more flexible in their type it would also help. For example, I mostly use the text unlimited and text 255 fields and least the integer fields. So allowing a few integer ones to be integer or varchar255 would help also. Options I am considering in this space: concatenation. I did have a habit of mapping IC inputs into individual fields. But I have started to rationalise and concatenate those that aren't relevant to Expressions or Reporting. E.g. we had a form that asked 3 questions about Azure AD and SSO. I now map all 3 into one custom field rather than consume 3 fields recycling custom fields within BPM. Often I use a custom field just to pass a value from one stage to the next in a BPM so after that next stage, the field is redundant and can be re-purposed. E.g. use a full text field to concatenate multiple PCF entries to form an email at the start and then re-use that field later to concatenate the work done for a summary to the user spawning other Requests for certain aspects and those other Requests can then have their own custom fields. For example, we kind of ran out of custom on New Starters so we now spawn-off Mobile phone Requests at the start into their own ticket so they can have a fresh set General re-think about not storing transient data. I probably store too much so I have started using PCF answers more in expressions rather than storing data in custom fields to make choices where the information is only used in the BPM itself 2 Link to comment Share on other sites More sharing options...
Steve Giller Posted March 9, 2023 Share Posted March 9, 2023 17 minutes ago, Berto2002 said: So allowing a few integer ones to be integer or varchar255 would help also. A field has a type, it cannot be either/or. Link to comment Share on other sites More sharing options...
samwoo Posted March 9, 2023 Share Posted March 9, 2023 thanks @Berto2002 for the advice - I most certainly shall give that a go, now you have inspired me with that spreadsheet of yours Link to comment Share on other sites More sharing options...
Martyn Houghton Posted March 13, 2023 Share Posted March 13, 2023 +1 for us as well Link to comment Share on other sites More sharing options...
Alisha Posted March 14, 2023 Author Share Posted March 14, 2023 Hi @Bob Dickinson @Steve Giller, We have now run out of spare custom fields. Is there any progress on us getting additional custom fields please? Many thanks, Alisha 2 Link to comment Share on other sites More sharing options...
Alisha Posted October 10, 2023 Author Share Posted October 10, 2023 Thank you so much for the additional custom fields! That's really going to help us. Where can we find what custom fields we can use please? I couldn't see them in the Requests Table. Is there another table we should be looking at? 2 Link to comment Share on other sites More sharing options...
Sam P Posted October 10, 2023 Share Posted October 10, 2023 Also just come on to say a big thank you for the additional custom fields - these will be a great help 1 Link to comment Share on other sites More sharing options...
Adam Toms Posted October 10, 2023 Share Posted October 10, 2023 +1 on the thanks front. Link to comment Share on other sites More sharing options...
samwoo Posted October 10, 2023 Share Posted October 10, 2023 26 minutes ago, Alisha said: Thank you so much for the additional custom fields! That's really going to help us. Where can we find what custom fields we can use please? I couldn't see them in the Requests Table. Is there another table we should be looking at? I haven't logged on yet, but are they in requests extended? 1 Link to comment Share on other sites More sharing options...
Berto2002 Posted October 10, 2023 Share Posted October 10, 2023 Yes @samwoo: h_sm_requests_extended I make that 40 extra custom fields available in the Update Request >Custom Fields Minor suggestion to Hornbill that it would be useful to have the chars/type on all the fields in this list as a reminder. I think the missing piece is for A to O and 41 to 60 to be appended with "(VARCHAR/255)" or similar 3 Link to comment Share on other sites More sharing options...
samwoo Posted October 11, 2023 Share Posted October 11, 2023 On 10/10/2023 at 09:58, Berto2002 said: Minor suggestion to Hornbill that it would be useful to have the chars/type on all the fields in this list as a reminder. I think the missing piece is for A to O and 41 to 60 to be appended with "(VARCHAR/255)" or similar +1 Link to comment Share on other sites More sharing options...
Steve Giller Posted October 11, 2023 Share Posted October 11, 2023 A Custom Field is a VARCHAR(255) unless otherwise specified. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now