Good day All,
I want to create a checklist of items, then when that item is selected I want other fields to open to add more info. If possible I would also like to capture TODAY() when the tickbox is selected, else the user need to capture the date in a field which would appear when selected.
Below an example of what I have in mind.
Is this possible, if yes, what would be the best way to create it?
Thanks
You can make an action to be a grouped action. Make it change to the tick box, and then record a timestamp. This will require a timestamp column and an action set to record NOW(). you will then take the grouped action choose the two actions the one for check box and the timestamp. then you will replace your non checkbox action look and placement for the empty box action with this grouped action. let me know if you have any questions.
Thanks Trevwiller,
I am fairly new to AppSheet. I am not entirely sure what to do or how to follow your instructions. Another thing that breaks my mind is to understand how it will be handled if more than one option is selected, would this work for multiple selections?
So actions work on a per row basis. It allows you to only edit one thing at a time unless you need it to work on more rows. they are a little complicated at first but get easier the more you practice.
go to the actions menu (lightning bolt)
create new action or the + add action
Then select the table you want the action to work in (where your checklist data is stored)
choose your timestamp column in the set these columns drop down list
then in the = (formulas/functions) you will input this expression NOW()
This records time now date and time (timestamp)
pair this with another action
makeanother new action
then do it as a execute a sequence of actions
choose your checkbox action and the timestamp action we made in the add actions
This will now be the action the person clicks
make the grouped action inline and link it to the column that has your check box’s.
Thanks, this make sense.
I want to paint a quick scenario. In the table I have a field for the 7 options to be chosen (Driven by App Sheet), I then have 21 Additional columns “Date Requested”, “Date Received” and URL to document for each column.
Will I need to make an action for each of these columns?
What if the user selects one option today and the next day the user selects another column, will the actions still run as explained?
I just tested this and almost works.
I built an action and when I select “Option 1” it fills the date for “Option 1 Date” Field.
But when I select Option 2, the date field for Option 1 still gets filled. This make sense, as it is referencing that field.
How would it work if you select Option 2? I mean, how would it know that “Option 2” were selected to fill the date field for Option 2?
In my mind it should work something like this, the equivalent of creating an IF statement for each date field.
IF([Option_Field] = “Option 1”, NOW(), “”)
IF([Option_Field] = “Option 2”, NOW(), “”)
etc.
The columns will still run as explain. Why do you have 21 new columns? Is each column for a certain checklist item? The action only runs for the row it is clicked on. if the user clicks a different row they will record a new timestand for the row they clicked on.
Will you be able to share a picture of the app checklist view. So I can get a better understanding of your structure.
So unfortunately I have re-written this message a few times now and end up making very long messages on different ways, but all require a lots of steps to get this done and some would require possible hands on help. Best of luck finding a solution! There are some very qualified people on this Community that can provide further assistance you could possibly reach out to.
Thank you so much for all your help. It pointed in the right direction at least.
Turns out there is a very simple solution to this. I used a ShowIf solution for when to show the date field of each option.
IN(“Option 1”, LIST([Option_Field]))
In the “Initial Value” I did something similar with an IF statement.
I repeated it for all the Options in each date field and it works. It is not elegant, for when the Option field grows I will have to “code” this for each additional option. But at least it works for now.
Thanks again, I really appreciate your willingness to assist.
