Edit data on upload, instead of upload new lines?

Need help Database
1

Hey, i’m having problems with uploads. I can’t seem to find anything that will let me upload my data, which changes fields within the database, instead of just creating new lines…

Is there a way of doing this?

Or is the only way to delete all data and upload fresh data each time? Seems a bit bulky, and don’t really trust the delete option, i seem to have to delete the line a couple of times before it actually gets rid of it.

Thanks for any further info!

3

Hi Faiz

I mean with no interaction from the user. Its data imputed by me, that i will update weekly regarding the user.

Thanks

Andy

5

Hi faiz, no problem.

I’m not sure creating an edit page is the right way to go, i’m hoping to have thousands of users, in which i update their data via excel each week.

But a background would probably be useful, its a sports fantasy league website, so they make predictions each week and then i export their predictions, then i manipulate their league table data in excel and input that back in via “upload”… I’d love to tell the system to find the user email which always is the same on upload and just edit their existing fields “points” “won” “lost” etc… But unfortunately i don’t think there is a way of doing it.

6

Hi @Andy_i

Did you find a way for this in the end?

Thanks,
Jules

1 Like
7

@jules.marcilhacy

I haven’t found a way, although i think it could be possible by using the unique id field?

That was added after i started so i haven’t tried it, i just delete all the entries and re upload fresh, and have added a few admin pages as an interface for myself to make some smaller data changes.