Hi, I’m having trouble filtering my tasks. I have been able to filter by room, and then by task per room, but i’ve been unable to filter when i try to use the “add task” form to write into the columns, I want only the tasks in my database that are for that specific room to show up. However, all my tasks show up instead. I can’t get this solved, either all options go away or all options show when I filter. When i add the task, it writes fine to the table and pulls in the relation. I’m very confused here. Thanks
i’ve attached a screenshot of the layout, and of the task datatable
Try using a screen filter. It should be something like “RoomID is Screen->RoomID”.
Also, what is the purpose of that Set Column Values in your onSubmit action? That should not be necessary.
1 Like
i’ve tried using the filter room ID is screen - room ID and 10 different variations but when i do that, for some reason, all the options for tasks don’t show up instead of the ones only matching the particular room.
The set columns i have writes to the task name once it’s submitted. I have a column that says Task Name and a column that’s lookup task name. when it writes to the lookup task name it automatically feeds the other column.
it looks up the task name in the task template (relation)
diving deeper, maybe it’s because (and i don’t know how to add it) in the task page, i have the Room ID as a relation to the task template datatable, but it doesn’t let me select it. I need a column that shows the Room ID but don’t know how to get it input.
here, the data is written to the relation task template ID, i’ve just added another column for “lookup Room ID” and when i use that for the filter, it still includes the task for the kitchen i have instead of just bathroom.
the Rel Task template shows the Room ID (which shows the correct ID); for example, IUtG is for bathroom. The last task i have points to a different room (kitchen - a-sAir2) but in the add task form, all the task options show up in each room even with this filter (Room ID > screen> lookup room ID)
Okay, I see. It can’t pick up the correct RoomID in the form context. Try this:
- Add a text column to your User Profile row
- Change the action on the form to a custom action, with two steps:
– Set Column Values, taking the current RoomID and writing it to the new column in your User Profile row
– Show Form Screen - You should then be able to use that value in your User Profile row as a filter on the Choice component
1 Like
still not working. it writes, but doesn’t pick up the screen.
im even trying to filter the row ID (task template) to match the task template ID on my tasks page, but that doens’t pick up either. It seems no matter what i do it won’t read it and filter properly
wonder if this would be solved by a dynamic list filter of choice? Not sure how to do that though, what columns to create to allow it.
That’s exactly what my previous suggestion was supposed to give.
I don’t understand why that doesn’t work for you - it should.
Would you mind making another video showing how you set that up and where it failed?
i have it writing to the new column but it shows the room being written, not sure if it should write the room name or the task name, the task is input on the prior image. the task template ID pulls correctly and matches to what is in the task database.
Sounds like you’re still trying to filter by the screen value. Have you tried the suggestion above?
yes I think, but i’m not sure where to put the fields or if i did it right or if this issue is in my relations.
Which User Row is it talking about? My user profile table which is a different table? Or create a column on on the User Task or room? I’m lost on this one
It’s the row in the table where you set up as your User Profiles table. The difference with that table is you can always access values tied to it through the User Profile dropdown when you want those values in a bunch of actions/columns/components as needed.
What Darren suggested was to write the Room ID to a column in your User Profiles row, when you navigate to the room’s details screen. At that point, you know what Room ID you’re viewing when you open the form and can reference it as a filter on your choice component.
I still can’t get this. Will i be able to get additional help once I upgrade my plan?
Can you explain what you mean by “additional help”?
How would I do this with 10 different rooms? I keep getting stuck over here on filtering the list of choices. II’ve watched a few videos and no matter what i can’t seem to get it to filter properly. There was something on YouTube i saw, but requires a live site for the hack. I’ve tried rebuilding the database from scratch and i get to the same spot.
The other option is to have each room have it’s own table of tasks; but then on dashboard it’ll be fragmented with adding 10 collections so filtering won’t work well.
If there’s good resources on writing to columns that would be helpful to me too.
Thanks
Let’s circle back here. I still believe this should work.
Which parts of Darren’s comment have you implemented? Can you show us in a video?
1 Like
Have you actually added this step when you open your form? I don’t understand.
Are you using Airtable for this app? Why is your choice component writing to a relation?