I have an Action which updates a field called “Next Date” by deriving the date from other date fieldsThe formula is:TEXT(INDEX(EXTRACTDATES(CONCATENATE("""",IFS(DAY([_THISROW].[JV Date])=DAY(ANY(SELECT(FY Periods[Period Start Date],INDEX([List of Per...

HiI have two tables, let’s say A & BB is the child of AMy requirement is to trigger a grouped action from the Detailed View of a Form for a particular record (call it Old Record) based on Table A which will:Create a new record in Table A with some fi...

HiWhat is the best solution to be able to market an app widely with the following requirements:1. I as owner should not have access to the client’s data or be able to read it, either in the app or back end database2. Upgrades to both the app and back...

I have a Bank Accounts table as under: What I am trying to achieve is to get a list of Account Codes (as “Suggested Values” under Auto Compute for the Account Code field) relevant to the Co Code (as defined in the Co Code field above) though multi re...

I am trying to set the value of a field in a row when the same field in another row of the same table is edited by the user Above is the table……so when the user changes the value of the “Cancellation” Column of the 2nd last row, I want the “Cancellat...