Canโt seem to figure out REF result.
I must be missing something.
I have two tables I am trying to relate.
A parent ACTIVITIES table and a child ACTION ITEMS table.
They are related through a RecordID (same column name in both tables).
The REF definition in the ACTION ITEMS table looks like this: {
โReferencedTableNameโ: โActivitiesโ,
โReferencedTypeโ: โTextโ,
โReferencedTypeQualifierโ: "{
โMaxLengthโ: null,
โMinLengthโ: null,
โIsMulticolumnKeyโ: false,
โValid_Ifโ: โโ,
โError_Message_If_Invalidโ: null,
โShow_Ifโ: โโ,
โRequired_Ifโ: โโ,
โEditable_Ifโ: โโ,
โSuggested_Valuesโ: null}",
โReferencedKeyColumnโ: โRecordIDโ,
โIsAPartOfโ: true,
โRelationshipNameโ: โโ,
โInputModeโ: โAutoโ,
โValid_Ifโ: โโ,
โError_Message_If_Invalidโ: โโ,
โShow_Ifโ: โโ,
โRequired_Ifโ: โโ,
โEditable_Ifโ: โโ,
โSuggested_Valuesโ: โโ }
This shows the correct child ACTION ITEMS for the parent ACTIVITIES table, but when I click on an ACTION ITEM in the inline table, I get the proper record, but the RecordID in the child shows a value of โTaskโ, which is actually the value of the โActivity Typeโ column in the ACTIVITIES table.
I was expecting to see the shared key RecordID displayed (not the Activity Type).
Any suggestions why this is happening and how to fix?
Hi Is activity type col marked as label
@Lynn - OMGโฆ I was so focused on the RecordID columns, I forgot to check the Activity Type column!
Yesโฆ itโs a label.
I still cannot really follow the right ways to use labels - so thanks!
Hmmmโฆ I uncheck the Label property in the ACTIVITY table for the Activity Type column, save it, and it automatically re-checks it as label.
Any advice how Labels get auto defined?
@Mike_Adler There has to be some column that serves as the row label for every table. So if you uncheck them all, it will use some heuristics to pick one for you.
@tony - soโฆ every table must have at least 1 label defined?
Is is typically that this is the key field as well?
@Mike_Adler Thatโs right. Itโs not necessarily the key field. In fact, a common case is to have a unique id as the key (e.g. some randomly generated value like UNIQUEID()) and then have a human-understandable row label (e.g. a personโs name).
@tony - thanks for the quick response.
You guys rock.
for some reason this table wonโt let me define any other columns as labels.
It just clears the other columns selected and assigns the Activity Type column as the label.
Oddโฆ
@Mike_Adler That is odd. Are the other columns hidden? Are you un-checking the columns that you donโt want to be row labels? Note that one image column and one non-image column can be used as labels.
@tony- I am obviously missing something.
The columns I am trying to switch to labels are not hidden.
I try to select one and deselect the Activity Type, but it just defaults back.
here is a screen shot of some of the columnsโฆ
@tony - wellโฆ hereโs an odd updateโฆ
I just deselected Activity Type, selected Title, and clicked Save & verfy data, and this time it seems to hold.
Thanks to you and @Lynn for all the help.
This forum is awesome, and I have not seen a team as supportive as the Appsheet team.
Other companies could learn a thing or two from you guysโฆ
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |