I have had a time with enum list trying to figure out what Iโm doing wrong. So table 1 has an enumlist with a validif of Select from a table2[column1] where the contactid in table 2= the current row contactid. This brings back the right list in the dropdown and stores the data correctly in the table. But it results in an invalid entry error still. Awhile back the data used to be stored in the enumlist field as table2::column1value but now it just stores column1value. My thoughts are that when it stores the multiple values of the enumlist and then checks against the valid if statement after it is stores, it doesnโt fit the select statement anymore. Should I be using something other than a select statement in the valid if? Is there something Iโm missing. This feel very basic but Iโm just scratching my head trying to figure out what iโm doing wrong.
Just trying to confirm what the structure isโฆ
TABLE1
Column1 (EnumList] with a Valid If formula Table2[Column1]
TABLE2
Column1 (EnumList?)
Is this correct?
But the valid if has a criteria of certain rows in Table2[Column1]. Table2[Column1]is just an image, not an enumlist.
sorryโฆI little moreโฆCriteria for certain rows in Table2 is another columnโฆContactID, (which, if it matters, is a ref column in both Table1 and Table2 to a Table 3 (contact table)
Please provide screenshots of all expressions involved, such as the Valid_If expressions. Please also provide screenshots of the column configuration screens for the involved columns.
Sorryโฆ Iโm not able to understand your table/column structure. Would you please give more details about it, thanks.
TABLE 1 Column 1 is โOtherโ
Nothing jumps out to me as wrong, but your use of semicolon as the separator as unusual. Perhaps remove that and let AppSheet use the default?
Table 1 Column 1 Valid If
Table 1 Data
Table 2 Column 1(โPosterโ) And column 2 (โContactID)
Error message
Yeahโฆunfortunately I tried that. This is totally eating my lunch. What do you think if I break that โotherโ field out into itโs own table? It shouldnโt matter because it will probably have a similar valid if statement, but thatโs the only thing I can think of to help.
I donโt think that would help. I think itโs time to engage support@appsheet.com so someone there can look at your app configuration.
User | Count |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |