Populate Form Fields from values in another report?
I need to create a form that takes attendance at a staff meeting. I have all the staff listed in a report called "Active_Members" (which is just the records from a form called "Member_Entry" with a status of "Active". I need to have a form that lists all the members so that the secretary can call the list of names from top to bottom, and mark whether each is "present, absent, or excused" I'm trying and can't figure out how to do this.
Delete uploaded files
1. The form at https://creator.zohopublic.com/registrocivil/registro-de-nacimiento-doble-ciudadania/form-perma/Envio_de_Documentos_inicial/UbUsnYy7X5gyZhpJCjjt9hkAj01Y0AtV1kAM9kGsjJ3hBBQtRgVvsZQQsd2qjFrTZvOeMPNh5kFpNV7BqHbsjpNG29DQAqRehUYY is uploading files. How can I erase some of those uploaded files ? Thank you.
Count records which have had a subform record added this week / month / year
Tried to post before but it never appeared in forums - just said waiting approval but I can't find anywhere!! Anyway straight to the point.. I have 2 forms of interest (Company, Call_logs) Call_logs is a subform within Company I also have a page (Monthly_Report) in this page, I want the following date to return the number of Companies that have been called this week / month / year Company A = 5 Call_logs Company B = 2 Call_logs Company C = 7 Call_logs Company D = 1 Call_logs Ie 4 companies called
Zoho creator old version
how can i go back to old interface on Zoho Creator?
API Integration
I'm trying to create an app to record our press mentions. I have created a form which creates a record for each mention, with one of the fields being a URL. In the report section, I want to show the number of times each URL has been shared on social channels using API (ex: http://graph.facebook.com/?ids=https://www.marketingtechnews.net/news/2017/may/31/how-drive-media-buying-roi-through-integrated-platform/) How can I get help doing this?
How to Make Pre-Filled Form to build an attendance register
Trying to build an attendance register for small manufacturing company - can be used for schools, hospitals etc. Up to about 30 names can be displayed on the same page, The default radio button is set to Present - most people come to work most days. The manager, supervisor, teacher explicitly chooses absent. I tried to do this with look up field in the form but could not succeed. This is a best approximation of how people work today. then ensuing reports can calculate attendance, pay, leave records
Catching failed lookups from zoho.crm.getRecordById
I’m using Zoho Creator to pull record information from Zoho CRM, using the method zoho.crm.getRecordById, as such: potential = zoho.crm.getRecordById("Potentials", My_Zoho_CRM_ID);
When My_Zoho_CRM_ID is an ID that exists in the CRM, everything works fine. However, when My_Zoho_CRM_ID does not exist in the CRM, I’m given the following error: Error in executing Set Variable task. Unable to update template variable potential.
Error evaluating MAP expression :
Is there any way to catch this
Deluge Name Panel Disappeared
During Free Scripting we used to have a Deluge Name Panel on the right hand side, its super handy, however its disappeared since last week, wonder how to get it back?? Thanks!
Help for making my aplication please
Hello, first of all i am a new user of Soho Creator. And please sorry if it is not the right place for doing this question. I need some help for making an aplication for our organization. Well, my question is, that while we have a "form" where we charge our campaigns, each campaigns maybe have more than one work in it, so we have a "subform" in it, where we can just press "add" buttton of the subform and add every work in it, in each work charged in this Subform, we select the Personal who
Reg - Calendar report
Hi, Good day to you! I want to know how to make the availability of office timings alone ( say 10 AM to 6 PM ) in zoho creator calendar report. Its shows time from 12 am to 11 pm in day view. Thanks, ITKES
Convert IDs returned in a list to the names they're associated with
Hi there, I have a multi line field on a statless form that I want to populate with a list of names fetched from a set of records meeting a certain criteria. There are 3 forms connected to this process: Client_Info (this just holds the basic client info like First Name, Last Name, Client ID, email, phone no. etc.) Courses_Setup (this holds a uniques record for each course that has been setup, with fields for course title, room it's held in, strat and end dates, teacher etc. Class_Bookings (this holds
Can we call Zoho Migration tool through deluge script or can we extract data from Excel or CSV
Is there any possibility to extract data from excel file and from pdf we need urgent response . Thanks.
update record instead of create new
Hi guys, firstly I am new to this zoho, trying to remeber my ms access days, i hope you can help :) Where I'm up to, so far: 2 forms - form 1 : Customer Details, Name, Address etc - form 2 : Drop down - which displaying customer name and a Rich text format box What's happening at the moment is: Access form 2 - select Customer by name (drop down) - enter text into the Rich Text box - Submit this creates a new record every time: What I'd like to
Gettype function
I wonder if anyone can help me, please.... I have 2 applications:- Application1 contains Form1 with fields Name1, date1 Form 2 with fields Name2 (the data in this field is copied across from Name1 in Form1), Number1 Application2 contains Form1 with the following fields:- Name3 - A Lookup field - the relationship is to Name1 in Form1 in Application 1 Date2 Number2 When someone goes intro Application2 and looks up the name in Name3 field - I use the gettype function to find the associated record in
Importing records from excel not working correctly with Spanish characters
Hi, Spanish characters are not imported correctly from excel spreadsheet. The special characters are ñ, á, é, í, ó, ú. Does somebody know a workaround?
Reverting to null value doesn't seem to work on Inserting multiple Records
In one form, on Validate or Success, I'm creating doing multiple "Insert Records" based on the report of another form. It took me all day to find the cause of my bug, but I have discovered that once I have a non-null value in one of the Insert Record fields, I cannot pass pass another null value. It will stay with the previous value. It doesn't matter if I try to pass this in the form of a string, integer, or from a list. I would have something like this in my On Validate Game = GameSetup_Log[ID
prompting a user for input with a modal popup dialog
In developing interactive applications it is useful to be able to display a modal dialog box that presents a message and a couple choices (buttons or links). Based on the user's selection, you branch and do something in the application. I'd like to implement a generic function to handle this. I would pass it the message string to be displayed and the text for up to three option buttons; it would return a simple integer indicating which button was clicked. As a less attractive alternative I'd be okay
Report edit menu button
Hi there, I've added a simple custom action to a report (it just launches a stateless form) but I'm having problems getting it to show in the 'Show action in each row under menu edit' display type. When I choose the 'Show action for each record' it works fine - the button appears at the end of each row and it functions correctly. However, if I choose the 'Show action in each row under menu edit' nothing appears on the report - the default edit icon remains unchanged. Am I missing something here?
Only posssible to see 65 records in a report, from a total of 259 records.
I ‘m experiencing now a problem when scrolling down to view all records in a report: I can only see part of then. I have 259 records and can only see 65. Before there was no problem. How can we solve this issue? Thanks
Making an order app. Having some issues.
This is my first time with zoho so i am not very skilled at this. I am stuck and need help finishing my app. First let me explain what i am trying to make then I will explain where i am stuck. I am making an order app. Basically all i need is a app that adds products to an form and then make some designed forms after. I am trying to stop myself from creating two separate excel spreadsheets with the same info. I have attached the sheets. So you can see what I want to produce. So I have a vendor form
Is Zoho Creator hard to do problems a little outside the box?
I haven't programmed in a good long while and on my second week of the free trial, so maybe this is me and being a noob to this system... but I'm finding the documentation a little light (did all the videos, ebooks, and tutorials) and so have to do a lot of experimenting to see how it works. Right now I got a team roster based on one form, and in another form I multiselect teammembers for a single game match. I'm trying something as simple as getting the inverse of my selection (gettting a list
Reverse Zoho Invoice Solution
Hi, We are looking for a possible solution to our Instructor Invoicing problems. At the moment our system is clunky inefficient and very time consuming. At the end of each month our instructors send their collated classes (Invoice) they have taught to a designated email address. These invoices are then checked by admin to make sure they are correct. They are then approved and sent to the accounts team to Pay (by bank transfer). This process often leads to invoices being missed, not check thoroughly
Need help Debugging - Info - View Log Details?
https://www.zoho.com/creator/help/script/info.html This talks about a "View Log Details", unfortunately the only error log I can find is the script log errors. I don't see it in applications or behind the scenes. Been using info keyword but can't find it's output.
Send personalized email signature for each user
I would like to know if it is possible to add an HTML signature when sending emails. Where the signature changes according to the account from which the mail has been sent. If it can not be an HTML signature a signature image could be sufficient, but it is important that it be automatic for each account .. Is that possible? I have not found information on the subject.
Reg - iCal in reports in newer versions
Hi, I want to know where is the iCal Feed option in the views/reports. The example which is shown in zoho creator help is for older version. For newer version I couldn't see any option for iCal .. Please let me know in creator where can i find the iCal option. Regards, ITKES
Reg - background image for published form
Hi, Good day to you! Can I have a background image for published form? if not please let me know what can be done for the below query. I want to share the form in public with my favourite image as a background. Background color is not enough. Thanks, ITKES
Failing validation of commas on decimal fields
Hi, There's a huge problem with decimal fields and commas. Commas are not recognized as illegal characters, but are simply deleted in the decimal field. This is ridiculously problematic and should be fixed asap! We cannot have any kind of confidence in the data collected by Zoho. Here's a screenshot of a simple alert box script on input. As you can see, the input contain a comma, but it is not converted to a decimal point. I have honestly never seen anything like that. Please make commas illegal
Excel format for questionnaires
I'm going to use Zoho Creator for questionnaires and would like to know: 1. Is it possible to import an excel for a questionnaire? 2. What is the format of the excel sheet needed? 3. Can I add filters or rules to questions so one is disabled -or not- depending on the answer of a previous one? If so How? Cheers, Tania
Lookup field with a FILTER and SORT not sorting correctly
Old program, no changes on my end. I have two lookup fields. First one for Category the second Product. Select Category. The second field Product has a FILTER from the Category field. The list shows up but the items are not sorted correctly. How do I get the items sorted like they use to show up? Do I have to manually sort the list now?
How to create report of multiple form which are not linked by lookup -
Hi, I have a form - which in turn has a subform. They are not linked by lookup. It has a 1 to many relationship. I need to form a report with data from main form and subform. Only problem is that the multiple rows of the subform data comes together in one cell/row. I need to have them in seperate rows For Eg Main Form Subform A A - 1 A - 2 B B - 1 B-2 B-3 After looking at the advise given in other
Currency in zoho creator report
Team, Currency in the zoho creator report is showing in $ even if the currency on the form is different, is it possible (already) to change this?
Error in "Learning Deluge" ?
while taking trials under Learning Deluge, on List, I notice that four items: New List, Add, RemoveIndex, RemoveValue do not seem to work right. I do get outputs, but along with Error messages. See attached screen shots. Any clarifications?
How to edit (change information in an existing record) after opening a linked view?
When looking at a record in summary view, I am given the option to "Edit Print Delete". However, after clicking on the linked view (Project: KPTC Buildings ABCD) - there are no options to Edit or do anything else. Is there a way to edit this linked view directly? Can you please add a button to "Edit Print Delete" directly after opening the linked view? (See screenshots below.)
Can a report be generated and displayed [no edit] without a base Form?
I am trying to generate and display a free formatted worksheet like report [say Daybook] based on a set of records created using a Form [say invoices]. New fields [columns] will make up the report based on field-values collected from Invoices. How to do it?
Replicate data from one form to another based on drop-down selection
Hi I'm a beginner to ZOHO Creator (and programming) and trying to understand the method of populating fields in a form (fetched from another form) based on a selection in a drop-down box. Let's say I have 2 forms; - One"Golf_Bag" form with following information fields created; "Club", "Brand_of_club", "Model_of_club", "Loft_of_club". - Another "Input_data" form with corresponding fields, and where "Club" is defined as relation to the "Club" in the Golf_Bag form and is selected in a drop-down box,
Generate Record Summary in Pages
Hello to all I have a Question, i'm trying of developing in the part of zoho Creator "Pages", generate a Record Summary, my question is. How can is generate a Record Summary from pages of Zoho Creator. Example if ((formulario.ID_OPORTUNIDAD != null) && (formulario.ID_OPORTUNIDAD != "")) {%> <div elName='zc-component' <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/irojas/formulario-acta-de-entrega-vendedor-cliente/form-embed/Acta_de_Entrega_Vendedor_Cliente/VU9OXE27r0B8b1RNAHbptV3atDHpfOmkHOumnzrknJ5kTNwpfs6wBO35ARr7bGOTY8zmTPhMqADNm1SjOfu3gpAF4wKAxM137740'></iframe>
Under Maintenance Mode for Users
Hello, I am running an application which have 50-60 users. There are some effective changes I need to make on the app which requires people not to use the application until I am complete with the changes. In such situation I would like a click switch to Under Maintenance mode where users with certain profiles / roles as defined by me will have access to the application and others would only see an Under Maintenance alert page and cannot access forms or reports. Please let me know if this can be provided.
More than one copy of the same subform in a form - data from subform copies not added to report
Hi Zoho, I have a form and I'd like to use a subform in it. Among other fields, the subform has a "type" field with 3 options. I'd like to have 3 copies of the same subform inside the form, one for each option - so all entries will be joined in one report (also for ease of use so I won't have to create 3 copies of nearly the same form). How can I do this? Trying to simply add copies looked ok at start but viewing the report the entries from the 2nd and 3rd copies were not added (the form was submitted
Problem in Lookup field in Sub Form
Hi i am having a Sub Form in a main form. The Lookup Field in Sub Form is baased on a value from the main form.SO while adding i dont have any issues the Lookup field works good But if i try to edit that drop down field its showing all values in the LookUp rather than the fiterd value Seeking a solution for that. Code for Subform On Add Row if (row.Order_No == null) { ord = (Order_Management[((Client_Name == input.Client_Name && Rate_Id == input.Rate_Id) && Order_Status == "Active")].ID).getall();
Creating a good looking form in the form creator
Hi Everyone, How would I make a form that looks like this form including custom placement of fields, buttons etc. and also tab controls just like the form I'm writing this posting in the form creator? I'm assuming it's also made with the form creator. Currently the form creator will only create very crude and basic looking forms that stretch across the entire web page. Truly, Emad
Next Page