Delete a log from a user

dm-dev · 2020-05-25T21:01:41.952Z

Hmmm…deleting data is usually not a best practice for the regular course of business. If the data is gone then it is much harder to audit and track down issues that may come up.

I think it would be better to create a column on your user (or “dutylist”) indicating the status of the user–i.e., on duty or not on duty. Then when showing your dutylist, you would filter to only show users who are “on duty”.

grace.hallak · 2020-05-25T21:05:44.537Z

is it possible to delete current cell’s data?

dm-dev · 2020-05-25T21:10:01.869Z

@grace.hallak Hi Maybe you should make a new post to ask further questions. Yes but there are a couple different meanings to “delete current cell’s data.” Do you mean that you have a cell where you wish to clear what is displayed (make the cell empty), do you want to update the value of a data item (i.e., want to clear out one “field” of one record), or do you want to choose a data item to delete (i.e., delete an entire entry from one of your data tables).

Also the tutorials are very helpful…they walk you through the basics of forms, etc.

grace.hallak · 2020-05-25T21:11:28.717Z

sorry didn’t mean to change the topic of this post. I will see if there are any helpful videos on this.

Kingofthehill4 · 2020-05-27T08:26:21.281Z

When deleting the data from that section it would also be making data in a the “dutylogs” folder showing Time, and info the user provided in input boxes provided when the user clicks “Go off duty” button so logs will be made in a second Data Section, But i do see what you mean

Kingofthehill4 · 2020-05-27T08:34:51.200Z

SerPounce:

currentCheckOut

I tired something like this using the user’s “username” but i’m finding it hard to locate the Data cell created when the user clicks “go on duty” thus making the Entry,

To sum up what i am trying to do

User clicks “go on duty” Button logs “On duty” and the Page shows in a column as him been on duty > user clicks off duty > Logs Deleted, and the column no longer shows him, but he gets logged with whatever data he sent like so V

SerPounce · 2020-05-27T08:40:12.152Z

Kingofthehill4:

but i’m finding it hard to locate the Data cell created when the user clicks “go on duty” thus making the Entry,

Yes, you will not be able to locate “go on duty” record because you have made the type username. I wasn’t totally clear in my previous suggestion, but you should make this type dutyList so you can store the specific record for “go on duty”.

You should also consider @dm-dev advice and avoid deleting records and rather update status.

Kingofthehill4 · 2020-05-27T08:46:21.189Z

would the username not work the same way with it been a value not the “creators name”,

image823×519 18.4 KB

SerPounce · 2020-05-27T08:49:57.466Z

Ah, I see what you are trying to do.

But you have made the user of type “text”. It should be of type “user”.

But you don’t even need to do that because what you will see is that the user = Creator every time, as the Creator is automatically set to the logged in user by Bubble. So just use Creator.

Kingofthehill4 · 2020-05-27T08:54:30.104Z

Username and the Creator’s name a two different Types of names (Mainly for logging reasons)

Account Name > Name used in Discord (i also use discord as a second logging system via
webhooks)
Profile Name > Name Used for logging << Use this one for the “user value” and other “duty” types
and
RP Name > Used for logging RP events and such

all 3 are made during sign up

SerPounce · 2020-05-27T08:58:42.476Z

Ok, so the field “user” represents user name, not user. I see. That’s not really a best practice, but anyhow.

In order to figure out where the problem lies, can you share screen shots from the editor of:

The RG data source
The workflow to create the on duty entry

or just share read access to your editor.

Kingofthehill4 · 2020-05-27T09:01:20.861Z

how do i share read access?

SerPounce · 2020-05-27T09:02:33.404Z

In your application settings, set application rights to “everyone can view”.
Copy/paste link to the editor here.

Kingofthehill4 · 2020-05-27T09:03:50.237Z

Bubble

Bubble Editor - Newdojfivereborn

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

SerPounce · 2020-05-27T09:47:24.474Z

Your dutyList RG has no data source?
Screen Shot 2020-05-27 at 5.46.56 AM

Kingofthehill4 · 2020-05-27T09:50:28.946Z

added it

SerPounce · 2020-05-27T09:53:21.437Z

Still not.

Screen Shot 2020-05-27 at 5.52.49 AM700×590 207 KB

Kingofthehill4 · 2020-05-27T09:55:39.760Z

SerPounce · 2020-05-27T10:02:23.938Z

Ok, it is there now. But I don’t follow your logic at all for what you are searching for the in the RG.

firstly, there is no constraint, and then why are you looking for a first item in an RG? That will only return one record and kinda defeats the point of a list.

Kingofthehill4 · 2020-05-27T10:05:19.721Z

TBH i need to do the tutorial… i’ll come back to that list lol

why can’t it be this easy lol

i probs doing it wrong but why can’t it just look in the data for the name and delete it