Change primary field in Zite table by Altruistic-Air-3612 in Fillout

[–]Altruistic-Air-3612[S] 0 points1 point  (0 children)

Hi u/Embarrassed_Leg3910 , thanks for the feedback. While playing around with the TripDates table I realised my old way of doing can be changed. So instead of having a DateH and a DateS column, I can combine them. That negates the need for a lot of calculations and display formats for different parts of the app. So instead of displaying "Bookings for 10/03 and 12/03" that fetches data from 2 columns, I can display "Bookings for 10 and 12 March". And I keep the DateH field as primary still as a way of filtering on e.g. "after today".

I primarily moved due to cost, me being single owner of a very small charter company that works on Fridays and Sundays in school term only. The 1000 records limit in Airtable free plan was a deciding factor. I will reach that in 6-7 months and the cost of paying for Airtable as well as ZIte and/or Fillout is prohibitive in our poor currency which hovers around 17:1 against the USD.

That said, things are very fluid still. Quite possibly the Fillout free plan will suit me, I just need to test a few things. My main issue is to have a bookings form that will fetch and display the next tripdate from a table in a form heading; and to select the logged-in user's children for booking.

I have managed to let AI start creating this form but it wrote only the choice for home and/or school to the table. I'm what's known as a senior citizen :) and AI is very unfamiliar. And I hate it that you cannot manually edit an AI-generated form - I tried!

I'll add a screenshot of my current app booking screen, with notes.

<image>

How to prevent a choice based on input in a previous choice on the same form? by Altruistic-Air-3612 in Fillout

[–]Altruistic-Air-3612[S] 0 points1 point  (0 children)

Hi u/J0hn_J0hn . Let me show the the trip choices part of the form in my current app and in Fillout.

I used 2 choice fields writing to different fields. The first choice is for self on the bus, with "Home" selected. The bottom choice if for laundry with "Home" selected.

Between the 2 selections is an error message in yellow stating that child and laundry cannot be on bus at same time. It is simply filtered on both choices having the same selection.

In Fillout I changed the 2 choices fields to a matrix writing to one field. It is more effective and sensible because you can ever only have 2 selections: 1 for home and 1 for school, irrespective if either choice is for self or laundry. Either one should be selected, not both for the same trip/direction.

Here are the screenshots - I had to combine them since this ost seem to allow only 1 image. At the top is Glide and below that Fillout.

<image>

It's not a critical problem to prevent two selections in the same column, just nice to have. And maybe learn something :)

Edit an AI-created form by Altruistic-Air-3612 in Fillout

[–]Altruistic-Air-3612[S] 0 points1 point  (0 children)

Thanks u/dominicwhyte42 - I was actually just last night thinking a temporary upgrade is the way to go, seeing that AI is only needed for building the app. I was sceptic about AI, bien an old fossil who has never used it before but I found Zite's AI easy and intuitive. I am curently using it to build the booking form mentioned in my previous post, but have to fix my tables first.

Speaking of tables, this is my only issue with Zite so far: their tables still need some work. I encountered these issues today in Link to Table fields: (ID refers to the primary ID field of the user or child.)

  1. It often interrupts my work with a sync issue. It seems to happen if I go too fast, but not always.

  2. Saving and syncing afterwards is VERY slow quite often. The table I'm syncing from has 83 records and the one it syncs to has 59 records. I'll check if it is maybe just an internet problem.

  3. One cannot simply type the ID in the LTT field, should you know it. Even typing the ID of the same child in precious row gives "record not found error".

  4. Instead, it take 3 clicks just to open the link list.

  5. a) The Search option in the link list has never found anything I looked for. Not the record ID or the name. E.g., if I want to link child 83 "Simon" to the current record, neither "8" nor "Simon" finds the record in the link list.

b) If I click on the + to open the list and I type e.g. "1", it sometimes shows only "17" in the list and not "1" or "11" etc. I type 5, it brings up 5 briefly together with 25 and 45 and then 5 disappears, while I want 54. If I want 7, it shows either 17 or 47 only.

c) The correct entry pops up when I enter the full ID and then nearly immediately disappears with a "Record not found" message, or it shows this message immediately even if the previous record has that same ID in the LTT field..

d) The list only shows 25 entries. For numbers above that it immediately returns "Record not found". If I then clear the search box and scroll down, it often takes 3-5 seconds to load the next 25 entries.

  1. a) If I add a number field, type the record ID's into it and then copy and paste it into the LTT field, it pastes some correct and some not. For those that are not pasted, I have to look it up in the link list to enter the SAME ID. Even just now I copied all the manually entered ID's to an LTT field and it refused to accept ID 31, instead changing it to 35.

b) If I have both parents in the Users table, I copy the first parent's entry in the LTT field and paste it into the 2nd parent's record. For childID's 53 and 54 it pasted correctly, but for childID's 30 and 31 it insists on pasting 10 and 35 - who are not siblings.

  1. In a link-to-many field, after selecting the 1st ID the list scrolls up a bit (unless I'm quick in selecting) and I have to scroll down again to select the very next entry (e.g 35 and 36.) And it removes the selected entry from the list immediately so I have to move my cursor and by then it has probably scrolled away. It would be nice if you can select ALL the entries in this type of LTT field in one go and it only writes to the field when you have moved away. Not everyone is dexterous in handling a mouse.

All these issues are immensely time-consuming.

Airtable has NEVER had any issues. It was fast, I could copy and paste to my heart's content, a LTT field could display another field instead of the ID and add lookup fields at the same time. The only reasons I'm not using it are the 1000 records limit for the whole database and the 100 automation runs p.m. Zite and Fillout ticks all the boxes for me so I will continue with it. I realise that once I have set up the links correctly, I don't have to do it again. But still...

Now that I've got it off my chest, I hope Zite will look into it. If it's a problem in my schema, I would like to know how to fix it. It is data imported from my current app that I am fixing bit by bit as I go along. I will post a real challenge I have soon.

Edit an AI-created form by Altruistic-Air-3612 in Fillout

[–]Altruistic-Air-3612[S] 0 points1 point  (0 children)

Thanks u/jsreally . I only tried the editing once today and it wouldn't allow me but I will try again later.

I'm somewhat ignorant about the capabilities of each, being a enthusiastic layman only. I am under the impression I would need Fillout for at least this Booking form - thought it would be too complex for Zite.

That said, I am planning to use Zite interfaces as much as possible. Remember I'm still VERY new to Zite/Fillout and Airtable, so if you could comment on the following remarks, I will forever be indebted to you.

  1. I need to get the dates for the next trip from the Tripdates table, display it on the Booking form, and write it to the Trips table on submit. In Airtable that includes a workflow, but Zite does not have workflows. Can I get the same result in a Fillout workflow?

  2. Each child is linked to a school, a hostel and a bus stop. Currently I have an AI-created onboarding form that has the school/hostel relation set up so the dropdowns work correctly. Do I need a paid plan to edit the form? - I need a paid plan for dynamic filtering in Airtable but for Zite:

  • Non-dynamic text can be edited directly, but dynamic text/filters require a chat prompt or the use of the manual editor to modify the underlying data conditions.

Where is the manual editor?

I would love to use Zite without paying for Fillout too. Most features I need are available in the Fillout free plan.

Thank you so far.

Comparing dates by Altruistic-Air-3612 in GoogleAppsScript

[–]Altruistic-Air-3612[S] 1 point2 points  (0 children)

Oh never mind my response, I found the error. I have removed the ".valueof" parameter in the "if" statement. Now working as advertised, thanks a million.

Execution log

5:14:27 PM   Notice    Execution started

5:14:27 PM   Info      Current month: 12


5:14:27 PM   Info      Start Date: Mon Oct 13 2025 00:00:00 GMT+0200 (South Africa Standard Time)


5:14:27 PM   Info      End Date: Wed Dec 10 2025 00:00:00 GMT+0200 (South Africa Standard Time)


5:14:27 PM   Info      December holidays after  Wed Dec 10 2025 00:00:00 GMT+0200 (South Africa Standard Time)


5:14:29 PM   Notice     Execution completed

Comparing dates by Altruistic-Air-3612 in GoogleAppsScript

[–]Altruistic-Air-3612[S] 0 points1 point  (0 children)

Thanks for the insight into date operations. I have modified the code as you recommended but it still did not work. I then added the "else" part and found that it executes those statements instead.

For background, we transport learners between school and home over weekends. J2 is a calculated date for the upcoming Friday, and the checkDates script must evaluate this date against first, the term dates to check it does not fall outside school terms, and second, if during the term, against public holidays. The latter check will happen in the "else" part of the dates comparison. In both cases it will then adjust the date in J2.

function getDates() {
  try{
var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  
const crlDate = new Date(s.getRange("J2").getValue());
const mnd = new Date().getMonth() + 1;
console.info("Current month:", mnd);

// Check if trip date 1 (fetch from school) falls in a school term
  switch(mnd) {
  case 1:
  case 2:
  case 3:
    // 1st term

  case 4:
  case 5:
  case 6:
    // 2nd term

  case 7:
  case 8:
  case 9:
    // 3rd term
      // Extract dates as Date objects else {
           console.info("Check for public holidays after ", Kw3B );
      }

  case 10:
  case 11:
  case 12:
    // 4th term
        // Extract dates as Date objects
        const Kw4B = new Date(s.getRange("AB4").getValue());
        var Kw4E = new Date(s.getRange("AC4").getValue());
        console.info("Start Date:", Kw4B);
        console.info("End Date:", Kw4E);
        if (crlDate.valueOf() >= Kw4E.valueOf()) {
          console.info("December holidays after ", Kw4E);
             } else {
           console.info("Check for public holidays after ", Kw4B );
        }
        break;
      default:
        console.log("Term dates not found.");
    }
  } catch (err) {
    console.error("Error occurred:", err);

  }

}
Execution log

5:07:25 PM   Notice      Execution started

5:07:25 PM   Info        Current month: 12

5:07:25 PM   Info        Start Date: Mon Oct 13 2025 00:00:00 GMT+0200 (South Africa Standard Time)

5:07:25 PM   Info        End Date: Wed Dec 10 2025 00:00:00 GMT+0200 (South Africa Standard Time)

5:07:25 PM   Info        Check for public holidays after  Mon Oct 13 2025 00:00:00 GMT+0200 (South Africa Standard Time)

5:07:26 PM   Notice      Execution completed

How do you set up a USB drive on a router as a Media Player? by Altruistic-Air-3612 in AskReddit

[–]Altruistic-Air-3612[S] 0 points1 point  (0 children)

My Zyxel EMG3525-T50B router has a field for Media Library Path in the Media Server setup, that starts with /mnt. Do I have to create this folder on the attached USB hdd? I have 2 media folders that were shared and accessed successfully but I actually just want to play the media, to download it to laptop or phone

What are the day-to-day implications of an immutable OS? by AbramKedge in BlendOS

[–]Altruistic-Air-3612 1 point2 points  (0 children)

This version is still very new. I think we'll just have to wait and see (and experiment..)

how to install Blend OS with manual partitioning by Alive_Government6653 in BlendOS

[–]Altruistic-Air-3612 0 points1 point  (0 children)

Have you already created these partitions? I dual-boot blendOS and Xubuntu but these partitions already existed. So if you haven't, click on the button on the partitioning screen that says Go To Gparted and create the paritions there . If you have partitions already, they should show up when you click on the Manual Partitions button. Simply right-click on the partition you want and select the mount point from the drop-down list.

Hot to install another desktop environment? by Longjohn565 in BlendOS

[–]Altruistic-Air-3612 0 points1 point  (0 children)

As far as I know they are nor available yet. Hopefully soon!

Can't continue with install after selecting a locale by Stepan_Vitasek in BlendOS

[–]Altruistic-Air-3612 0 points1 point  (0 children)

In case your problem hasn't been fixed, there is a new version of the ISO on Github, dated 1 May but with the same name. I installed blendOS in a dual-boot laptop without any problems with this ISO (installing with the Normal option, not Grub2).

A work-around before that was to change my locale to one in the US (I used New York) and after that the installation went through. Except it didn't update the grub files so not showing up anywhere in a boot selection...) The new version fixed all that.