Updating a table on the page with logic in the Where Clause

General
1

Hi there

I have a form and a table on the same page. The form writes into the database and the table displays entries from the database, but it only displays items that have the current user’s ownerId in the record.

The logic on the Where Clause for the table is as follows:

where logic
where logic785×208 8.93 KB

My interface with the form and submit button looks like this:

button and table
button and table1573×603 26.9 KB

When I click submit, I can see the record being written to the database (in the Backend view) but the table does not update with the new record until I refresh the page.

Is there a way I can refresh the table when clicking the submit button? Alternatively is there a way I can refresh the page when clicking submit?

Please let me know if there is a solution

2

Hello @Armandt_du_Preez

Please provide your Application ID, container name and page name.

Regards,
Vladimir

3

Hi Vladimir

544AC90A-D633-2481-FF10-B387FC691800
Container: Main
Page: Capture-Fish-Data

Regards

4

Hello @Armandt_du_Preez

I’ve checked your app with a test user, and all works fine for me. But if user is not logged in I catch an error.

I suppose mistake might be located here(and in Where Clause Logic)

image
image729×251 28.4 KB

If Get Current User returns null(when we haven’t active login session), should be thrown an error like below
image

So, in this case, you must check if the user exists, and after that tries to get a property from them.

Regards, Dima.