Certain text entries showing when view conditions are not met, and vice versa

Describe the bug:

  • Some items with a view condition to show itself when a column equals a certain value are doing the opposite (i.e., showing when condition is not met, and not showing when condition is met).
  • However, there are other items with nearly identical view conditions that do or don’t show as intended.
  • I’ll show a demo below:

In my app we have a recruiters table and a vacancies table, where each recruiter can be linked to multiple vacancies (via a column relation). Shown above is a dashboard page connected to the recruiters table, and the filters for this page are shown below (basically it should read data for the recruiter viewing it).

Below is a list that shows the viewing recruiter’s vacancies, along with its conditions:


If I were to open the detail screen for the 1st one, and then open its edit screen, we have this:


vacancy-text-conditions

The selected text is showing on screen. However, if we look in the back-end, for this vacancy, this column’s value is set to 1, even though this text is still being displayed. However, the text would hide if this column’s value were 1, giving the opposite of the intended behavior.

The back-end data from the recruiters table (for the viewing recruiter) is shown below:



![rec-table-vacancies-listed-column|682x500](upload://o72FThNBlvAZPooOqT31jGtwFOd.p

As you can see the text is being shown when it shouldn’t, and vice versa also happens.

A similar situation takes place with the users table (for the candidates user type), but there the text entries do (not) show as intended by their view conditions. I suspect maybe Glide is not handling the relation data properly? Who knows.

Expected behavior:

  • The items affected should show when their conditions hold.

Feel free to reach out to me of any questions regarding this, so we can solve this bug together!

So the Recruiters table is not your User profiles table?

Correct.

In this app we have 2 different user types, namely Recruiters & Candidates. Each have their own dedicated tables to store data uniquely for them, but common user data is stored on the user profile table.

Something seems off to me if it’s behaving the opposite way. When you’re on the edit screen or the details screen of “Data Scientist Inc 1”, can you click the “Data” tag on the bottom left and tell me if the data belongs to that row?

Yes, see below:



As you can see the text is showing when it shouldn’t (and vice versa).

Can you show us how that if-then-else column is configured?

I’m wondering if it’s returning a string 1 instead of a number 1.

You might be better off configuring that to either return true or empty, then your visibility condition can test for checked/is not checked.

Sure, see below:

Also, if I check if the column is empty or not, it also gives the opposite behavior:


Unless I’m missing something, I can’t see any reason why that wouldn’t be working as you have it.

However, try my suggestion: change it so that it returns true (this will make it a boolean), and then use “is checked/is not checked” in your visibility conditions.

See if that makes any difference.

1 Like

Sure, I just made a new column as you said with true/false values and now am reading from it instead.

Here is the result, still a similar issue:


Question: is that value already set before you open the edit form?

I just did a test, and it works for me as expected. However, if the value changes whilst the form is open, the change is not reflected.

Yes, that value is already set before opening either this vacancy’s detail or edit screen/form, and still is set when opened.

In case you missed it though, when you tested it, I had it set to show when the column IS checked (was supposed to be set to the opposite).

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.