1.How Virtual Column Change Real Column,2.Sync Question

[krirk_luangratc]

1.How Virtual Column Change Real Column
I have 1 Real Column(Status Result), 1 Virtual Column(RealTime status)
I set time 10:00AM timenow 9:00AM Virtual:ok Real:ok
wait. to timenow 10.05AM>>
set time 10:00 AM timenow10.05AM Virtual:Late Real:ok
how to make Real Column value change automatic ?

I’m try to link [Real Column] formula [Virtual Column]
but Real Column only changes when I’m editing and save the form.

I’m try to fix problem by use behavior click

---

2.Sync Question :
when i set time 10:00AM , TimeNow 9:00AM , Virtual Status:OK
wait…
set time 10:00AM, TimeNow 10.05AM, Virtual Status:OK << not change to Late automatic
Have way to make Virtual status change? ( default sync 30min)
have way to sync automatic 5 minute , 10 minute ? or pro plan have sync ?

Thank you

[Steve · Accepted solution]

krirk_luangratchapan:

how to make Real Column value change automatic ?

You’ll have to use an action, triggered by a button press, a view event, a workflow, or a scheduled report.

krirk_luangratchapan:

have way to sync automatic 5 minute , 10 minute ? or pro plan have sync ?

There is no way to change the automatic sync interval.

See also:

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

help.appsheet.com

View Events

View actions can run when certain events happen and help you create custom navigation.

help.appsheet.com

Workflow and Reports: The Essentials

Define automated app behaviors with Workflow and Reports.

[krirk_luangratc]

Thank you very much >< . , I will try to do this tomorrow ^^

[MultiTech]

This might be of help…

Quick Update System - How to update records in your app with a push of a button Tips & Tricks 💡

“How can I update a parent record when a child record is changed?” “How can I mark all the line items in an invoice as paid when I mark the invoice as paid?” “If I have App Formulas inside a physical column, how can I get those to update like a virtual column?” “How can I recalculate formulas with a push of a button?” All of these situations can be solved by implementing a Quick Update System inside your app. What is the Quick Update System? A way to update app formulas and recalculate v…

[krirk_luangratc]

Thank you sir

[MultiTech]

You are quite welcome. (^_^)