Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 02/06/2021 in all areas

  1. Hi @kpcollier, Caspio does not have any standard feature for a time picker, but you may check this How-to article for customization. You can also check this URL as a sample. You can also use this code: <input id="time" type="time">, by inserting it to a HTML block and disabling the HTML editor. Below will be the final output.
    1 point
  2. I believe Caspio does not have Time only DataType, you have to use DateTime, can't you just use formatting and display time instead? The values in my table
    1 point
  3. Hi @BirdsInTheSky, You may display checkbox on the left with the following workaround. Copy and paste text for the checkbox label into the Display Text. Then, on the Advanced tab change the Label position to 'No label'. On the DataPage it will look like this: Hope this helps! Feel free to update this thread, maybe someone has another approach to this.
    1 point
  4. Thanks a lot for your replies kpcollier ! I'll check it out. Kind regards Johan
    1 point
  5. Cheryl

    Property Management App

    @kpcollieryou are so right - much smarter to do all the work on the front end. Thanks again for your quick response - I am so excited to be working within Caspio for this project.
    1 point
  6. kpcollier

    Property Management App

    @Cheryl I think you should give both of them a unique ID. I would have a units table and a building table. Make a 'Building ID' integer field in the Units table. In Relationships, connect the ID field of the Building table to the Integer field you created in the Unit table. Now each unit is assigned a building, and you don't have a big mess of either having a table with a mix of units and buildings and the rest of the fields nor a bunch of repeating 'unit' fields in your business table. This will make it easier to edit and update each individual unit. From there, you can make a Vie
    1 point
  7. @ParkLoey Thank you very much it works a treat!
    1 point
  8. NiceDuck

    Save history of the field

    This is how I did it by a triggered action. Note, with this workflow, you would be able to keep the previous value of a field, it will not save the value of newly inserted record. first, duplicate the table which you want to have a history record. go to its table design and change its ID field to a text 255 and rename it "parent_id" or any name you want. Your call, as long as it indicates that it is the records former ID. also, make sure that this field is not set to unique. Add an Id field and name it "History_Id" this will be the records actual ID on its current table. this is
    1 point
×
×
  • Create New...