About Encrafted

Encrafted

It makes the most sense to start with the form. So, basically from a start date this is going to generate scheduled session days from the options selected. I want to have a virtual column in the form preview those dates. I wrote the code that I thoug...

Encrafted

This is what the table looks like. Of course you can change it to be gallery or whatever suits you best.I don't know if it's possible but a nice added function could be to create an action that copies the selected row's ID or Hex code to the clipboar...

Encrafted

This is what the table looks likeThe leftmost column is an Image type with the bare minimum SVG code. [Encoded Hex] is a virtual column that just uses ENCODEURL() on a column with the hash-hex colour value. CONCATENATE("data:image/svg+xml;utf8, ") An...

Encrafted

So I've made a slice of the table Creative Options as followsI have a different table for Personnel which uses [Creative options] for an EnumList of Ref type. To make the detail view look slightly nicer I've got a virtual column with the following in...

Encrafted

Exactly what it sounds like. I uncheck "Allow other values" but I have a vague idea it doesn't work because it's a reference type.People can click the "new" which takes them to this:Obviously I don't want this, I want someone to select from the pre-d...

Encrafted

I think I'll have to make a looper column to replace [_THIS]. It's just another virtual column with a formula pointing to my virtual preview column. Doing that stops AppSheet complaining about the MAX() function, anyway. I'm finding other mistakes in...

Encrafted

Thanks, I'm pretty new to AppSheet so I didn't want to post this there straight away in case it turned out I was overlooking a major issue.

Encrafted

I'm pretty new too but I think you'd have to create a column for this "check all" button. Call it [Select All], made as a single choice Enum. I'm assuming this checklist is a form, btw.Then in all the Yes/No columns you want it to change go to the Up...

Encrafted

Welp, I've solved it myself again. Forget expressions, I missed this in the column edit:With the correct slice chosen it now looks like this Hey, at least I understood FILTER() correctly! And I would still like to know if it's possible to wrap the co...

Encrafted

Never mind, I've solved my own stupidity again. I just needed to disable the ability of AppSheet to change the referenced table. I forgot that was a thing.

My Stats

Encrafted's Bio

Badges Encrafted Earned

Recent Activity

Getting a virtual column to generate list of dates in a form with complicated spacing options

Colour palette table to reference in SVG Image expressions

I've made a colour palette table to reference in SVG Image expressions—is it a good idea?

Virtual column filtering from a Slice showing columns I don't want included

Disable ability to add new entries in Enum or Enumlist of Ref type in Dropdown mode

Re: Getting a virtual column to generate list of dates in a form with complicated spacing options

Re: I've made a colour palette table to reference in SVG Image expressions—is it a good idea?

Re: Need button that will change True to False in one column of every row

Re: Virtual column filtering from a Slice showing columns I don't want included

Re: Disable ability to add new entries in Enum or Enumlist of Ref type in Dropdown mode