brians0friends
Technical User
Under the "Select Expert" - Formula
In the first example it pulls "*a" from the "CK_BED_SPACE" field but in the second example it pulls "*A" and "*a" from the "CK_BED_SPACE" field. I don't want it to pull the "*A" (ex. 101A) but instead only the "*a" (ex. 101a) from the field. I need to run the second script, example two, because I have multiple criteria for the capacity. For instance if "capacity" = 3 then pull "bed_space" *a, *b, *c. Next statement is if "capacity =2 then pull "bed_space" *a, *b. I have multiple statements to run so I connected them using an "else", but once I did this the statements pulled the additional "*A", which I do not want. HELP
Example one:
IF {RMGT_T_ROOM_CONFIGS.ROOMS_CAPACITY} = 3 then
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*a" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*b" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*c"
Example 2:
IF {RMGT_T_ROOM_CONFIGS.ROOMS_CAPACITY} = 3 then
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*a" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*b" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*c"
else
IF {RMGT_T_ROOM_CONFIGS.ROOMS_CAPACITY} = 2 then
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*a" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*b"
In the first example it pulls "*a" from the "CK_BED_SPACE" field but in the second example it pulls "*A" and "*a" from the "CK_BED_SPACE" field. I don't want it to pull the "*A" (ex. 101A) but instead only the "*a" (ex. 101a) from the field. I need to run the second script, example two, because I have multiple criteria for the capacity. For instance if "capacity" = 3 then pull "bed_space" *a, *b, *c. Next statement is if "capacity =2 then pull "bed_space" *a, *b. I have multiple statements to run so I connected them using an "else", but once I did this the statements pulled the additional "*A", which I do not want. HELP
Example one:
IF {RMGT_T_ROOM_CONFIGS.ROOMS_CAPACITY} = 3 then
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*a" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*b" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*c"
Example 2:
IF {RMGT_T_ROOM_CONFIGS.ROOMS_CAPACITY} = 3 then
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*a" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*b" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*c"
else
IF {RMGT_T_ROOM_CONFIGS.ROOMS_CAPACITY} = 2 then
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*a" or
{RMGT_T_ROOM_CONFIGS.CK_BED_SPACE} like "*b"