Scripting using multiple user fields

Question

Hello, I am struck with creating resource groups by using multiple user fields in a single script. I would like to combine three user fields (Building section, building number and assembly code) and generate resource groups. I would also like to see the name of resource group corresponding to the user fields. Please see the desired result below 
 [B2]01.bouwdeel shows the building section. (Example: V) 
 [B2]01.bouwnummer shows the building number (Example: V04) 
 [B2]01.NL-sfb code shows the assembly code (21.12) I would like to create resource groups for each assembly code corresponding to the building section and building number. Desired result (Desired resource groups) V_V01_Metselwerk V_V02_Metselwerk V_V03_Metselwerk V_V04_Metselwerk .... ... .... .... Please find the image attached for your reference. I would be very happy to see a solution. Thanks in advance. 
 Best regards, Sujith Mahadevan

Indrawan Wijaya · Accepted Answer

Hi Sujith, 
 
 Second option... you can try this one: 
 RESOURCE ASSIGN_GROUP_BY_ID (UFV_ZERO("[B2]01.bouwdeel") +"_"+UFV_ZERO("[B2]01.bouwnummer")+"_"+UFV_ZERO("[B2]01.NL-sfb code") ) 
 
 Regards, 
 Indrawan

Arpit Prakash · Answer

Hi Sujith, 
 Unfortunately, you cannot create a unique set of Resource Groups using SYNCHRO Scripts. The ideal process will be to use Excel - 
 
 Create a dummy Resource Group (will be used as a template) 
 Create a new Resource User Field, 'Assembly Code', using the following script - RESOURCE ASSIGN_UF("Assembly Code", STRING, UFV_ZERO( "[B2]01.bouwdeel")+"_"+ UFV_ZERO( "[B2]01.bouwnummer")+"_"+ UFV_ZERO( "[B2]01.NL-sfb code")) 
 Expose 'Assembly Code' column in the Resource browser window 
 Export both Resource and Resource Groups to Excel 
 Copy 'Assembly Code' values to the Resource Group 'Name' column and delete duplicates 
 Import Excel in SYNCHRO 4D Pro 
 AutoMatch Resources(Assembly Code) to Resource Groups(Name)

Scripting using multiple user fields

Top Replies