Use a key word(code or something else) to delete a item from list(numbered or not) in UX/Dashboard

Livy@acn

just like 

 

a TextBox1 here for input unique key word,   a Button1 here to trigger the action

 

click the button, then will delete the item from a certain list using the condition given in the textbox

 

maybe there's no such function in Anaplan, but would you guys please teach me the most likely way to achieve it?

 

thanks a lot~

KirillKuznetsov

@Livy 

 

The most common way to achieve this is not by text keyword but rather a boolean selector.

List of elements	Delete? (= boolean)	text keyword	possible formula for delete
A	☑	delete	text keyword = "delete"
B	◻	keep
C	◻	remove	the formula would not work for "remove" because the conditions are set for "delete" keyword ("del" also would not work)

The boolean will be you input field and the driver for Delete item from list using selection (https://community.anaplan.com/t5/On-Demand-Courses/Delete-from-List-Using-Selection/ta-p/63600)

You still can apply keyword feature but then you would have to setup the too many rules to check the spelling of the keyword (see table) and users will have to follow this rules in order to achieve the deletion. I would recommend you to go with boolean way.

 

Cheers,

Kirill

AntonMineev

Anaplan has a separate action that removes list items that are have TRUE.

If you need to specifically enter a code/title, you can use the FINDITEM formula to turn the entered text into a checkmark for the Action.

Livy@acn

hi, thank you a lot.

I knew this is the way which has recommend in level 2 training

but if the list is large,  you have to identify/check the item by scrolling a lot

I want to achieve this by......by some normal programming logic

such as, maybe SQL?   delete from SampleList where code=TextBox.Text

thank you again~

Livy@acn

thank you!
but which card type I should use to input some text?
and how I can turn the text I inputted to a "checkmark" which can be used in the FINDITEM formula....
sorry for beginner's easy question....
thank you again

KirillKuznetsov

@Livy 

If i understand correctly you want user to load or input codes of the list items which he/she wants to be removed?

That way you can setup a dummy list with will be needed only as lines for inputs.

Dummy list	Code of the list element	List item [formula FINDITEM('The List', Code of the list element)]
1	123	A (code 123)
2	213	B (code 213)
3

 

Then you simply can apply firstnonblank formula to the List Item line item.

list elements	item for deletion (formula List Item[FIRSTNONBLANK:List item])	Delete? (formula ISNOTBLANK(item for deletion) )
A	A	true
B	B	true
C		false

And finally check with ISNOTBLANK(). This will be your driver

ManjunathKN

Hi 
Below solution might help for you.
I have created1 list & 2 modules for you, 1 module for text selection, other is for showing the display.
Logics are simple. its XYZ  = Selection. 
I have used numbered list here with Text formatted display name like Apple,etc.

1. Text Selection module (text formatted line item.

2. Display module.

After creating 2 module, you need to create delete using selection list using "new action" in "actions".

Your action will be created like this.

 

Bring modules by grid Cards and Action by Action card and configure it.

Hope this helps.

Regards,
Manjunath

 

 

Livy@acn

thank you for your answer~

Livy@acn

thanks~
it seems that I can't do it without a boolean~
I will try it~ thank you a lot !