Que. You are configuring a record type and utilizing data sync. Appian does Not have access to the source database table, and will not make updates. which data Sync is appropriate?
is it 1)Daily Sync 2)hourly Sync 3)Immediate Sync 4)Manual Sync
Discussion posts and replies are publicly visible
The best way to do this is by Daily sync with the external system sending an event to Appian in case of any data change. You can configure a web API that will receive the record identifiers which are newly created or recently updated by the external system. This way you will never go out of sync.
If the event mechanism is not possible then go for Daily sync. But in this methodology sometimes record data might not be live/correct, so whenever you are displaying a summary record/ consuming in a related action do the live calls to avoid any kind of discrepancies.