0

Choice field repeat the value of the previous day

There is a Choice field where there are several options. When creating a new record, i need the value of this Choice field to transfer to the next day. Please advise the formula

20 replies

null
    • Fred
    • 1 yr agoSat, September 2, 2023 at 8:13 PM UTC
    • Reported - view

    Just add the name of the field and make it equal to the same name field:

    let t := this;
let newRec := (create Table2);
newRec.(
    MultiChoice := t.MultiChoice;
    Country := t.Country
)

    MultiChoice is a simple multiple choice field.

    Country is a dynamic choice field.

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSat, September 2, 2023 at 11:37 PM UTC
      • Reported - view

       Hi
      I have a dynamic Choice with name "Category", and the table name is "dili Result". i create formula 
       

      let t := this;
let newRec := (create 'Daily Result');
newRec.(
Category:= t.Category;
)

      and registered it in the table settings - trigger on new Record. Didn't work 

      • Fred
      • 1 yr agoSat, September 2, 2023 at 11:46 PM UTC
      • Reported - view

      You didn't say it was in a trigger on new Record. 🙂

      You will have to put this in a button to create the new record and copy the data. The Trigger doesn't have a reference point for "this" so it can't copy anything.

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 12:20 AM UTC
      • Reported - view

       I forgot to say about this, sorry)
      I created a button outside the table to create a new record and then in the table,  but it didn’t work.

      I'm probably doing something wrong?

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 12:24 AM UTC
      • Reported - view

       I have a formula field in another table

      let c := number(Id);
let bc := last((select 'CASH DESK' where number(Id) < c) order by number(Id));
first(select 'CASH DESK' where Id = bc).'CLOSE 1'

      when I create a new day, it itself takes information from the required field, from the previous entry. I was thinking of doing something like this

    • Fred
    • 1 yr agoSun, September 3, 2023 at 12:33 AM UTC
    • Reported - view
     said:
    I created a button outside the table to create a new record and then in the table,  but it didn’t work.

     Create the button in the table that has the Category field, which I guess is Daily Result?

    Try not to do too many select statements in Ninox:

    let c := number(Id);
let bc := last((select 'CASH DESK' where number(Id) < c) order by number(Id));
first(select 'CASH DESK' where Id = bc).'CLOSE 1'

    You have a select statement in lines 2 and 3.

    From my reading of it you don't need the line 3 select since you are referring to the record you found in line 2. So you can rewrite line 3:

    let c := number(Id);
let bc := last((select 'CASH DESK' where number(Id) < c) order by number(Id));
bc.'CLOSE 1'
      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 11:21 AM UTC
      • Reported - view

       Hi

      there is a table "Daily result" with Choice Field  "Category"

      Recordin in this table created with this button 

      I need the record to be clean, it just needs to go through the value of the Choice  field

      This is so that you can track changes in client category, without going into the table.

    • Fred
    • 1 yr agoSun, September 3, 2023 at 3:20 PM UTC
    • Reported - view

    This is so that you can track changes in client category, without going into the table.

    Well then you just need to figure out which record you need to pull the data from. If you order 'Daily Result' by Date, do you need the last record? If so then you can change the code to:

    let t := last('Daily Result' order by Date);
let newRec := (create 'Daily Result');
newRec.(
Category:= t.Category;
)

    this would go in a button at the parent table of Daily Result.

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 6:32 PM UTC
      • Reported - view

       Thank you very much for your time, I'm really sorry but it's not working

      I need a formula for the button, "Create New Record", when pressed, a new record should be created in table "Daily Result", where only one field  "category", takes the value of the previous Day

      • Fred
      • 1 yr agoSun, September 3, 2023 at 7:01 PM UTC
      • Reported - view

      can you upload a sample DB?

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 10:02 PM UTC
      • Reported - view

       

       said:
      I need a formula for the button, "Create New Record", when pressed, a new record should be created in table "Daily Result", where only one field  "category", takes the value of the previous Day
      Test.ninox
      • Fred
      • 1 yr agoSun, September 3, 2023 at 10:05 PM UTC
      • Reported - view

      did you see my recent post about adding the linking to the parent record?

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 10:30 PM UTC
      • Reported - view

      Fred I saw it, but didn’t understand how to do it ) Parent Record - what should I write there?

    • Fred
    • 1 yr agoSun, September 3, 2023 at 9:05 PM UTC
    • Reported - view

    I forgot to add the part of linking it to the parent record.

    let t := this;
let oldData := last('Daily Result' order by Date);
let newRec := (create 'Daily Result');
newRec.(
ParentRecordFieldName := t;
Category:= oldData.Category;
)

    If you look at the Daily Result table you will see the new records there just not linked to the parent record.

    • Fred
    • 1 yr agoSun, September 3, 2023 at 10:33 PM UTC
    • Reported - view
     said:
    Fred I saw it, but didn’t understand how to do it ) Parent Record - what should I write there?

     You show a screenshot of a record that has the 'Daily Result' table in it. In the 'Daily Result' table there is a reference field name that points to this table put name of the reference field in Daily Result.

      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 10:39 PM UTC
      • Reported - view

      Fred 

      let t := this;
      let oldData := last('Daily Result' order by Date);
      let newRec := (create 'Daily Result');
      newRec.(
          Category := t;
          Category := oldData.Category
      )

      name of this Field is CATEGORY the name of the field, Choice Field, that should appear to be called that way

      • Fred
      • 1 yr agoSun, September 3, 2023 at 10:45 PM UTC
      • Reported - view

      iliper LTDForget for a second the category field, You want to also link the parent record to the new Daily Result record as well. If you look in the Daily Result table you will see the new records you have created they are just not linked to any records in the parent table.

      You sent me a sample DB, is the parent table Cashier? In the Daily Result table there is probably a reference field called Cashier. You might have renamed it. That is the name you put in place of ParentRecordFieldName.

      let t := this;
let oldData := last('Daly result' order by Date);
let newRec := (create 'Daly result');
newRec.(
    Cashhier := t;
    Category := oldData.Category
)
      • iliper LTD
      • iliper_LTD
      • 1 yr agoSun, September 3, 2023 at 10:59 PM UTC
      • Reported - view

       this is how they are connected

      • Fred
      • 1 yr agoSun, September 3, 2023 at 11:10 PM UTC
      • Reported - view

       

      let t := this;
let oldData := last('Daly result' order by Date);
let newRec := (create 'Daly result');
newRec.(
    'LIST OF PLAYERS' := t;
    Category := oldData.Category
)

      The button is in List of Players.

      • iliper LTD
      • iliper_LTD
      • 1 yr agoMon, September 4, 2023 at 12:29 AM UTC
      • Reported - view

      Works great, Thanks  

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 1 yr agoMon, September 4, 2023 at 12:29 AM UTCLast active
  • 20Replies
  • 87Views
  • 2 Following