I added a key column and ref column and know I do not have the option to add a new entry on my form.
What do you mean you “don’t have the option”? Is there an error, or is the add button missing, or something else?
How did you add those 2 columns? You added them to the table itself, like with regeneration, or something else? I notice your first screenshot is of a Slice config, why did you include that?
I added the key column because i originally had the option to add(so you would click the drop down and it had all the current entries then an add button at the top, but it would not let me add a duplicate company name, which I need to do for this form. I then regenerated the column structure. I then updated the slice to include the key column, I added the slice photo to show that adds are turned on. What I really need is just a list of current values or the option to just input a new one, can you enum a whole column that automatically updates as you add?
Ive messed with this 87 ways and cannot get it to let me add a new company.
So you’re wanting to add a new record from the dropdown of the [Company Name] Ref column? And how exactly is it not working now, does the ‘add’ option not appear in the dropdown anymore?
I assume you have a Company table. But you want to be able to add a new company with the same name as an existing one? That doesn’t make much sense.
Which table did you add the key column to? How does the Slice fit into this?
can you enum a whole column that automatically updates as you add?
Not really.
Correct, I have a company sheet, I have also gotten rid of the slice and just made a separate sheet with any other data from that sheet, so now I only have the rows I directly edit. The reason I at new ones to this is this sheet fills back into a filter change spreadsheet I use outside the app. Up until I added that key row I could add a new company from the Add Company Form but it would not let me add duplicates, so I created a key column so I could add duplicates but now it wont let me add anything just selected whats already in there.
Is the Company table set to not allow adds?
Finally got it, Unref’d and then scrolled down to “Suggested Values” and put in Select(App List[Company Name],TRUE,).
Now I don’t have my ref to my company list but I think I have that working also.
Now to test