Submitted by column not appearing in database

Until 2 days ago the submitted by column would always autofill. Now that column is missing even though it is the same as username. This has meant users can;t see their own data now.

@d_j_soares Welcome to the forum.

This issue may be related to a change in your data collection settings.
Are you currently allowing submissions to the form without requiring a username and password?

1 Like

Thanks for that tip. Yes that must have changed when I redeployed.

How do I get those usernames on those few records in the live database. Do they have to resubmit their data ? Or can they find and edit it?

Des

Unfortunately, _submitted_by is submission metadata and not directly editable by users (they can only modify actual form data fields). If there are only a few like this then I might suggest they just resubmit, after authenticating of course. Otherwise, this would require direct intervention by a server admin to manually change these fields in the backend database.

2 Likes