About JSO

JSO

I have a table "Week" with a field called "NumWeek".When I am in a record of that table, I want to copy the value of "NumWeek" to another table called "Config" in the field "WeekConfig" when I press a button.What would be the best way to do it?The ac...

JSO · 06-26-2024

The action "App: go to another view within this app" when defined in a Table view with the expression LINKTOFORM(id, view) should cause the Table to be presented on the screen but containing said record.

JSO · 06-26-2024

If the action "App: copy this row and edit the copy" allowed defining default values for the columns that are different from those of the original record (as is done with the action "add a new row"), said action It would be much more flexible.Examp...

JSO · 06-11-2024

I have an action of type:Data:set the values of some columns in this row Is there a problem with the format?:[_INPUT].[oneDay]. In Advancer I have defined:Name: oneDayType: DateTimeDefault value: TODAY() Last week it was working fine for me.

JSO · 05-25-2024

In a Table View with records ordered by date, I try to create a button that takes me to the last records in the Table View.I have tried with LINKTOROW(key, ViewTable) but it doesn't work.Is there any way to do it?

JSO

You are right. What you propose is more reliable.In my case, this process is executed by a single user.

JSO

Based on the information you provided, I have changed it slightly.I use a text field in the source table that I call Marker.In the first action I give Marker the value of Yes.In the second action I change the expression to: ANY(SELECT(Week[WeekNum], ...

JSO

Great!. It works.Thanks a lot. I was stuck.Maybe AppSheet should consider the action"Data: set the values of some columns in other table"allowing to indicate "For a record if this table", "Reference Table" and instead of "Reference Action" put "Set...

JSO

I would be very grateful if you could share it.Best regards.

JSO

1. No, there is no relationship between the tables.2. Yes. Config.[Weekconfig] is updated with the value of Week.[NumWeek] every time the action button is pressed on a Week record.

My Stats

JSO's Bio

Badges JSO Earned

Recent Activity

Action to copy a field into another table with a single record.

Actions

Actions

Error en [_INPUT].[...]

UX

Re: Action to copy a field into another table with a single record.

Re: Action to copy a field into another table with a single record.

Re: Action to copy a field into another table with a single record.

Re: Action to copy a field into another table with a single record.

Re: Action to copy a field into another table with a single record.

JSO's Ideas (9)