About PhilTeare

PhilTeare · 02-09-2024

I would like to log the location a record was created, then update that whenever the record is editted.This does not seem to be possible in one field though. What I've tried so far:Using a column of type ChangeLocationThis does not log location on cr...

PhilTeare · 02-08-2024

I'm trying to implement better version control.I have a Development version of the App, and I use the Versions > App Upgrade to copy those changes across to the Production version when they are ready. That seems to work well.My Issue - connecting to ...

PhilTeare · 10-21-2022

Hello,I'm using many google docs as templates in automation. It seems like I have to set the Template explicitly in automation - i.e. specify the exact file.I would prefer to have it look up the google doc id from a table in my app instead (so the us...

PhilTeare · 10-12-2022

Does anyone know how the options in the automatic filters are ordered, or how to control that?The automatic filters are a great feature, but if you look at this image you can see that if I can order them that would really help my users. FYI it's runn...

PhilTeare · 02-09-2024

That's got me on the right path to the solution - thanks.I've put Initial Value as here().Then I've put ResetOnEdit as [_THISROW_BEFORE].[StartDateTime] <> [_THISROW_AFTER].[StartDateTime].(StartDateTime is the column I want to watch for changes)That...

PhilTeare · 02-09-2024

Sorry, one bit I missed in my initial post. I only want to update the LatLon value when the record is created, or when a specific column's value is edited. I do not want to update it on every record edit.

PhilTeare · 10-21-2022

Thanks, that was my suspicious. That's a shame, it would be a great new feature to have. thanks for the help.

PhilTeare · 10-12-2022

ah magic, I follow.So - I could order the view by "StatusId", then my filter would be ordered. But, alas, this is a map view, and there's no OrderBy Option.But of any others, I could do it that way. thanks for your help.

PhilTeare · 10-12-2022

Apologies @WillowMobileSys , I don't think I was clear enough in my post. The issue is when I open a filter on a ref column.I have a table of Projects. Each project has a column StatusId, which is the foreign key for the Status table.When I want to f...

My Stats

PhilTeare's Bio

Badges PhilTeare Earned

Recent Activity

Logging ChangeLocation and Record Creation location

Changing SQL database for all tables in one go

Store Template File ID in table

How are filter options ordered?

Re: Logging ChangeLocation and Record Creation location

Re: Logging ChangeLocation and Record Creation location

Re: Store Template File ID in table

Re: How are filter options ordered?

Re: How are filter options ordered?