About Sully

Sully · 02-06-2024

Longtime listener, first-time caller here. Looked around and couldn't find an answer to this one:I have a table of "Task" records that has two ref columns: one is a required "Project" field and the other is an optional "SubProject" field. I wanted to...

Sully · 02-07-2024

Looks like this method will no longer work after the change in Drive functionality is completed May 1, 2024. While Drive will no longer allow download links, links to viewing files in Drive would still be possible, so the link could presumably be ref...

Sully · 02-07-2024

Thanks! Never occurred to me to define the field's initial value with a reference to itself. Counterintuitive, but it works!

Sully · 02-06-2024

1) Perhaps I'm sidestepping your question here, but wouldn't it be better to have "Start" and "Stop" be actions instead of dummy enum columns?2) In your current method, if your start enum is still set, it sort of makes sense that the time resets on t...

Sully · 02-06-2024

If you add a Drive shortcut for the desired folder to the root folder where your gSheet is, you can simplify your filepath to just start directly at "/{folder name}/{file name}"

Sully · 02-06-2024

Make an "Update Thread Project" action that sets the Project value using an [_input] variable.When you designate the action in the bot configuration, it will give you the option of assigning the variable, so you can set it to [_THISROW_AFTER].[Projec...

My Stats

Sully's Bio

Badges Sully Earned

Recent Activity

Default values for related ref columns

Re: How to download images and files in Appsheet

Re: Default values for related ref columns

Re: Time duration

Re: Appsheet path pdf files

Re: Change data in select rows when one is changed