Hey everyone! I’m building a product that involves defining the working hours of stores for every day of the week. Working hours can be split into 2 “groups” during the day (a store could open from 9AM to 2PM and from 3PM to 7PM)
The database stores the woking hours as 1 entry per “group” and day. For example, there are 2 entries for “Martes” (Tuesday) and 1 for “Lunes”.
Inside WeWeb, I have a columns element that is binded to a list of days. Inside each flexbox, I have another columns element that looks for database entries associated with each specific day, and I have “Time picker” elements inside for users to visualize the hours and to change them.
The issue I’m facing is that when I try to make a POST API call (in this case to Xano) to edit the record when any of the time pickers is changed, I cannot access the value of that time picker in the variables menu in the formula editor (I assume that it is because it is inside columns element, but not sure).
What would be the most practical workaround to this problem? Should I create a variable (an object) tracking hours for each day? How should this object be structured?