Edit view / add field: Select or add new one

[FelipeCaru]

Hello all,

I have yet another question that I am not sure if it is possible to do or not.

In my edit screen, which I can see from either Detail>Edit entry or by adding a new entry, I want to be able to have the option to either write a new "title" or selecting from one already created. I know it sounds confusing, maybe, so, in images.

In my entry view, I have a list of projects to choose from, and shows the task I have yet to do. Keep in mind that project list. Now,

This is edit/new entry view. In this one, on the data that is on the red square, I have to add to what "project" it belongs, or type a new one if it is, well, new. So what I want to know is if it is possible to there choose from one that already exists from list or write new one, if needed; or perhaps write project name and give suggestions of name that already exists; if it doesn't exist, say "no match" in the suggestion field.

So:

• Select "title"/project from list or write new one
• Select "title"/project from suggested list when typing or write new one

Thanks in advance,

[RandyHayes · Accepted solution]

@FelipeCaru 

You'll need to always adjust your Formulas based on your own app names.  If I've put "dataSource" in a formula, that's just a representation that this is where you put YOUR datasource.  It appears from your photos, that it is called demo_project

I am also assuming now that your DataCardValue1_1 has been deleted and you are now working with DataCardValue18.

So, from what I see, your formula should be:

   RenameColumns(Distinct(demo_project; Title); "Result"; "Value")

The Update formula error should go away once the above is corrected.

Let's see if we get you there in this one...

[FelipeCaru]

Whoops @RandyHayes was confused since there was in the default one one called with "info" 😛

Also, nooope, not yet. Altough, now I could be forced to choose one:

Not sure what I am doing wrong tbh.

As additional info:

[RandyHayes · Accepted solution]

@FelipeCaru 

Double check your properties on the DataCardValue18 combobox control.

Make sure you have the following:

   Allow Multiple Selections to Off

   Allow Searching to On

   Items to Parent.AllowedValues

   Default to  {Value:ThisItem.Title}

   InputTextPlaceHolder to whatever you want the hint text to be.

   DisplayFields and SearchFields to ["Value"]

[FelipeCaru]

"Search" had slipped by and was off, turned it on, and also added that default value @RandyHayes .

I now have:

Which allows me to write one and keep it, however, the list to search only shows "Title"

[RandyHayes · Accepted solution]

@FelipeCaru 

Perhaps good for a laugh to conclude this for you...

I didn't notice it before, but you have quotes around Title in your distinct statment (RenameColumns(Distinct(demo_project;"Title");"Result";"Value") ) so guess what...you're only going to have "Title" in your results 

So, change your AllowedValues to:

  RenameColumns(Distinct(demo_project;Title);"Result";"Value")

And you *should* be good.

[FelipeCaru]

Not sure if you or I should cackle and yell "IT WORKS" (instead of the classic it's alive), since, well, it works 😄

Thank you!
Seems I'll have to mark some many answers as solution @RandyHayes 

[RandyHayes]

@FelipeCaruAlways good to hit the end goal! 

[FelipeCaru]

@RandyHayes 

Sorry to bother(?) you yet again.

Regarding the combobox, I have no problem adding a new one, however, when editing one, it says the error of "requiring an entry or has a not valid value. Correct and try again" (I think it's the default error on it).

What can I do?

[RandyHayes]

@FelipeCaru 

Throw a screenshot this way so I can see more specific what you are seeing.

[FelipeCaru]

@RandyHayes 

Posting now a "step by step" of how I get the error, so to speak.

I go to the detail view, then go edit, then select one option and when trying to change that, says error there.