LinkedIn
Twitter
Agreed.
- If your goal is 1-2 seconds of processing time... I'm not sure you're going to find that anywhere other than by creating a custom cloud function on GCP or something.
________________________________________________________
Perhaps it's a matter of re-engineering the workflow, to account for the fact that it will take X seconds for the file - and bake that into the flow of things?
- I usually find that there's a way for me to sneak things in that the user isn't aware of sometimes that can help, or by creating a smoother flow that accounts for things (with maybe a "Processing" label that appears temporarily when things are cooking) can go a long way.
When I originally created the Answer Portal and people began interacting with Appster through the app, there was some initial push back about how long it took to get the response.
- Everyone was used to what they were getting from ChatGPT, where the results begin streaming in almost instantly, and so waiting 30-60 seconds for the complete generation was a sore spot.
I re-engineered the UX to include a loading GIF (which changes each time, through a list of gifs and a pseudo-random number) so that there was something visually to differentiate that things were "Processing" and something was happening.
I have an example that shows that it is possible to implement SVG as an alternative to generate invoices.
To save time and space I am not going to explain how it works nor am I going to change the name of the variables. I will explain as doubts or questions arise.
The recipe:
Add this 3 VC to Child Table (Ventas):
[Bit_SVG] / Type:Text
Formula:
CONCATENATE(
"<!--Descripción-->
<text x='30' y=""",[Y_SVG],""" font-family='Arial' font-size='12'>",LEFT([ID_Producto_Servicio].[Nombre],47),"</text>
<!--Cantidad-->
<text x='350' y=""",[Y_SVG],""" font-family='Arial' font-size='12'>",[Cantidad],"</text>
<!--Precio-->
<text x='430' y=""",[Y_SVG],""" font-family='Arial' font-size='12'>",[Precio],"</text>
<!--Descuento-->
<text x='500' y=""",[Y_SVG],""" font-family='Arial' font-size='12'>",[Descuentos],"</text>
<!--IVA-->
<text x='580' y=""",[Y_SVG],""" font-family='Arial' font-size='12'>16%</text>
<!--Total-->
<text x='650' y=""",[Y_SVG],""" font-family='Arial' font-size='12'>",[Subtotal],"</text>
<!--Linea-->
<line x1='10' y1=""",[Y_SVG]+5,""" x2='740' y2=""",[Y_SVG]+5,""" style='stroke:rgba(128, 128, 128, 0.5);stroke-width:1;stroke:grey;stroke-dasharray: 5,5' />")
[Número_Carrito_SVG] / Type:Number
Formula:
IFS(
INDEX([ID_Ticket].[Related Ventas],1)=[_THISROW],1,
INDEX([ID_Ticket].[Related Ventas],2)=[_THISROW],2,
INDEX([ID_Ticket].[Related Ventas],3)=[_THISROW],3,
...
...
INDEX([ID_Ticket].[Related Ventas],100)=[_THISROW],100
)
[Y_SVG] / Type:Number
Formula:
SWITCH([Número_Carrito_SVG],
1,180,
2,200,
3,220,
4,240,
...
...
100,2160,
,0)
Add this VC to Parent Table (Ticket):
[Ticket_SVG] / Type:Image
CONCATENATE("data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' width='750' height=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+75,""">
<!-- Fondo de la factura -->
<rect width='100%' height='100%' fill='white'/>
<!-- Encabezado de la factura -->
<rect x='10' y='10' width='730' height='50' fill='rgb(32, 178, 170, 0.65)'/>
<text x='375' y='40' font-family='Arial' font-size='20' text-anchor='middle'>Factura</text>
<!-- Cuerpo de la factura -->
<text x='20' y='80' font-family='Arial' font-size='14'>",[ID_Propietario].[Nombre_Apellido],"</text>
<text x='20' y='100' font-family='Arial' font-size='14'>Fecha:",[Fecha],"</text>
<!-- Titulos Tabla de items -->
<line x1='10' y1='120' x2='740' y2='120' stroke='black'/>
<text x='100' y='140' font-family='Arial' font-size='12'>Descripción</text>
<text x='350' y='140' font-family='Arial' font-size='12'>Cantidad</text>
<text x='430' y='140' font-family='Arial' font-size='12'>Precio</text>
<text x='500' y='140' font-family='Arial' font-size='12'>Descuento</text>
<text x='580' y='140' font-family='Arial' font-size='12'>IVA</text>
<text x='650' y='140' font-family='Arial' font-size='12'>Total</text>
<line x1='10' y1='160' x2='740' y2='160' stroke='black'/>
<!-- Tabla de items -->
",SUBSTITUTE([Related Ventas][Bit_SVG],",","
"),"
<!-- Total -->
<line x1='10' y1=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+10,""" x2='740' y2=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+10,""" stroke='black'/>
<text x='600' y=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+30,""" font-family='Arial' font-size='14' font-weight='bold'>Total</text>
<text x='650' y=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+30,""" font-family='Arial' font-size='14' font-weight='bold'>",[Total_Virtual],"</text>
<!-- Pie de página de la factura -->
<rect x='10' y=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+40,""" width='730' height='40' fill='rgb(32, 178, 170, 0.65)'/>
<text x='360' y=""",INDEX([Related Ventas][Y_SVG],COUNT([Related Ventas]))+60,""" font-family='Arial' font-size='16' text-anchor='middle'>Gracias por su preferencia</text>
</svg>") The texts in red are to facilitate the identification of elements that you probably have to change to adapt to your case.
