Time counter

Pleas, How can I make time counter in my app for each mission?

0 9 788
9 REPLIES 9

@Fouad_H_Saad1
Can you elaborate โ€œโ€ฆtime counterโ€ฆโ€?

Thank you sir.
I mean at field survey, as admin I want to know the period of mission from start of fill form to the time of save and send form for each user.

Dear Sirโ€ฆ
I posted in appsheet creator community.

Please, I want to create new app used in food delivery.
One of the app field contain Enumlist for food types e.g (field#1), another field contain Enumlist for food prices (field #2), and 3rd field is (field #3) to summation the total cost of requested food.

My question is how to connect those fields above?and how to excute recording the price of food automatically (in field #2) when customer record in field #1? Also I want to take consideration if the customer record more than 2 types of food in (field #1).
Thank you

Fouad H. Saad

ููŠ ุงู„ุณุจุชุŒ ูกูจ ุฃูŠุงุฑ ูขู ูกูฉ ูค:ู ูง ู… Levent Kulacoglu via AppSheet Creator Community appsheet@discoursemail.com ูƒุชุจ:

@Fouad_H_Saad1 - as there are really a lot of details to understand to properly set up the tables, columns, relationships, slices, views, etc. to handle just part of your use case, I suggest first looking at how example apps have been designed, so you can then ask more specific i advice how to adjust to meet your need. Lots to learn from reading and reviewing examples.

Here is one that may help you get started. May not be exactly what you want, but you can see how relationships have been set up and prices calculated. Hope that helps.

https://www.appsheet.com/samples/An-app-for-store-inventory-management-to-record-stock-levels-and-so...

@Fouad_H_Saad1
Here are the steps on how you can create such a functionality:

  1. Set a DateTime type column. Name this column as i.e. [Start] and set an Initial Value of NOW().

  2. Add a Change TimeStamp type column. Name this column as i.e. [End] and bind this column to track the change of your last field in the form with a value of NOW().

  3. Add another DateTime type column. Name this column as i.e. [Sent] and leave its initial value as blank

  4. Add an Action to your table with below properties:

{
	**Action name:** Type a reasonable name
	**For a record of this table:** Select your table that belongs to your form
	**Do this:** Data: set the value of a column
	**Set this column:** Select the [Sent] column
	**To this value:** =NOW()
	**Action icon:** Choose a suitable icon that you see fit
	**Prominence:** Display prominently
}
  1. Add an Email Workflow Rule to this table with below properties:
{
	**Rule name:** Give a reasonable name to your rule
	**Target data:** Select your table that belongs to your form
	**Update event:** UPDATES_ONLY
	**Condition:** =AND(ISNOTBLANK([Sent]),[_THISROW_BEFORE].[Sent] <> [_THISROW_AFTER].[Sent])
}

After you launch the form to fill data, the very 1st DateTime column will record a DateTime value initially. When you enter the last data to your form, the Change TimeStamp column will capture a DateTime value too. When you save the form, you will notice the action button on the Detail view. When you press this button, it will record a DateTime value in the [Sent] column and as itโ€™s an update action, it will trigger your email workflow.

Thank you Sir about your efforts to answer me.
Is there lecture about how to create action and workflow.

Also, Can I do this action with table in arabic language.

Sure you can.

@Fouad_H_Saad1
You can start reading from below help pages.


Top Labels in this Space