Preciso fazer com. que o sistemas ema gere numeros automatico a partir de um numero de referencia… ex. 5300 - ai quando cadastrar os novos numeros, eles seram a partir deste numero.
Thank you so much. I was able to achieve this - the videos took sometime to load. Is it because it is on another platform? It would be helpful to have these 2 videos on YouTube - very useful for a common scenario.
The videos are hosted on Loom. They should load and play normally (they do for me).
I don’t maintain a Youtube channel, sorry.
I understand that you hosted it on another platform Darren. For some reason, it took a long time to load for me. May be, Glide has some place for aggregating very useful community content like this?
I’m loading it normally here. Chrome on MacOS, Vietnam.
Hey, guys
Great videos and tutorials, thanks for that.
Unfortunatly, I’m having this strange problem in the final step: the increment action just isn’t working on my relation column, and I really have no clue why. Could someone enlighten me?
I did just like in the first video, created a table only for the increments and relation, but when I try to create the action to increment the column by 1, Glide simply does not let me select the column and I can’t figure out the reason for that behavior.
(right here glide shows me the column I really want to increment, but when I click on it simply doesn’t select it)
(and then it stays like that)
Thanks in advance, guys
I’m able to reproduce the behaviour you are getting there. It appears to be a bug.
1 Like
Darren has reported this to the team. We’ll let you know if there are any updates.
2 Likes
Hello,
I used the same method, but when I add a row in my users table, the column that retrieves the next user ID does not load, so I have always the same USER ID for the next user and so on. I should refresh my page so the column takes into account the next user ID. I have a free version for testing, is it the problem ?
Does your Users table have Row Owners applied to the email column?
What do you mean by row owners ? row IDS ?
In my case, I have a simple table for users with the next columns :
ROW IDS
Email
Points
Another table for the products with the next columns :
ROW IDS
Name of the product
Price (currency = points)
Another one for the orders with the next columns :
ROW IDS
Number of order
User
Product ordered
And last one for the parameters where I have two columns with one row :
“Last number of order” : single value that retrieves the last value of the column “Number of order” in the orders table
“Next number of order” : Math operation : Last number of order + 1
The problem is that when i add an order in the ORDERS table, the table of PARAMETERS does not refresh and does not get the last number of order in the ORDERS TABLE. I have to refresh so it could work …
I hope it is clear.
Can you show me how you are using this column?
Only with Big Tables, but that won’t help you here.
If I understand correctly what’s going on in your screenshot, it looks like you’re first using a Set Column Values to write a value to your User Profile Row, and then immediately use that value in an Add Row action. Is that correct?
If it is, I wouldn’t expect that to work reliably. A better approach is to create the Single Value and Math column in your User Profile Row, and then use it in your Add Row action.
Also, given that you are using Add Row, I assume that means you are using a Custom Form, and not a native Form?
Hello, No the set column values is to add another unique id not used in this automation.
I tried to do what you proposed : create a single value and math column directly in the user profile row, but I have the same problem
The problem is when I add a new order with a the next number and then try to add another order after let’s say 5 seconds, the number of the last order does not increment in my user profile row. I have to refresh my data as an editor so It works …
Okay, that doesn’t sound right. It should be instant as soon as the row is added.
What is your Data Source? Are you using native Glide tables, or some external Data Source?
Earlier you mentioned:
The above are both Glide Computed columns, right?
User : google sheets table
Orders : google sheets table
Products : google sheets table
Parameters : native glide table
Do you think the problem comes from here ?
I need to have the users, orders and products always in a google sheets because it is easier to modify and bulk change data whenever we want
The videos no longer load. They are just preview GIFs. Can you fix or put them on youtube?