Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Will not implement
Workspace SYNCHRO 4D Pro
Created by Edgar Chan
Created on May 27, 2022

ability to use wildcard in script for User field name

When writing the script we may sometime want to sum multiple user field value from different user field name (for example FF CP-1A + FF CP-1B +FF CP-2 +... FF CP-9), we would put prefix or suffix on the user field name so that later we can write script with minimum effort. If this is excel all we need to do is to write SIMIF(user field name column, "FF *", user field value column of the name). However, this cannot be done in synchro, we have to write for resource

RESOURCE ASSIGN_UF("Total FF", NUMBER, UFV("CP-1A")+UFV("CP-1B")+UFV("CP-2")+...+ UFV("FF CP-9")). While for TASK it would be

TASK ASSIGN_UF("Total FF", NUMBER, SUM(UFV("CP-1A")*1.0)+SUM(UFV("CP-1B")*1.0)+SUM(UFV("CP-2")*1.0)+...+ SUM(UFV("FF CP-9")*1.0))

If there is a way to cut short the amount of time to write, it would be welcome.

https://communities.bentley.com/products/construction/f/synchro-construction-forum/229804/how-do-i-use-wildcard-in-the-script-to-include-any-substring/713767#713767

  • ADMIN RESPONSE
    Jun 29, 2023

    Thank you for submitting this idea. At the moment we are not planning to adjust SYNCHRO Script, but we will consider for possible future implementation.


    Kind Regards,

    Maria