Sharing data between Managers and Line Staff
Hello, I created a new inventory database with a Form with that has all of the fields that the Managers want to track. Now I need to give Line Staff access to some of the inventory fields and hide the rest. Do I create another form pointing to the master inventory Form? How can I achieve this? Iram
Create list of record IDs selected from a Lookup Multi-Select field
What field type would hold a list of the ID numbers of records selected from a Lookup Multi-Select field, and what does the script look like to create that list upon user input at that Lookup Multi-Select field? As always, I super appreciate the help offered here. Practically speaking, what I want to do is to reset records that were updated via the Multi-Select field when the form was first created, that in Edit mode have been de-selected.
QR Codes or bar codes integration to zoho....
Is it possible to integrate some sort of bar code scanning into a zoho create application? What I am thinking is using this website http://qrcode.kaywa.com/ to input a comma delimited record from zoho to create a QR code. That code could be printed and placed on a product. Someone would scan the code that is on the product with their phone and then email the record to zoho creator application. You can email records that get input into zoho creator application correct? What they would be emailing
update a row
I am new to zoho. i have been trying to learn about zoho since two weeks. currently i am working with zoho creator where i created an application(Employee Management). In the application i have a form where there are fields as follow: serial number as an auto number field Email as an Email field Date as Date field Is Entering or Leaving as radio field(options: Entering and Leaving) Arrival time as single line field Departure as single line field while accessing the application user has to enter fields
ZH Creator to ZH Invoice integration
New to ZOHO creator ... I'm using zoho.invoice.createinvoice () in ZOHO creator. All works fine in test and I can create an invoice in my own ZOHO Invoice account, however I need my application to create invoices in other ZOHO Invoice accounts. I can also do this using the appropriate ZOHO Invoice API, using AuthToken and API key, but don't necessarily want to do this. Is there any similar way that I can use zoho.invoice.createinvoice () to create an invoice in any (authorised, obviously!) ZH Invoice
How to update a list
Class_Numbers is a multiple-select variable There's no built-in function to actually add a new value to the list. for each student in Attendance [(Clock_Out is null)] { student.Class_Numbers = student.Class_Numbers.add(some_value); } Cheers, John Whitney
Count number of records that match criteria
I have a form where employees put in tickets when they break their devices, what i'm trying to accomplish is to make a label that shows on the form the amount of times that particular employeeID has broken a device (by counting the amount of records that exist with that employeeID) input.lbl_Broken_Count = Service_Ticket_Entry[Employee_ID == "input.Employee_ID"].count(); I read the count function and came up with the above code however when i try to save i'm given the below error: Variable 'lbl_Broken_Count'
Subform fields not calculating
Hello, I created a form called "Add Sale Subform" then I added a Lookup field to it so that I could add it as a Subform to a main form. In each of the fields in the Subform I added the below expression on User Input. input.Amount = (input.Qnty * input.Part + input.Labor - input.Discount); The updating works fine when I open the form separatly from the main form. But when I open the Main form where this subform is connected the subform fields don't update when modifying them. I tried changing
Disable fields based on logged in email address
Hello, I would like to add a formula to the On Load of a form to disable the below fields based on if their loginID equals any of the following hard coded email addresses: johndoe@yahoo.com, janedoe@hotmail.com, DaveJohn@outlook.com I will enter the real email addresses later. Serial_Number Model_Number Date_Received Could you help me with this script?
Formula field not adding up
Hello, I have a formula field field called "Total" withe following expression (Sub_Total + CC_Debit_Fee) Both of the above fields are currency fields, the Sub_Total is updated by fields in subform. But for some reason the formula field doesn't do anything when I enter information in the two fields. It just stays blank. What is wrong with the formula field? Iram
Look up Field in Form Not Filtering in Response to Critera
I have a Lookup field in a form that is not responding to changes in criteria. Regardless of what I put in as criteria the results remain unchanged as if I did nothing. You have access to my application named: PDmobile The form is: EvBroccoli Thanks for any help.
some lookup still return actual value rather than ID
Hi All, I still have two lookup fields that return actual value; all other lookup return ID. It gets confusing sometimes but not a problem. i'm just curious anyone know why?
Field On User Input trigger not executing
The on user input trigger for a field in a form that was working several months today no longer seems to work. When data is entered into the field (any field with an on user input trigger) the user interface shows the spinning icon showing that the back end is processing the trigger -- but the trigger never finishes. I have changed the figure to simple put text into another field on the form and I get the same result. Has anyone else had this problem? Any ideas how to even begin to debug this?
'row' is invalid collection error
I have a form and on this form I dragged in a subform from the buttons, then I added the below script to each of the subform fields that contribute to the Sub Total. All worked well. However then I decided that I needed the other type of subform where I have a linked field so I created a new form with the subform fields that I needed then added it to my main form with the linking. Then I added the below code to the Qnty field and clicked Save Script, and got the below error: Error at line number
Give ownership of app to someone else
Hello, I have developed an Zoho app for a friend in my account but now I want to transfer complete ownership to him. My buddy and I both have the $10 zoho creator paid subscription. How do I do this? Iram
Picking a specific value from a list in Deluge
We have used Creator to create a kind of CRM that links contacts (customers, in our case teachers) with interactions (in our case, usually some kind of field trip or outreach program). To facilitate this, we have a bidirectional relationship between 'Teachers in attendance' on the Interactions form, and 'Interactions' on the Contact form. It works pretty well, as this allows us to view all of the times a given teacher has worked with us over the years. However, as each related field from the interaction
SQL Server to Zoho Interface/Integration
I have a client with a mission-critical SQL Server-based application. The application is not going to migrate to a new platform for the foreseeable future. However, they do want to build a customer portal that would give customers access to order status information and also enable customers to enter orders. Naturally, of course, Zoho comes to mind for that customer portal. Our expectation is that the Zoho portal app would have its own database separate from the SQL Server system - and that the
custom interface button?
hi how can i make new button on creator interface and tune this button to make specific workflow for picked entries? example this button for picked workflow will be change each entry settings and save them
Backed up App but can't import
Hello, I recently backed up one of my apps then downloaded the .zip backup file. Then I logged into another Zoho Creator account and didn't know how to import the app and all its data in one fell swoop. Could you tell me how to do this?
Long function statements
This works: exchange_rate_map = exchange_rate_record.Rates.toMap(); return exchange_rate_map.get(input.Currency_Code).toDecimal(); This saves OK but fails at runtime: return exchange_rate_record.Rates.toMap().get(input.Currency_Code).toDecimal(); Any ideas?
How can I tell how my form and subform are related
Hello, I have a form. On this form I created a subform by dragging the subform button. Then if I remember correctly I used the blank subform. Then I created the fields manually in the subform. But now I would like to know how is the main form and subform related. What if I enter subform records in the wrong record and want to move the subform records to another record? If I new what the related field was and if it was visible I assume I could just change the related field in the subform and the record
301 response code when adding a record to a form in zoho creator
Hi guys, I updated a python script I use to add records to a form I have on zoho creator. I use the new url schema https://creator.zoho.com/api/<ownername>/<format>/<applicationName>/form/<formName>/record/add/ instead of the old one https://creator.zoho.com/api/<format>/<applicationName>/<formName>/add/ and it returns 301 as response code all the time. The authoken is valid and I removed the old field zc_ownername. Any ideas on how to fix it? Cheers
Saving Map Data
I have created a map variable for exchange rates accessed from a live web feed. How do I save a Map variable in a form?
New Built in String function(string.matches(<regular expression>))
We have introduced new string function matches for testing if the string matches a given regular expression. This function will be useful validating a given string for particular format. For ex, following code snippet can be used to validate a phone number string for the formats - (123)456-7890, 123-456-7890, 1234567890, (123)-456-789, (123) 456 7890, 123.456.7890, (123).456 7890 phone = "(123) 456 7890"; if(phone.matches("^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$") == false) { info "Please
email description, not record id
hi there is complex app number of service tables and one main app in main app there is some conditional lookups (for records from service tables) when using main app - user picks records all works good - in main app we can view picked records from service tables (names/descriptions) but when zoho via workflow sends email - in email there is not names/descriptions of picked records but unique id of that records how can i in sendmail send names/descriptions of picked records?
I am trying to use a list field in a formula field, and instead of the text from the list, I get a large number
I have 3 forms. In form 1, I enter a list of hospitals to be use in a Schedule form as a dropdown. In form 2 I enter a list of nurses to be used in a Schedule form as the person being scheduled. In the Schedule Form, I have a drop down, Facility, that is linked to the hospital list form; I also have a field Nurse Name that is linkd to the nurse list form. I then create a formula combining the text of Facility +" "+Nurse Name. Instead of the text I selected from the dropdowns, I get large intergers.
When you embed in HTML-page report from other app, you can't use Add or Edit buttons
HTML-Report: When you embed View from another zoho creator application with Form/Report (not IFrame) - you cant edit or add new elements in this View from this - you always get empty popup window with message: "There is no such form in Zoho Creator ". It's beacuse you use short links for add and edit like "#Form:form_name_from_another app" to get form in popup window, and it's not working from another application Do you plan to fix it?
Error Msg: "Wrong DataType specified. The Template Variable null should be of type LIST."
Hi Folks, I have recently edited a script that was working just fine and now I have hit a problem that I can't solve. I have several Multi-Select dropdown lists with data type stringlist. I wish to set this field to null. In my script, if I enter "input.Task_Fertiliser_Supplier = null;" then the script saves with no error. However, when my program runs, I get the following error message: Error details: - Error Executing the workflow On User Input scrip of Task Type. -- Wrong Data Type specified.
Scheduled task to update Invoice Payment Status in Creator
Hi Team I have ZC and ZI. ZC currently creates invoices in ZI and keeps a lot of the created invoice ID. I need to set up a scheduled task that runs through records where payment status = "Not Paid" and check each record in Invoice for any change in payment status. If paid it should update the Payment Status to Paid. I can do this for an individual record using GetInvoiceInfo() but how do I nest that inside a For Each function so that it runs through each record and checks/updates? I currently have
Totaling Subform
Hello, On a form I have a subform. In the subform I have fields such as Qnty, Price, Labor and Subtotal. I have set diluge to update the subtotal based on data changed in the other fields, all is good. But now I need a total field to add the Sub_Total fields in the Subform. How can I do this? Iram
Combining 2 strings, and converting to a Date / Time field?
I have an application where a user selects a report date, and then a starting time. I have a date field for the report date, and a drop down menu with 15 minute increments for the starting time. I am trying to combine these two fields, and then place them in a Date / Time field, but I can not get it formatted right. Here is the code I currently have. datetime_string = input.report_date + input.start_time_input; input.start_time = datetime_string.toTime("MM/dd/yyyy"); Which gives me the result
Dropdown list filter issue
Hi All, I feel I should be able to solve this but I'm getting nowhere :( I have dropdown lists of available resources. These resource tables use a lookup for the location of each resource. I want to only show resources available at the user's location in the master form. The master form also uses a lookup for the user's location. When it comes to specifying the filter to only show the user resources available at their location, I just can't make this work. (If I could convert the lookup location
Iphone App for lower resolution Images?
Hello, I am developing a Zoho Creator database and I have an image field which I have been using to upload print screens from Iphone. But now I would like to start taking pictures directly from my Iphone then upload from my camera roll into zoho but I get the error "File image.jpg is too large to upload". I understand these images can be big and I know about the 5MB limitation. Does anyone know of a nice and easy Iphone app that will take low res pictures so that I can upload from my iphone camera
New Bugs: Developer Zone
I have noticed the following irregularities: Please note, the developer account is an OLD account (old price list). 1) When app is republished to a client with an old price list account: All seems to work as it should...HOWEVER, when using the "Copy Data" function in the Developer Zone (client side) from the earlier version to the just installed updated version, all looks fine on screen, but in fact NO DATA was copied. 2) When app is republished to a client with a new price list account: After installing
Need Formula field in Subform
Hello, On a sales form I have a subform to track multiple services. In the subform I have the following fields: quantity, description, price, labor and now I need a Sub-Total field but I can't add a formula field to the subform. I was going to add a Formula field called Sub-Total to perform the following calculation in each row: quantity x (price + labor). Then I need a Grand Total to sum up all row sub totals. How can I do this? Your help is greatly appreciated. Iram
Import to Subform does not work with lookup fields
I created Import to insert records into Main form and subform. it works just fine when subform has regular text fields. However, it does not work if subform has "Lookup Filed". Here is how I defined Lookup AUDIBLE_US - Staff - Name (App name - Form name - Field name) And here is what I have on excel file (again, it works just fine with regular field and I know that I can select these values in my subform: 1st sheet: PRODUCT ID Narrator_SubForm TEST3 1,2 2nd Sheet REC LINK ID NarratorSub 1 Alexander,
Simple database issue
I have a simple database I will use to track orders for my own purposes, this has been setup on zoho. I require a solution to this problem on zoho: I have one CSV file like this: SalesRecord, ProductCode, TrackingNumber 1 . A001, 2, A002 3, A002 4, A003 I have another CSV file like this: ProductCode, TrackingNumber A001, XX345 A002, XX346 A003, XX347 I want to import file 1 and then file 2 to have database records like this: SalesRecord, ProductCode, TrackingNumber 1 . A001, XX345 2, A002, XX346
Help: Pay per user of application
For a new app, I am trying to come up with a payment model. A customer buys a Zoho Creator plan to access Creator. I have an app that I want a customer to pay me per user per month for access to the app. Let's say $25 per user per month. How can I implement this functionality so that a customer of my app cannot add their own users?
Date-Time Operators
For some reason Date-Time Operators is missing in the support content even though it is listed in the outline on top of the page (Type of Operators) The content simply skips them. I need to calculate minutes elapsed out of two date-time fields. I tried simply a substraction (DateTimeField2-DateTimeField1) but issues an error of inpropper estatements. Any help? Thanks Luis
Employee Table and "Zoho.Login User"
Hi All, I'm trying to complete a number of tasks within my request manager tool and whilst I can find several threads that go some way to answer some questions I'm still not sure how to implement the following: The tool I am creating is to track requests for PC's to go out to a customer site or for a request to collect some PC's back to our warehouse. We will be using this across a number of different accounts and would ideally like the one tool to track all accounts. We will also have team members
Next Page