Submit button with required fields notification.

Hi Fred,

I don't understand what you mean "to expand the list of fields that you copy, Shop being one of them." do you mean i have to first add all the required fields in the formula? And then it should work?

Hi,

i understand how to add all the fields in the formula. But I do not want our shop managers go into each table with records. So I have created separate view where they select between three different records Daily sales report, Hanging Production report, Pricing production report. Under each they will find button create report and it opens the entry form. When I click on create report it automatically creates empty record and when i start to fill up data it all goes into that record so until this point everything is ok. But at the end of the entry form is button to "submit record" (i need this as We have problems with managers forgetting some fields to fill up and makes me crazy when I need to evaluate statistics so I need them to be forced to fill up everything) so when they click on that submit button it creates one more record with the same data.

Anyway I think I found the issue, now I have removed from script the part that creates the record so it only pops out the message, and it does not create two records.

What makes me still worry, they will find reasons why not to fill it up all fields despite they get message from button and use the cross to close it. This is why I asked if it is possible to remove the cross and if it is possible to close the entry form when clicking on submit button when everything is filled up?

Fred  I believe i did not describe it properly, as I am very new to this. But it still will help as for now  they at least press the button and see what is missing. 

So just to make sure I understand correctly, in the dashboard I will create new fields with same names as are in the table for Daily sales (where are kept all data) and in the submit button to have script that enters data from dashboard fields to Daily sales under condition required fields must be filled in?

All fields will be required . 

Do you know if there is created topic where I could see how the script goes for this solution? Or what to exactly ask if I post topic for this issue? I am trying to look for something to this issue but cannot find anything.

How would i connect field  "Turnover" in dashboard to field "TURNOVER" in table Daily sales by clicking on button submit? Just give me a kick start... 

Fred Thanks it works! 

I have still one more question. Everything is filled up, click on button and data is uploaded to correct table. Is it possible so the fields in dashboard get empty so new record can be made?

Fred it shows for the newfield1 "end expected

let t := this;
let xlf := urlDecode("%0A");
let dateCheck := if Date = null then 1 else 0 end;
let shopCheck := if SHOPS = null then 1 else 0 end;
let weekCheck := if WEEK = null then 1 else 0 end;
let turnoverCheck := if TURNOVER = null then 1 else 0 end;
let fieldCheck := [dateCheck, shopCheck, weekCheck, turnoverCheck];
if sum(fieldCheck) = 0 then
    let newRec := (create 'DAILY SALES DAPP');
    newRec.(
        DATE := t.Date;
        SHOP := t.SHOPS;
        WEEK := t.WEEK;
        TURNOVER := t.TURNOVER
    );
    alert("New Record Added")
else
    alert("Please fill in the following fields:" +
    if item(fieldCheck, 0) = 1 then
        xlf + "DATE"
    end +
    " " +
    if item(fieldCheck, 1) = 1 then
        xlf + "SHOP"
    end +
    " " +
    if item(fieldCheck, 2) = 1 then
        xlf + "WEEK"
    end +
    "" +
    if item(fieldCheck, 3) = 1 then
        xlf + "TURNOVER"
    end +
    "

    ")
end
newField := null;

referencefield1 := 0

dynamicchoicefield1 := 0

Rafaelstill doesn't work, maybe i dont place it correctly?

Fred  For some reason it displays only first four fields, if the rest of fields is not filled in it will submit the report anyway. Is there something written wrong in the script?

let t := this;
let xlf := urlDecode("%0A");
let dateCheck := if Date = null then 1 else 0 end;
let shopCheck := if SHOPS = null then 1 else 0 end;
let weekCheck := if WEEK = null then 1 else 0 end;
let turnoverCheck := if TURNOVER = null then 1 else 0 end;
let targetCheck := if TARGET1 = null then 1 else 0 end;
let itemsputinCheck := if 'ITEMS PUT IN' = null then 1 else 0 end;
let donationsCheck := if DONATIONS = null then 1 else 0 end;
let otherCheck := if OTHER = null then 1 else 0 end;
let itemssoldCheck := if 'ITEMS SOLD' = null then 1 else 0 end;
let itemsoutCheck := if 'ITEMS OUT' = null then 1 else 0 end;
let ebayoutCheck := if 'EBAY OUT' = null then 1 else 0 end;
let othershopCheck := if 'OTHER SHOP' = null then 1 else 0 end;
let rejectedkgCheck := if 'REJECTED KG' = null then 1 else 0 end;
let customersCheck := if CUSTOMERS = null then 1 else 0 end;
let peopleinCheck := if 'PEOPLE IN' = null then 1 else 0 end;
let onepoundsoldpcsCheck := if '£1 SOLD PCS' = null then 1 else 0 end;
let onepoundsoldpoundCheck := if '£1 SOLD £' = null then 1 else 0 end;
let twopoundsoldpcsCheck := if '£2 SOLD PCS' = null then 1 else 0 end;
let twopoundsoldpoundCheck := if '£2 SOLD £' = null then 1 else 0 end;
let threepoundsoldpcsCheck := if '£3 SOLD PCS' = null then 1 else 0 end;
let threepoundsoldpoundCheck := if '£3 SOLD £' = null then 1 else 0 end;
let bagssoldpcsCheck := if 'BAGS SOLD PIECES' = null then 1 else 0 end;
let bagssoldpoundCheck := if 'BAGS SOLD £' = null then 1 else 0 end;
let workinghoursCheck := if 'WORKING HOURS' = null then 1 else 0 end;
let productionhoursCheck := if 'PRODUCTION HOURS' = null then 1 else 0 end;
let productionkghangedCheck := if 'PRODUCTION KG HANGED' = null then 1 else 0 end;
let productionitemshangedCheck := if 'PRODUCTION ITEMS HANGED' = null then 1 else 0 end;
let cashCheck := if CASH = null then 1 else 0 end;
let cardCheck := if CARD = null then 1 else 0 end;
let fieldCheck := [dateCheck, shopCheck, weekCheck, turnoverCheck, targetCheck, itemsputinCheck, donationsCheck, otherCheck, itemssoldCheck, itemsoutCheck, ebayoutCheck, othershopCheck, rejectedkgCheck, customersCheck, peopleinCheck, onepoundsoldpcsCheck, onepoundsoldpoundCheck, twopoundsoldpcsCheck, twopoundsoldpoundCheck, threepoundsoldpcsCheck, threepoundsoldpoundCheck, bagssoldpcsCheck, bagssoldpoundCheck, workinghoursCheck, productionhoursCheck, productionkghangedCheck, productionitemshangedCheck, cashCheck, cardCheck];
let fieldCheck := [dateCheck, shopCheck, weekCheck, turnoverCheck];
if sum(fieldCheck) = 0 then
    let newRec := (create 'DAILY SALES DAPP');
    newRec.(
        DATE := t.Date;
        SHOP := t.SHOPS;
        WEEK := t.WEEK;
        TURNOVER := t.TURNOVER;
        TARGET := t.TARGET1;
        'ITEMS PUT IN' := t.'ITEMS PUT IN';
        DONATIONS := t.DONATIONS;
        OTHER := t.OTHER;
        'ITEMS SOLD' := t.'ITEMS SOLD';
        'ITEMS OUT' := t.'ITEMS OUT';
        'EBAY OUT' := t.'EBAY OUT';
        'OTHER SHOP' := t.'OTHER SHOP';
        'REJECTED KG' := t.'REJECTED KG';
        CUSTOMERS := t.CUSTOMERS;
        'PEOPLE IN' := t.'PEOPLE IN';
        '£1 SOLD PCS' := t.'£1 SOLD PCS';
        '£1 SOLD £' := t.'£1 SOLD £';
        '£2 SOLD PCS' := t.'£2 SOLD PCS';
        '£2 SOLD £' := t.'£2 SOLD £';
        '£3 SOLD PCS' := t.'£3 SOLD PCS';
        '£3 SOLD £' := t.'£3 SOLD £';
        'BAGS SOLD PIECES' := t.'BAGS SOLD PIECES';
        'BAGS SOLD £' := t.'BAGS SOLD £';
        'WORKING HOURS' := t.'WORKING HOURS';
        'PRODUCTION HOURS' := t.'PRODUCTION HOURS';
        'PRODUCTION KG HANGED' := t.'PRODUCTION KG HANGED';
        'PRODUCTION ITEMS HANGED' := t.'PRODUCTION ITEMS HANGED';
        CASH := t.CASH;
        CARD := t.CARD
    );
    alert("New Record Added")
else
    alert("Please fill in the following fields:" +
    if item(fieldCheck, 0) = 1 then
        xlf + "DATE"
    end +
    " " +
    if item(fieldCheck, 1) = 1 then
        xlf + "SHOP"
    end +
    " " +
    if item(fieldCheck, 2) = 1 then
        xlf + "WEEK"
    end +
    " " +
    if item(fieldCheck, 3) = 1 then
        xlf + "TURNOVER"
    end +
    " " +
    if item(fieldCheck, 4) = 1 then
        xlf + "TARGET1"
    end +
    " " +
    if item(fieldCheck, 5) = 1 then
        xlf + "ITEMS PUT IN"
    end +
    " " +
    if item(fieldCheck, 6) = 1 then
        xlf + "DONATIONS"
    end +
    " " +
    if item(fieldCheck, 7) = 1 then
        xlf + "OTHER"
    end +
    " " +
    if item(fieldCheck, 8) = 1 then
        xlf + "ITEMS SOLD"
    end +
    " " +
    if item(fieldCheck, 9) = 1 then
        xlf + "ITEMS OUT"
    end +
    " " +
    if item(fieldCheck, 10) = 1 then
        xlf + "EBAY OUT"
    end +
    " " +
    if item(fieldCheck, 11) = 1 then
        xlf + "OTHER SHOP"
    end +
    " " +
    if item(fieldCheck, 12) = 1 then
        xlf + "REJECTED KG"
    end +
    " " +
    if item(fieldCheck, 13) = 1 then
        xlf + "CUSTOMERS"
    end +
    " " +
    if item(fieldCheck, 14) = 1 then
        xlf + "PEOPLE IN"
    end +
    " " +
    if item(fieldCheck, 15) = 1 then
        xlf + "£1 SOLD PCS"
    end +
    " " +
    if item(fieldCheck, 16) = 1 then
        xlf + "£1 SOLD £"
    end +
    " " +
    if item(fieldCheck, 17) = 1 then
        xlf + "£2 SOLD PCS"
    end +
    " " +
    if item(fieldCheck, 18) = 1 then
        xlf + "£2 SOLD £"
    end +
    " " +
    if item(fieldCheck, 19) = 1 then
        xlf + "£3 SOLD PCS"
    end +
    " " +
    if item(fieldCheck, 20) = 1 then
        xlf + "£3 SOLD £"
    end +
    " " +
    if item(fieldCheck, 21) = 1 then
        xlf + "BAGS SOLD PIECES"
    end +
    " " +
    if item(fieldCheck, 22) = 1 then
        xlf + "BAGS SOLD £"
    end +
    " " +
    if item(fieldCheck, 23) = 1 then
        xlf + "WORKING HOURS"
    end +
    " " +
    if item(fieldCheck, 24) = 1 then
        xlf + "PRODUCTION HOURS"
    end +
    " " +
    if item(fieldCheck, 25) = 1 then
        xlf + "PRODUCTION KG HANGED"
    end +
    " " +
    if item(fieldCheck, 26) = 1 then
        xlf + "PRODUCTION ITEMS HANGED"
    end +
    " " +
    if item(fieldCheck, 27) = 1 then
        xlf + "CASH"
    end +
    " " +
    if item(fieldCheck, 28) = 1 then
        xlf + "CARD"
    end +
    "

    ")
end

Fred i have made one more button for another report, but has the same problem as with button for DAILY SALES, when i add at then the part to delete information from field, line 127 it shows problem. Any chance you could look please what I am doing wrong? I have used null or 0 according what you wrote before.

let t := this;
let xlf := urlDecode("%0A");
let dateCheck := if Date = null then 1 else 0 end;
let productsCheck := if PRODUCT = null then 1 else 0 end;
let shopsCheck := if SHOP = null then 1 else 0 end;
let employeesCheck := if NAME = null then 1 else 0 end;
let preparedwhereCheck := if PREPARED = null then 1 else 0 end;
let startCheck := if START = null then 1 else 0 end;
let endCheck := if END = null then 1 else 0 end;
let breakstartCheck := if 'BREAK START' = null then 1 else 0 end;
let breakendCheck := if 'BREAK END' = null then 1 else 0 end;
let break2startCheck := if 'BREAK 2 START' = null then
        1
    else
        0
    end;
let break2endCheck := if 'BREAK 2 END' = null then 1 else 0 end;
let break3startCheck := if 'BREAK 3 START' = null then
        1
    else
        0
    end;
let break3endCheck := if 'BREAK 3 END' = null then 1 else 0 end;
let kgpreparedCheck := if 'KG PREPARED' = null then 1 else 0 end;
let itemspreparedCheck := if 'ITEMS PREPARED' = null then
        1
    else
        0
    end;
let itemsrejectedCheck := if 'ITEMS REJECTED' = null then
        1
    else
        0
    end;
let fieldCheck := [dateCheck, productsCheck, shopsCheck, employeesCheck, preparedwhereCheck, startCheck, endCheck, breakstartCheck, breakendCheck, break2startCheck, break2endCheck, break3startCheck, break3endCheck, kgpreparedCheck, itemspreparedCheck, itemsrejectedCheck];
if sum(fieldCheck) = 0 then
    let newRec := (create 'HANGING PRODUCTION');
    newRec.(
        DATE := t.Date;
        PRODUCT := t.PRODUCT;
        SHOP := t.SHOP;
        NAME := t.NAME;
        'PREPARED WHERE' := t.PREPARED;
        START := t.START;
        END := t.END;
        'BREAK START' := t.'BREAK START';
        'BREAK END' := t.'BREAK END';
        'BREAK 2 START' := t.'BREAK 2 START';
        'BREAK 2 END' := t.'BREAK 2 END';
        'BREAK 3 START' := t.'BREAK 3 START';
        'BREAK 3 END' := t.'BREAK 3 END';
        'KG PREPARED' := t.'KG PREPARED';
        'ITEMS PREPARED' := t.'ITEMS PREPARED';
        'ITEMS REJECTED' := t.'ITEMS REJECTED'
    );
    alert("New Record Added")
else
    alert("Please fill in the following fields:" +
    if item(fieldCheck, 0) = 1 then
        xlf + "DATE"
    end +
    " " +
    if item(fieldCheck, 1) = 1 then
        xlf + "PRODUCTS"
    end +
    " " +
    if item(fieldCheck, 2) = 1 then
        xlf + "SHOPS"
    end +
    "" +
    if item(fieldCheck, 3) = 1 then
        xlf + "NAME"
    end +
    "" +
    if item(fieldCheck, 4) = 1 then
        xlf + "PREPARED"
    end +
    "" +
    if item(fieldCheck, 5) = 1 then
        xlf + "START"
    end +
    "" +
    if item(fieldCheck, 6) = 1 then
        xlf + "END"
    end +
    "" +
    if item(fieldCheck, 7) = 1 then
        xlf + "BREAK START"
    end +
    "" +
    if item(fieldCheck, 8) = 1 then
        xlf + "BREAK END"
    end +
    "" +
    if item(fieldCheck, 9) = 1 then
        xlf + "BREAK 2 START"
    end +
    "" +
    if item(fieldCheck, 10) = 1 then
        xlf + "BREAK 2 END"
    end +
    "" +
    if item(fieldCheck, 11) = 1 then
        xlf + "BREAK 3 START"
    end +
    "" +
    if item(fieldCheck, 12) = 1 then
        xlf + "BREAK 3 END"
    end +
    "" +
    if item(fieldCheck, 13) = 1 then
        xlf + "KG PREPARED"
    end +
    "" +
    if item(fieldCheck, 14) = 1 then
        xlf + "ITEMS PREPARED"
    end +
    "" +
    if item(fieldCheck, 15) = 1 then
        xlf + "ITEMS REJECTED"
    end +
    "

    ")
end

    Date := null;
    PRODUCT := 0;
    SHOP := 0;
    NAME := 0;
    PREPARED := null;
    START := null;
    END := null;
    'BREAK START' := null;
    'BREAK END' := null;
    'BREAK 2 START' := null;
    'BREAK 2 END' := null;
    'BREAK 3 START' := null;
    'BREAK 3 END' := null;
    'KG PREPARED' := null;
    'ITEMS PREPARED' := null;
    'ITEMS REJECTED' := null;

end