Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 05/21/2021 in all areas

  1. Well, I don't think there are too many options here. At least I cannot think of any except: the field does contain a word starting with "Y"'; the index is corrupt; the file is corrupt.
    1 point
  2. See if the attached demo helps. CondVLx3.fmp12
    1 point
  3. I don't think so. You show a relationship matching on codigopostal. You need a relationship matching on codigopostal AND ext_codigopostal. And if you want to have two conditional value lists, you will need two relationships, using two occurrences of codigo_postal table.
    1 point
  4. If you want to have a value list filtered by both Code and Prefix, then you need to also have a relationship that matches on both Code and Prefix.
    1 point
  5. If you only want to group the records by shift, you could calculate some value that will be common to all records within the same shift - a sort of an "absolute shift number", if you like: Div ( CompletedJobTimestamp - Time ( 6 ; 30 ; 0 ) ; Time ( 8 ; 0 ; 0 ) ) If you also need a label, you can calculate it from the above using: Choose ( Mod ( cShiftNum ; 3 ) ; "Early" ; "Evening" ; "Late" ) Similarly, the start date of the shift can be calculated as: Div ( cShiftNum ; 3 ) + 1 Note that this calculation assumes that a shift starts exactly at a round half-hour - i.e. a record with timestamp ending in 06:30:00 is allocated to the Early shift, while 06:29:59.999 is counted in the Late shift.
    1 point
  6. Well, if you define a calculation field in the Customers table as = Let ( totals = List ( Orders::TotalAmount ) ; GetValue ( totals ; Get ( CalculationRepetitionNumber ) ) ) and set it to have 10 repetitions, you should get what you described.
    1 point
  7. I think you want to do something like: Case ( Checkbox 2 = "EXPELLED" ; "" ; Self ) or perhaps more simply: Case ( Checkbox 2 ≠ "EXPELLED" ; Self ) However, this assumes that the Checkbox 2 field can either contain the text "EXPELLED" or be empty. Usually, a checkbox field can contain several values, and if you want to test for the presence of "EXPELLED" among other possible values, your test will fail. OTOH, if you're using the field as a Boolean (on/off) type, then it would be much more convenient to use the numeric value of 1 instead of the "EXPELLED" text value.
    1 point
  8. First we append another CR to the result of UniqueValues(), so we get: "Record One¶Record Two¶Record Three¶¶" Now we substitute (1) a pair of CRs with nothing: "Record One¶Record Two¶Record Three" and (2) a CR with comma and space: "Record One, Record Two, Record Three"
    1 point
  9. If you need to use keycloak in a Joyent SmartOS zone I wrote down my own notes on gist: https://gist.github.com/TyrfingMjolnir/d99226078f76cd4760114ff223fbc702 I use Joyent SmartOS for virtualizing unix, linux, BSD, and others. A Joyent SmartOS zone is very similar in use case to docker.
    1 point
  10. That is correct. There is a way to find the record, using either a find or a relationship. But then it would no longer be within your current found set. Or perhaps it would, if you used GTRR without 'Show only related records'? I am not sure I would trust that. I should add that with a found set of only 4 (or even many more) records, a loop would accomplish this task instantaneously. And, as you correctly surmised, a field is not required for this. But, as I said, I think you have better options.
    1 point
  11. Let ( lastComma = Position ( text ; "," ; Length ( text ) ; - 1 ) ; If ( lastComma ; Replace ( text ; lastComma ; 1 ; " and" ) ; text ) )
    1 point
This leaderboard is set to Los Angeles/GMT-07:00
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.