I have parcels with different landuse classes: Business, Residential, etc. I would like to generate a unique id when the parcel is being split. However, I need to generate a different id and counter depending on the landuse class. If Business, then generate B1, B2, B3, etc. If Residential, then generate R1, R2, R3, etc.
This is my progress.
Table Name | Field Name | Value Method | Value Info | On Create |
---|
Parcel | PLOT_ID | GENERATE_ID | COUNTER_B | TRUE |
Parcel | PLOT_ID | GENERATE_ID | COUNTER_R | TRUE |
Parcel | PLOT_ID | EXPRESSION | IIf([TYPE]="Business","B" & [PLOT_ID],"") | TRUE |
Parcel | PLOT_ID | EXPRESSION | IIf([TYPE]="Residential","R" & [PLOT_ID],"") | TRUE |
I could not figure out how to trigger it. Any help would be appreciated.