Concatenate expression for initial value for key column.

AppSheet AppSheet Q&A
1

I don’t know whether it is just behaving normally. But I don’t get the result I want. I have a concatenate expression for a key column, which creates a unique ID from the combination of two precedent values from the dependent dropdowns list from the GR_Code and CT_Code

GR_Code values come normal. But for the CT_Code part, it brings the first value from the dependent values of GR_Codes.

CONCATENATE(GR_code],".",[CT_code],".",UNIQUEID())

Thank you for your time.

2

Could you share more detail, i.e. your expectations vs actual results?

The expression you shared does not give us a whole lot to work with.

2 Likes
3

Hi TeeSee1,
Thank you for your reply. I shared some pictures blow to clarify my expectation. I hope this helps.

My Configuration

[details=Show More]

Atlas_2-1665917827255.png
Atlas_2-1665917827255.png1849×530 46.6 KB

[/details]App View

As you could see, PR_CODE expression brings the first value from the dependent list. This value should be 102 for the the PEARS Category.

Show More

Atlas_3-1665917852447.png
Atlas_3-1665917852447.png367×522 17.8 KB

Backend Table

Show More

Atlas_4-1665917886371.png
Atlas_4-1665917886371.png948×239 7.73 KB

4

A few questions.

  1. The app formula for CT_CODE that you have is [GROUP_NAME].[GR_CODE]. Is this correct? (This cannot be right as far as I can see)
  2. CT_NAME is of Type Text, is this correct?
  3. Can you also share the table definitions for GROUPS as well as the table containing CT_NAME and CT_CODE.
2 Likes
5

I made a double and triple check, yes it is not correct. Thank you for pointing out this.

Actually, it was [GROUP_NAME].[CT_CODE] I made a mistake when editing in paint. But even that expression does not return the corresponding values. Because I have a list of the same KEY values for GROUPNAME in the grouping table.

In the product table, I want to bring a dependent dropdown list for the group and category. and yes dependent dropdown works (yey!). While typing the sentence above I found the solution and tried it and it is working as it should be.

I just needed to use an app formula for the CT_CODE column.

SELECT(CATEGORIES[CT_CODE],[_THISROW].[CT_NAME]=[CT_NAME])

Thank you for your time, sir.

2 Likes