Can some one assists me I want to create action workflow that will count the minutes/seconds from the time when a record is created in the table.
Not sure to understand your needā¦
but once a record is created, you can use the interval (in minutes) between current date/time and this recordās creation date to calculate the time since it was created.
Yes but how do I formulate my statement:
Example table below:
I have the INPUT field where ParkingID is inserted and
I then want to count the minutes from the time the record was created in the table till present time when I input say: bay002 into the INPUT field.
Please help me.
If I understand well, you need to specify that at the time you create bay002.
So when the input is modified, you should create a workflow doing a calculation using āCurrent date timeā - āDo a search for Parking sorted chronogically Last itemās creationdateā āformatted as minutesā.
Yes that is correct my bro. Let me try it will let you know soonest
Hi I did try the above formula but it returns only the minutes of Last itemā creation date. But I need to return the minutes of any item that I INPUT its value.
can you send a link to your editor? would be easier to help you
I think what you should do itās to store the calculation result in an attribute of the thing you createā¦
Hi bro here is the link : https://bubble.io/page?type=page&name=middleburg&id=ipanda-parking&tab=tabs-1
Inspect GROUP-H,
cannot access to it, you have to make your app public
or do this on the forumapp Open app for forum questions
Ok its public now check it out
Can you explain me more the user flow you want, like this, I donāt really understand what you want to achieveā¦
First thoughts :
PArking rate : you should do a search for the parkingmeter that dueparkingmeter = the inputās first item (the same way you did for Parking cost price
For parking time spent : you shoud do a search on parkingmeter with a sort on creation date with descending āyesā
But again, I donāt get the user flow you want to designā¦
and due to your privacy settings, as not logged in, I cannot see the group H in previewā¦
Here is that Parking Meter No. = Input Type here 'value which is the stored in the table Parking Meter>>DueParkingMeters. When that value is diplsayed I want to also display the ācreation timeā in minutes under Parking Time Spent>>
Run Preview and go to PAY PARKING button enter any number from table Parking Meter under DueParking Meter and submit then go back to PARKING COST button and view the fields
Try any number from the DueParkingMeter field and wait for submit button to appear
But regarding you creation time : you expression in āparking time spentā is great, but you need to do the search with contraints
Dueparkingmeters = input
the submit button do not appearā¦
Sorry about I dont know wats up going on but I added the constraint and it works.
But While I have you on this can you look at the Parking Cost Price:
I need to add calculation the minutes from the Parking Time Spent to add Parking Rates>>value (R0.50) 50 cents for every minute and display the amount in the Parking Cost Price
1 Like
So in Parking cost price, copy the expression you just create in Parking time spent
and at the end add " * " and recopy the expression you have in Parking rate.
But when you search for tarriff, the same way you did before, add the constraint dueparkingmeter = inputās value