General Discussion

  • 1.  Show Warning/Error

    Adopter
    Posted 10-31-2024 01:50

    Hi all,

    I have a repeatable section where the columns have fields like Name(Text Field Copied from its main repeatable section's text field), Select Service Order (drop down field using a data source) , start date (Date Field) and some other fields.

    I have a make a validation for the entered rows. If the field user enters same Name, chooses same Service Order for the same  Date in other rows --> then we should able to show the field user in the front end itself some error like 'We cant entry time for the same technician on the same date with the same Service Order' or something like 'Duplicate entry. Please modify'.

    Basically its like comparing all entered rows - All three fields values should not be same. Is it possible to compare the rows which they are entering the data.

    I have salesforce as destination for this repeatable section.

    Hope I am clear with the requirement.

    Thanks. Have a good day :)



    ------------------------------
    Divya M
    Consultant
    Capgemini, India
    ------------------------------


  • 2.  RE: Show Warning/Error

    Staff
    Posted 11-05-2024 09:22

    Hi Divya, unfortunately there is currently no method in TrueContext to compare the values of questions or rows inside a repeat section, so it won't be possible to set up any kind of warning or error to be displayed if a tech puts in the same name, service order, and date in multiple rows.



    ------------------------------
    Pat Cooney
    Community Engineer
    TrueContext
    community@truecontext.com
    ------------------------------



  • 3.  RE: Show Warning/Error

    Staff
    Posted 11-05-2024 10:03

    Hi Divya, I wanted to let you know that I have logged a product feature request on your behalf to add this functionality to TrueContext.



    ------------------------------
    Pat Cooney
    Community Engineer
    TrueContext
    community@truecontext.com
    ------------------------------



  • 4.  RE: Show Warning/Error

    Adopter
    Posted 11-06-2024 02:55

    Hello,

    If the aggregation question would have the option "Count Distinct", it would be possible to add a concatenated question on the rows with SO&Date&Name and then, outside, two aggregations: count all and count distinct. If they have different results, then there is a duplicate and you can set at least a warning.

    But, aggregation does not have this "Count Distinct" option. Could it be added?

    Thanks!



    ------------------------------
    Alicia Rico
    CI
    Johnson Controls
    ------------------------------



  • 5.  RE: Show Warning/Error

    Adopter
    Posted 11-12-2024 14:35

    Hey Pat and Alicia, this request seems to be similar/ identical to a product feature request we have already submitted a while ago. Nice to know we aren't the only ones.

    Thanks a lot.



    ------------------------------
    Russell Kondro
    Wildlife and Fisheries Biologist
    Basin Environmental
    ------------------------------



Reminder: Content posted to our Community is public content.  Please be careful not to post Intellectual Property that you do not have permission to share.  For more information please refer to our Terms Of Use