Action that goes to the last record, not a new

CorneliusH · 10-30-2024 12:22 PM

Hi

I am still trying to automate various processes. So I have one action executing a series of data changes to a row already existing, and then I want it to go to a view where the user is expected to fill in some data. I thought the easiest way would be to create a slice that covers only the 3 columns involved, but it creates a new row instead of the last row.

So I tried to solve this by making it only edits, no adds, no deletes, but now I got this:

For one thing, it is trying to create a new row, and not able. Also, the field I need to prompt in data is not to be found:

In the original table, "cant_agregar" is "show" on.

Again, is there anything I am missing?

MiguelPilo

El problema es que te estas dirigiendo a un formulario lo cual significa un registro nuevo y ya lo has limitado ese slice a solamente ser actualizado o editado.

Por lo tanto lo que debes de hacer es primero una vista de tipo detalle (dejala en ref) en la cual agreges las columnas que necesitas editar como "Quick edit columns"

posteriormente genera la acción que los va a llevar hasta esa vista especifica con la acción go to another view.... y usa el target LINKTOFILTEREDVIEW("Nombre de tu vista", [Key_column]="formula o has referencia al valor de tu key column")

CorneliusH

Gracias, me está jalando bien, solo que no me da ningún botón "guardar". ¿Hay forma de obtenerlo?

CorneliusH

Estoy intentando hacer un proceso casi automático. Lo ideal sería lo siguiente:

Primero al cambiar la columna "Agregar?" de negativa a verdadera, es debe desencadenar una serie de acciones que terminen llevándome a una vista donde tenga un calor "recomendado" y una "cantidad a agregar" que debe ser lo más cercana a la recomendada. Luego después de llenar ese campo otra serie de acciones deberían terminar el proceso.

Ahora que esta vista sí está funcionando, tengo el problema de que no puedo iniciar la segunda serie de eventos, un bot solo me deja incluir acciones del tipo cambiar datos, la vista detalles no me deja incluir acciones.

¿Alguna idea?

Steve

For your original need, your action should be of type App: go to another view in this app with a Target expression like this:

LINKTOROW(
  MAXROW("CUBETAS AGREGAR", "_RowNumber"),
  "CUBETAS AGREGAR_Form"
)

Replace CUBETAS AGREGAR with the name of the slice you created if that isn't it already. If the CUBETAS AGREGAR_Form form view doesn't already exist, add it. In the CUBETAS AGREGAR_Form configuration, for the Form saved event action, attach the action you want performed when the user saves the form.

As best I can see, none of what you're trying to do with this process should be done with Automation.

See also: LINKTOROW(), MAXROW(), Run actions based on view events

CorneliusH

Wow! You are a genius! It works just as I wanted it to work!

@Steve wrote:
As best I can see, none of what you're trying to do with this process should be done with Automation.

With automation I mean an action running in the background triggered by a "Save" button, or a bot running an action triggered by a "Save" button, without I needing to navigate from one view to another.

By now, you know my project almost better than I do, but just in case you have not catched up: Basically what I want to archive is to be able to combine different mixes into one. Let's say, I have a leftover mixture that is 50% black, 30 % white, 20 % yellow. Maybe a miss, maybe a costumer ordered it and never picked it up. The current formula calls for 30% black, 40% white, 20% yellow and 10% red. I need a way to do the math and tell me how much "old mix" I can use in the "new mix". Not to forget, it is a human hit and miss procedure so the app will give me a "recommended" solution, but I might hit or miss while trying to comply.

As things stand right now, after following your advice, I am accomplishing this with 2 series of actions: Series 1 is comparing both formulas in a provisional table, and brings me the maximum amount I can use from the "old mix". In the example above the limit is the black. I can only use 60% of the old formula, so if both are 20 kg heavy, the "recommended" field will tell me "12,000 g". That is all I can use from the old mix. After I enter the correct data (or maybe 12,002, 12,004, you gotta allow some tolerance), a second series of actions will calculate the amounts of colors I obtained: 6,000 g of black, 3,600 g of white, 2,400 g of yellow and delete data in the provisional table. Believe it or not: I acomplished that one without asking for help.

For now, the second series of actions is running in the background. Beautifully. Smoothly. Not so the first one. After filling in the necesary data "Yes, I want to add a mix", and "Which Mix?", I have to navigate to the "Cubetas Detail" view and activate the action series manually

Observe: Since I want to have my app saving progress at every step, I have one view set up to navigate to another view. But now I theoretically need to navigate to a different view if I activate the "yes add mix" choice

So, for now I have to manually go to home (dashboard) view, choose "cubetas details" view and click on the action button.

That is the part I would like to "automate".